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 XFormulaQuery
Description
provides methods to query cells for dependencies in formulas.

All methods return a collection of cell ranges.

See also
SheetRangesQuery, SheetCellRanges
Developers Guide
Spreadsheets - Querying for Cells with Specific Properties

Methods' Summary
queryDependents queries all dependent formula cells.  
queryPrecedents queries all precedent cells.  
Methods' Details
queryDependents
XSheetCellRanges
queryDependents( [in] boolean  bRecursive );

Description
queries all dependent formula cells.

Dependent cells are cells containing formulas with references to the original cell.

Parameter bRecursive
false = queries cells dependent from the original range(s), true = repeates query with all found cells (finds dependents of dependents, and so on).
Returns
all dependent cells of any formula cell of the current cell range(s).
queryPrecedents
XSheetCellRanges
queryPrecedents( [in] boolean  bRecursive );

Description
queries all precedent cells.

Precedent cells are cells which are referenced from a formula cell.

Parameter bRecursive
false = queries precedent cells of the original range(s), true = repeates query with all found cells (finds precedents of precedents, and so on).
Returns
all precedent cells of any formula cell of the current cell range(s).
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.