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 © 2012, 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.