Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

API

SDK

Tips ‘n’ Tricks

Miscellaneous

Overview Module Use Devguide Index
Methods' Summary Attributes' Summary Methods' Details Attributes' Details

:: 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

Copyright © 2013, The Apache Software Foundation, Licensed under the Apache License, Version 2.0. Apache, the Apache feather logo, Apache OpenOffice and OpenOffice.org are trademarks of The Apache Software Foundation. Other names may be trademarks of their respective owners.

Apache Software Foundation

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

Apache, OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.