LibreOffice
LibreOffice 24.2 SDK API Reference
Public Member Functions | List of all members
XCellSeries Interface Referencepublished

provides methods to fill out a cell range automatically with values based on a start value, step count and fill mode. More...

import"XCellSeries.idl";

Inheritance diagram for XCellSeries:
XInterface SheetCellRange SheetCellCursor Spreadsheet

Public Member Functions

void fillSeries ([in] com::sun::star::sheet::FillDirection nFillDirection, [in] com::sun::star::sheet::FillMode nFillMode, [in] com::sun::star::sheet::FillDateMode nFillDateMode, [in] double fStep, [in] double fEndValue)
 fills all cells in the range based on the specified settings. More...
 
void fillAuto ([in] com::sun::star::sheet::FillDirection nFillDirection, [in] long nSourceCount)
 fills all cells in the range in a way that is specified by the first cell(s) in the range. More...
 
- Public Member Functions inherited from XInterface
any queryInterface ([in] type aType)
 queries for a new interface to an existing UNO object. More...
 
void acquire ()
 increases the reference counter by one. More...
 
void release ()
 decreases the reference counter by one. More...
 

Detailed Description

provides methods to fill out a cell range automatically with values based on a start value, step count and fill mode.

See also
com::sun::star::sheet::SheetCellRange
Developers Guide
Spreadsheet Documents - Fill Series

Member Function Documentation

◆ fillAuto()

void fillAuto ( [in] com::sun::star::sheet::FillDirection  nFillDirection,
[in] long  nSourceCount 
)

fills all cells in the range in a way that is specified by the first cell(s) in the range.

Parameters
nFillDirectionspecifies the direction to fill the rows/columns of the range.
nSourceCountcontains the number of cells in each row/column used to constitute the fill algorithm.

◆ fillSeries()

void fillSeries ( [in] com::sun::star::sheet::FillDirection  nFillDirection,
[in] com::sun::star::sheet::FillMode  nFillMode,
[in] com::sun::star::sheet::FillDateMode  nFillDateMode,
[in] double  fStep,
[in] double  fEndValue 
)

fills all cells in the range based on the specified settings.

Parameters
nFillDirectionspecifies the direction to fill the rows/columns of the range.
nFillModespecifies the type of the series.
nFillDateModespecifies the calculation mode for date values.
fStepcontains the value used to increase/decrease the series values.
fEndValuecontains the threshold value on which the calculation of the current series stops.

The documentation for this interface was generated from the following file: