English:

The Free and Open Productivity Suite
New: Apache OpenOffice 4.1.1 released!

Developer's Guide

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

Logo ApacheCon Europe 2014

Apache Feather

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

Apache, the Apache feather logo, and OpenOffice 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.