Overview | Module | Use | Devguide | Index

Methods' Summary | Methods' Details | Attributes' Summary | Attributes' Details

:: com :: sun :: star :: sheet ::
interface XFormulaQuery
  Base Hierarchy
      ::com::sun::star::uno::XInterface
       |
       +-XFormulaQuery
Description provides methods to query cells for dependencies in formulas. All methods return a collection of cell ranges. See also SheetRangesQuery See also SheetCellRanges Developers Guide 8.3.3 Spreadsheet Documents - Working with Spreadsheet Documents - Navigating - 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 © 2003 Sun Microsystems, Inc.