/************************************************************************* * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * * Copyright 2000, 2010 Oracle and/or its affiliates. * * OpenOffice.org - a multi-platform office productivity suite * * This file is part of OpenOffice.org. * * OpenOffice.org is free software: you can redistribute it and/or modify * it under the terms of the GNU Lesser General Public License version 3 * only, as published by the Free Software Foundation. * * OpenOffice.org is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Lesser General Public License version 3 for more details * (a copy is included in the LICENSE file that accompanied this code). * * You should have received a copy of the GNU Lesser General Public License * version 3 along with OpenOffice.org. If not, see * * for a copy of the LGPLv3 License. * ************************************************************************/ #ifndef __com_sun_star_sheet_XFormulaQuery_idl__ #define __com_sun_star_sheet_XFormulaQuery_idl__ #ifndef __com_sun_star_uno_XInterface_idl__ #include #endif #ifndef __com_sun_star_sheet_XSheetCellRanges_idl__ #include #endif //============================================================================= module com { module sun { module star { module sheet { //============================================================================= /** provides methods to query cells for dependencies in formulas.

All methods return a collection of cell ranges.

@see com::sun::star::sheet::SheetRangesQuery @see com::sun::star::sheet::SheetCellRanges */ published interface XFormulaQuery: com::sun::star::uno::XInterface { //------------------------------------------------------------------------- /** queries all dependent formula cells.

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

@param bRecursive = queries cells dependent from the original range(s), = repeates query with all found cells (finds dependents of dependents, and so on). @return all dependent cells of any formula cell of the current cell range(s). */ com::sun::star::sheet::XSheetCellRanges queryDependents( [in] boolean bRecursive ); //------------------------------------------------------------------------- /** queries all precedent cells.

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

@param bRecursive = queries precedent cells of the original range(s), = repeates query with all found cells (finds precedents of precedents, and so on). @return all precedent cells of any formula cell of the current cell range(s). */ com::sun::star::sheet::XSheetCellRanges queryPrecedents( [in] boolean bRecursive ); }; //============================================================================= }; }; }; }; #endif