LibreOffice
LibreOffice 24.8 SDK API Reference
 
Loading...
Searching...
No Matches
SheetRangesQuery Service Reference

provides interfaces to find cells with specific properties. More...

import "SheetRangesQuery.idl";

Inheritance diagram for SheetRangesQuery:
XCellRangesQuery XFormulaQuery XInterface XInterface SheetCell SheetCellRange SheetCellRanges SheetCellCursor Spreadsheet

Exported Interfaces

interface com::sun::star::sheet::XCellRangesQuery
 provides methods to query for cell ranges with specific contents.
 
interface com::sun::star::sheet::XFormulaQuery
 provides methods to find dependent cells of formula cells.
 

Additional Inherited Members

- Public Member Functions inherited from XCellRangesQuery
com::sun::star::sheet::XSheetCellRanges queryVisibleCells ()
 queries all visible cells.
 
com::sun::star::sheet::XSheetCellRanges queryEmptyCells ()
 queries all empty cells.
 
com::sun::star::sheet::XSheetCellRanges queryContentCells ([in] short nContentFlags)
 queries all cells with the specified content type(s).
 
com::sun::star::sheet::XSheetCellRanges queryFormulaCells ([in] long nResultFlags)
 queries all formula cells with the specified result type.
 
com::sun::star::sheet::XSheetCellRanges queryColumnDifferences ([in] com::sun::star::table::CellAddress aCompare)
 queries all cells with different values in a specified row.
 
com::sun::star::sheet::XSheetCellRanges queryRowDifferences ([in] com::sun::star::table::CellAddress aCompare)
 queries all cells with different values in a specified column.
 
com::sun::star::sheet::XSheetCellRanges queryIntersection ([in] com::sun::star::table::CellRangeAddress aRange)
 intersects the current cell range(s) with the specified cell range.
 
- Public Member Functions inherited from XInterface
any queryInterface ([in] type aType)
 queries for a new interface to an existing UNO object.
 
void acquire ()
 increases the reference counter by one.
 
void release ()
 decreases the reference counter by one.
 
- Public Member Functions inherited from XFormulaQuery
com::sun::star::sheet::XSheetCellRanges queryDependents ([in] boolean bRecursive)
 queries all dependent formula cells.
 
com::sun::star::sheet::XSheetCellRanges queryPrecedents ([in] boolean bRecursive)
 queries all precedent cells.
 

Detailed Description

provides interfaces to find cells with specific properties.

Developers Guide
Spreadsheet Documents - Querying for Cells with Specific Properties

Exported Interfaces

◆ com::sun::star::sheet::XCellRangesQuery

provides methods to query for cell ranges with specific contents.

◆ com::sun::star::sheet::XFormulaQuery

provides methods to find dependent cells of formula cells.


The documentation for this service was generated from the following files: