1*d1766043SAndrew Rist/************************************************************** 2cdf0e10cSrcweir * 3*d1766043SAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 4*d1766043SAndrew Rist * or more contributor license agreements. See the NOTICE file 5*d1766043SAndrew Rist * distributed with this work for additional information 6*d1766043SAndrew Rist * regarding copyright ownership. The ASF licenses this file 7*d1766043SAndrew Rist * to you under the Apache License, Version 2.0 (the 8*d1766043SAndrew Rist * "License"); you may not use this file except in compliance 9*d1766043SAndrew Rist * with the License. You may obtain a copy of the License at 10*d1766043SAndrew Rist * 11*d1766043SAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 12*d1766043SAndrew Rist * 13*d1766043SAndrew Rist * Unless required by applicable law or agreed to in writing, 14*d1766043SAndrew Rist * software distributed under the License is distributed on an 15*d1766043SAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16*d1766043SAndrew Rist * KIND, either express or implied. See the License for the 17*d1766043SAndrew Rist * specific language governing permissions and limitations 18*d1766043SAndrew Rist * under the License. 19*d1766043SAndrew Rist * 20*d1766043SAndrew Rist *************************************************************/ 21*d1766043SAndrew Rist 22*d1766043SAndrew Rist 23cdf0e10cSrcweir 24cdf0e10cSrcweir#ifndef __com_sun_star_sheet_XFormulaQuery_idl__ 25cdf0e10cSrcweir#define __com_sun_star_sheet_XFormulaQuery_idl__ 26cdf0e10cSrcweir 27cdf0e10cSrcweir#ifndef __com_sun_star_uno_XInterface_idl__ 28cdf0e10cSrcweir#include <com/sun/star/uno/XInterface.idl> 29cdf0e10cSrcweir#endif 30cdf0e10cSrcweir 31cdf0e10cSrcweir#ifndef __com_sun_star_sheet_XSheetCellRanges_idl__ 32cdf0e10cSrcweir#include <com/sun/star/sheet/XSheetCellRanges.idl> 33cdf0e10cSrcweir#endif 34cdf0e10cSrcweir 35cdf0e10cSrcweir//============================================================================= 36cdf0e10cSrcweir 37cdf0e10cSrcweirmodule com { module sun { module star { module sheet { 38cdf0e10cSrcweir 39cdf0e10cSrcweir//============================================================================= 40cdf0e10cSrcweir 41cdf0e10cSrcweir/** provides methods to query cells for dependencies 42cdf0e10cSrcweir in formulas. 43cdf0e10cSrcweir 44cdf0e10cSrcweir <p>All methods return a collection of cell ranges.</p> 45cdf0e10cSrcweir 46cdf0e10cSrcweir @see com::sun::star::sheet::SheetRangesQuery 47cdf0e10cSrcweir @see com::sun::star::sheet::SheetCellRanges 48cdf0e10cSrcweir */ 49cdf0e10cSrcweirpublished interface XFormulaQuery: com::sun::star::uno::XInterface 50cdf0e10cSrcweir{ 51cdf0e10cSrcweir //------------------------------------------------------------------------- 52cdf0e10cSrcweir 53cdf0e10cSrcweir /** queries all dependent formula cells. 54cdf0e10cSrcweir 55cdf0e10cSrcweir <p>Dependent cells are cells containing formulas with references to 56cdf0e10cSrcweir the original cell.</p> 57cdf0e10cSrcweir 58cdf0e10cSrcweir @param bRecursive 59cdf0e10cSrcweir <FALSE/> = queries cells dependent from the original range(s), 60cdf0e10cSrcweir <TRUE/> = repeates query with all found cells 61cdf0e10cSrcweir (finds dependents of dependents, and so on). 62cdf0e10cSrcweir 63cdf0e10cSrcweir @return 64cdf0e10cSrcweir all dependent cells of any formula cell of the current 65cdf0e10cSrcweir cell range(s). 66cdf0e10cSrcweir */ 67cdf0e10cSrcweir com::sun::star::sheet::XSheetCellRanges queryDependents( 68cdf0e10cSrcweir [in] boolean bRecursive ); 69cdf0e10cSrcweir 70cdf0e10cSrcweir //------------------------------------------------------------------------- 71cdf0e10cSrcweir 72cdf0e10cSrcweir /** queries all precedent cells. 73cdf0e10cSrcweir 74cdf0e10cSrcweir <p>Precedent cells are cells which are referenced from a formula 75cdf0e10cSrcweir cell.</p> 76cdf0e10cSrcweir 77cdf0e10cSrcweir @param bRecursive 78cdf0e10cSrcweir <FALSE/> = queries precedent cells of the original range(s), 79cdf0e10cSrcweir <TRUE/> = repeates query with all found cells 80cdf0e10cSrcweir (finds precedents of precedents, and so on). 81cdf0e10cSrcweir 82cdf0e10cSrcweir @return 83cdf0e10cSrcweir all precedent cells of any formula cell of the current cell 84cdf0e10cSrcweir range(s). 85cdf0e10cSrcweir */ 86cdf0e10cSrcweir com::sun::star::sheet::XSheetCellRanges queryPrecedents( 87cdf0e10cSrcweir [in] boolean bRecursive ); 88cdf0e10cSrcweir 89cdf0e10cSrcweir}; 90cdf0e10cSrcweir 91cdf0e10cSrcweir//============================================================================= 92cdf0e10cSrcweir 93cdf0e10cSrcweir}; }; }; }; 94cdf0e10cSrcweir 95cdf0e10cSrcweir#endif 96cdf0e10cSrcweir 97