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

provides methods to execute operations on a cell range or ranges. More...

import"XSheetOperation.idl";

Inheritance diagram for XSheetOperation:
XInterface SheetCellRange SheetCellRanges SheetCellCursor Spreadsheet

Public Member Functions

double computeFunction ([in] com::sun::star::sheet::GeneralFunction nFunction) raises ( com::sun::star::uno::Exception )
 computes a general function based on all cells in the current cell range(s), excluding values from filtered and hidden rows and hidden columns as done for the status bar. More...
 
void clearContents ([in] long nContentFlags)
 unnecessary 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 execute operations on a cell range or ranges.

See also
com::sun::star::sheet::SheetCellRange
com::sun::star::sheet::SheetCellRanges
Developers Guide
Spreadsheet Documents - Operations

Member Function Documentation

◆ clearContents()

void clearContents ( [in] long  nContentFlags)

unnecessary

clears the specified contents of the current cell range(s).

Parameters
nContentFlagsa combination of CellFlags flags selecting the contents to be deleted.

◆ computeFunction()

double computeFunction ( [in] com::sun::star::sheet::GeneralFunction  nFunction)
raises (com::sun::star::uno::Exception
)

computes a general function based on all cells in the current cell range(s), excluding values from filtered and hidden rows and hidden columns as done for the status bar.

Parameters
nFunctionis the function used to compute the result.
Returns
the result of the calculation.

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