(incubating) | The Free and Open Productivity Suite

Developer's Guide

API

SDK

Tips 'n' Tricks

Miscellaneous

Content for OpenOffice.org version 3.3.

:: com :: sun :: star :: sheet ::

interface XCellSeries
Description
provides methods to fill out a cell range automatically with values based on a start value, step count and fill mode.
See also
SheetCellRange
Developers Guide
Spreadsheets - Fill Series

Methods' Summary
fillSeries fills all cells in the range based on the specified settings.  
fillAuto fills all cells in the range in a way that is specified by the first cell(s) in the range.  
Methods' Details
fillSeries
void
fillSeries( [in] FillDirection  nFillDirection,
[in] FillMode  nFillMode,
[in] FillDateMode  nFillDateMode,
[in] double  fStep,
[in] double  fEndValue );

Description
fills all cells in the range based on the specified settings.
Parameter nFillDirection
specifies the direction to fill the rows/columns of the range.
Parameter nFillMode
specifies the type of the series.
Parameter nFillDateMode
specifies the calculation mode for date values.
Parameter fStep
contains the value used to increase/decrease the series values.
Parameter fEndValue
contains the threshold value on which the calculation of the current series stops.
fillAuto
void
fillAuto( [in] FillDirection  nFillDirection,
[in] long  nSourceCount );

Description
fills all cells in the range in a way that is specified by the first cell(s) in the range.
Parameter nFillDirection
specifies the direction to fill the rows/columns of the range.
Parameter nSourceCount
contains the number of cells in each row/column used to constitute the fill algorithm.
Top of Page

Apache OpenOffice is an effort undergoing incubation at The Apache Software Foundation (ASF), sponsored by the Apache Incubator. Incubation is required of all newly accepted projects until a further review indicates that the infrastructure, communications, and decision making process have stabilized in a manner consistent with other successful ASF projects. While incubation status is not necessarily a reflection of the completeness or stability of the code, it does indicate that the project has yet to be fully endorsed by the ASF.

Copyright & License
Apache and the Apache feather logos are trademarks of The Apache Software Foundation. OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.