Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.11

API

SDK

Tips ‘n’ Tricks

Miscellaneous


:: 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 Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.