1*cdf0e10cSrcweir/************************************************************************* 2*cdf0e10cSrcweir * 3*cdf0e10cSrcweir * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 4*cdf0e10cSrcweir * 5*cdf0e10cSrcweir * Copyright 2000, 2010 Oracle and/or its affiliates. 6*cdf0e10cSrcweir * 7*cdf0e10cSrcweir * OpenOffice.org - a multi-platform office productivity suite 8*cdf0e10cSrcweir * 9*cdf0e10cSrcweir * This file is part of OpenOffice.org. 10*cdf0e10cSrcweir * 11*cdf0e10cSrcweir * OpenOffice.org is free software: you can redistribute it and/or modify 12*cdf0e10cSrcweir * it under the terms of the GNU Lesser General Public License version 3 13*cdf0e10cSrcweir * only, as published by the Free Software Foundation. 14*cdf0e10cSrcweir * 15*cdf0e10cSrcweir * OpenOffice.org is distributed in the hope that it will be useful, 16*cdf0e10cSrcweir * but WITHOUT ANY WARRANTY; without even the implied warranty of 17*cdf0e10cSrcweir * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 18*cdf0e10cSrcweir * GNU Lesser General Public License version 3 for more details 19*cdf0e10cSrcweir * (a copy is included in the LICENSE file that accompanied this code). 20*cdf0e10cSrcweir * 21*cdf0e10cSrcweir * You should have received a copy of the GNU Lesser General Public License 22*cdf0e10cSrcweir * version 3 along with OpenOffice.org. If not, see 23*cdf0e10cSrcweir * <http://www.openoffice.org/license.html> 24*cdf0e10cSrcweir * for a copy of the LGPLv3 License. 25*cdf0e10cSrcweir * 26*cdf0e10cSrcweir ************************************************************************/ 27*cdf0e10cSrcweir 28*cdf0e10cSrcweir#ifndef __com_sun_star_sheet_SheetCellRange_idl__ 29*cdf0e10cSrcweir#define __com_sun_star_sheet_SheetCellRange_idl__ 30*cdf0e10cSrcweir 31*cdf0e10cSrcweir 32*cdf0e10cSrcweir#ifndef __com_sun_star_table_CellRange_idl__ 33*cdf0e10cSrcweir#include <com/sun/star/table/CellRange.idl> 34*cdf0e10cSrcweir#endif 35*cdf0e10cSrcweir 36*cdf0e10cSrcweir#ifndef __com_sun_star_style_CharacterProperties_idl__ 37*cdf0e10cSrcweir#include <com/sun/star/style/CharacterProperties.idl> 38*cdf0e10cSrcweir#endif 39*cdf0e10cSrcweir 40*cdf0e10cSrcweir#ifndef __com_sun_star_style_CharacterPropertiesAsian_idl__ 41*cdf0e10cSrcweir#include <com/sun/star/style/CharacterPropertiesAsian.idl> 42*cdf0e10cSrcweir#endif 43*cdf0e10cSrcweir 44*cdf0e10cSrcweir#ifndef __com_sun_star_style_CharacterPropertiesComplex_idl__ 45*cdf0e10cSrcweir#include <com/sun/star/style/CharacterPropertiesComplex.idl> 46*cdf0e10cSrcweir#endif 47*cdf0e10cSrcweir 48*cdf0e10cSrcweir#ifndef __com_sun_star_style_ParagraphProperties_idl__ 49*cdf0e10cSrcweir#include <com/sun/star/style/ParagraphProperties.idl> 50*cdf0e10cSrcweir#endif 51*cdf0e10cSrcweir 52*cdf0e10cSrcweir#ifndef __com_sun_star_sheet_SheetRangesQuery_idl__ 53*cdf0e10cSrcweir#include <com/sun/star/sheet/SheetRangesQuery.idl> 54*cdf0e10cSrcweir#endif 55*cdf0e10cSrcweir 56*cdf0e10cSrcweir 57*cdf0e10cSrcweir#ifndef __com_sun_star_util_XReplaceable_idl__ 58*cdf0e10cSrcweir#include <com/sun/star/util/XReplaceable.idl> 59*cdf0e10cSrcweir#endif 60*cdf0e10cSrcweir 61*cdf0e10cSrcweir#ifndef __com_sun_star_util_XMergeable_idl__ 62*cdf0e10cSrcweir#include <com/sun/star/util/XMergeable.idl> 63*cdf0e10cSrcweir#endif 64*cdf0e10cSrcweir 65*cdf0e10cSrcweir#ifndef __com_sun_star_util_XIndent_idl__ 66*cdf0e10cSrcweir#include <com/sun/star/util/XIndent.idl> 67*cdf0e10cSrcweir#endif 68*cdf0e10cSrcweir 69*cdf0e10cSrcweir#ifndef __com_sun_star_table_XColumnRowRange_idl__ 70*cdf0e10cSrcweir#include <com/sun/star/table/XColumnRowRange.idl> 71*cdf0e10cSrcweir#endif 72*cdf0e10cSrcweir 73*cdf0e10cSrcweir#ifndef __com_sun_star_table_XAutoFormattable_idl__ 74*cdf0e10cSrcweir#include <com/sun/star/table/XAutoFormattable.idl> 75*cdf0e10cSrcweir#endif 76*cdf0e10cSrcweir 77*cdf0e10cSrcweir#ifndef __com_sun_star_sheet_XSheetCellRange_idl__ 78*cdf0e10cSrcweir#include <com/sun/star/sheet/XSheetCellRange.idl> 79*cdf0e10cSrcweir#endif 80*cdf0e10cSrcweir 81*cdf0e10cSrcweir#ifndef __com_sun_star_sheet_XCellRangeData_idl__ 82*cdf0e10cSrcweir#include <com/sun/star/sheet/XCellRangeData.idl> 83*cdf0e10cSrcweir#endif 84*cdf0e10cSrcweir 85*cdf0e10cSrcweir#ifndef __com_sun_star_sheet_XCellRangeFormula_idl__ 86*cdf0e10cSrcweir#include <com/sun/star/sheet/XCellRangeFormula.idl> 87*cdf0e10cSrcweir#endif 88*cdf0e10cSrcweir 89*cdf0e10cSrcweir#ifndef __com_sun_star_sheet_XCellRangeAddressable_idl__ 90*cdf0e10cSrcweir#include <com/sun/star/sheet/XCellRangeAddressable.idl> 91*cdf0e10cSrcweir#endif 92*cdf0e10cSrcweir 93*cdf0e10cSrcweir#ifndef __com_sun_star_sheet_XSheetOperation_idl__ 94*cdf0e10cSrcweir#include <com/sun/star/sheet/XSheetOperation.idl> 95*cdf0e10cSrcweir#endif 96*cdf0e10cSrcweir 97*cdf0e10cSrcweir#ifndef __com_sun_star_sheet_XCellSeries_idl__ 98*cdf0e10cSrcweir#include <com/sun/star/sheet/XCellSeries.idl> 99*cdf0e10cSrcweir#endif 100*cdf0e10cSrcweir 101*cdf0e10cSrcweir#ifndef __com_sun_star_sheet_XArrayFormulaRange_idl__ 102*cdf0e10cSrcweir#include <com/sun/star/sheet/XArrayFormulaRange.idl> 103*cdf0e10cSrcweir#endif 104*cdf0e10cSrcweir 105*cdf0e10cSrcweir#ifndef __com_sun_star_sheet_XMultipleOperation_idl__ 106*cdf0e10cSrcweir#include <com/sun/star/sheet/XMultipleOperation.idl> 107*cdf0e10cSrcweir#endif 108*cdf0e10cSrcweir 109*cdf0e10cSrcweir#ifndef __com_sun_star_util_XSortable_idl__ 110*cdf0e10cSrcweir#include <com/sun/star/util/XSortable.idl> 111*cdf0e10cSrcweir#endif 112*cdf0e10cSrcweir 113*cdf0e10cSrcweir#ifndef __com_sun_star_util_XImportable_idl__ 114*cdf0e10cSrcweir#include <com/sun/star/util/XImportable.idl> 115*cdf0e10cSrcweir#endif 116*cdf0e10cSrcweir 117*cdf0e10cSrcweir#ifndef __com_sun_star_sheet_XSubTotalCalculatable_idl__ 118*cdf0e10cSrcweir#include <com/sun/star/sheet/XSubTotalCalculatable.idl> 119*cdf0e10cSrcweir#endif 120*cdf0e10cSrcweir 121*cdf0e10cSrcweir#ifndef __com_sun_star_sheet_XSheetFilterableEx_idl__ 122*cdf0e10cSrcweir#include <com/sun/star/sheet/XSheetFilterableEx.idl> 123*cdf0e10cSrcweir#endif 124*cdf0e10cSrcweir 125*cdf0e10cSrcweir#ifndef __com_sun_star_sheet_XCellFormatRangesSupplier_idl__ 126*cdf0e10cSrcweir#include <com/sun/star/sheet/XCellFormatRangesSupplier.idl> 127*cdf0e10cSrcweir#endif 128*cdf0e10cSrcweir 129*cdf0e10cSrcweir#ifndef __com_sun_star_sheet_XUniqueCellFormatRangesSupplier_idl__ 130*cdf0e10cSrcweir#include <com/sun/star/sheet/XUniqueCellFormatRangesSupplier.idl> 131*cdf0e10cSrcweir#endif 132*cdf0e10cSrcweir 133*cdf0e10cSrcweir#ifndef __com_sun_star_chart_XChartDataArray_idl__ 134*cdf0e10cSrcweir#include <com/sun/star/chart/XChartDataArray.idl> 135*cdf0e10cSrcweir#endif 136*cdf0e10cSrcweir 137*cdf0e10cSrcweir 138*cdf0e10cSrcweir#ifndef __com_sun_star_awt_Point_idl__ 139*cdf0e10cSrcweir#include <com/sun/star/awt/Point.idl> 140*cdf0e10cSrcweir#endif 141*cdf0e10cSrcweir 142*cdf0e10cSrcweir#ifndef __com_sun_star_awt_Size_idl__ 143*cdf0e10cSrcweir#include <com/sun/star/awt/Size.idl> 144*cdf0e10cSrcweir#endif 145*cdf0e10cSrcweir 146*cdf0e10cSrcweir#ifndef __com_sun_star_sheet_XSheetConditionalEntries_idl__ 147*cdf0e10cSrcweir#include <com/sun/star/sheet/XSheetConditionalEntries.idl> 148*cdf0e10cSrcweir#endif 149*cdf0e10cSrcweir 150*cdf0e10cSrcweir#ifndef __com_sun_star_beans_XPropertySet_idl__ 151*cdf0e10cSrcweir#include <com/sun/star/beans/XPropertySet.idl> 152*cdf0e10cSrcweir#endif 153*cdf0e10cSrcweir 154*cdf0e10cSrcweir#ifndef __com_sun_star_beans_XTolerantMultiPropertySet_idl__ 155*cdf0e10cSrcweir#include <com/sun/star/beans/XTolerantMultiPropertySet.idl> 156*cdf0e10cSrcweir#endif 157*cdf0e10cSrcweir 158*cdf0e10cSrcweir#ifndef __com_sun_star_util_XModifyBroadcaster_idl__ 159*cdf0e10cSrcweir#include <com/sun/star/util/XModifyBroadcaster.idl> 160*cdf0e10cSrcweir#endif 161*cdf0e10cSrcweir 162*cdf0e10cSrcweir//============================================================================= 163*cdf0e10cSrcweir 164*cdf0e10cSrcweirmodule com { module sun { module star { module sheet { 165*cdf0e10cSrcweir 166*cdf0e10cSrcweir//============================================================================= 167*cdf0e10cSrcweir 168*cdf0e10cSrcweir/** represents a rectangular range of cells in a spreadsheet document. 169*cdf0e10cSrcweir 170*cdf0e10cSrcweir <p>This service is an extension of the CellRange service for use 171*cdf0e10cSrcweir in spreadsheet documents.</p> 172*cdf0e10cSrcweir */ 173*cdf0e10cSrcweirpublished service SheetCellRange 174*cdf0e10cSrcweir{ 175*cdf0e10cSrcweir //------------------------------------------------------------------------- 176*cdf0e10cSrcweir 177*cdf0e10cSrcweir /** provides basic handling of cell ranges and contributes common cell 178*cdf0e10cSrcweir formatting properties. 179*cdf0e10cSrcweir */ 180*cdf0e10cSrcweir service com::sun::star::table::CellRange; 181*cdf0e10cSrcweir 182*cdf0e10cSrcweir //------------------------------------------------------------------------- 183*cdf0e10cSrcweir 184*cdf0e10cSrcweir /** contributes properties for character formatting of Western text. 185*cdf0e10cSrcweir */ 186*cdf0e10cSrcweir service com::sun::star::style::CharacterProperties; 187*cdf0e10cSrcweir 188*cdf0e10cSrcweir //------------------------------------------------------------------------- 189*cdf0e10cSrcweir 190*cdf0e10cSrcweir /** contributes properties for character formatting of Asian text. 191*cdf0e10cSrcweir */ 192*cdf0e10cSrcweir service com::sun::star::style::CharacterPropertiesAsian; 193*cdf0e10cSrcweir 194*cdf0e10cSrcweir //------------------------------------------------------------------------- 195*cdf0e10cSrcweir 196*cdf0e10cSrcweir /** contributes properties for character formatting of Complex text. 197*cdf0e10cSrcweir */ 198*cdf0e10cSrcweir service com::sun::star::style::CharacterPropertiesComplex; 199*cdf0e10cSrcweir 200*cdf0e10cSrcweir //------------------------------------------------------------------------- 201*cdf0e10cSrcweir 202*cdf0e10cSrcweir /** contributes properties for paragraph formatting. 203*cdf0e10cSrcweir */ 204*cdf0e10cSrcweir service com::sun::star::style::ParagraphProperties; 205*cdf0e10cSrcweir 206*cdf0e10cSrcweir //------------------------------------------------------------------------- 207*cdf0e10cSrcweir 208*cdf0e10cSrcweir /** provides interfaces to find cells with specific properties. 209*cdf0e10cSrcweir */ 210*cdf0e10cSrcweir service com::sun::star::sheet::SheetRangesQuery; 211*cdf0e10cSrcweir 212*cdf0e10cSrcweir //========================================================================= 213*cdf0e10cSrcweir 214*cdf0e10cSrcweir /** provides "Find & Replace" functionality. 215*cdf0e10cSrcweir 216*cdf0e10cSrcweir <p>The property 217*cdf0e10cSrcweir <member scope="com::sun::star::util">SearchDescriptor::SearchWords</member> 218*cdf0e10cSrcweir has a different meaning in spreadsheets: If set to <TRUE/>, the 219*cdf0e10cSrcweir spreadsheet searches for cells containing the serch text only.</p> 220*cdf0e10cSrcweir */ 221*cdf0e10cSrcweir interface com::sun::star::util::XReplaceable; 222*cdf0e10cSrcweir 223*cdf0e10cSrcweir //------------------------------------------------------------------------- 224*cdf0e10cSrcweir 225*cdf0e10cSrcweir /** provides merging and unmerging the cells of this cell range. 226*cdf0e10cSrcweir */ 227*cdf0e10cSrcweir interface com::sun::star::util::XMergeable; 228*cdf0e10cSrcweir 229*cdf0e10cSrcweir //------------------------------------------------------------------------- 230*cdf0e10cSrcweir 231*cdf0e10cSrcweir /** provides modifying the cell indentation. 232*cdf0e10cSrcweir */ 233*cdf0e10cSrcweir interface com::sun::star::util::XIndent; 234*cdf0e10cSrcweir 235*cdf0e10cSrcweir //------------------------------------------------------------------------- 236*cdf0e10cSrcweir 237*cdf0e10cSrcweir /** provides access to the collections of columns and rows. 238*cdf0e10cSrcweir */ 239*cdf0e10cSrcweir interface com::sun::star::table::XColumnRowRange; 240*cdf0e10cSrcweir 241*cdf0e10cSrcweir //------------------------------------------------------------------------- 242*cdf0e10cSrcweir 243*cdf0e10cSrcweir /** provides applying an AutoFormat to the cell range. 244*cdf0e10cSrcweir */ 245*cdf0e10cSrcweir interface com::sun::star::table::XAutoFormattable; 246*cdf0e10cSrcweir 247*cdf0e10cSrcweir //------------------------------------------------------------------------- 248*cdf0e10cSrcweir 249*cdf0e10cSrcweir /** provides access to the spreadsheet that contains this cell range. 250*cdf0e10cSrcweir */ 251*cdf0e10cSrcweir interface com::sun::star::sheet::XSheetCellRange; 252*cdf0e10cSrcweir 253*cdf0e10cSrcweir //------------------------------------------------------------------------- 254*cdf0e10cSrcweir 255*cdf0e10cSrcweir /** provides simultaneous access to the contents of all cells. 256*cdf0e10cSrcweir */ 257*cdf0e10cSrcweir interface com::sun::star::sheet::XCellRangeData; 258*cdf0e10cSrcweir 259*cdf0e10cSrcweir //------------------------------------------------------------------------- 260*cdf0e10cSrcweir 261*cdf0e10cSrcweir /** provides simultaneous access to the formula contents of all cells. 262*cdf0e10cSrcweir 263*cdf0e10cSrcweir @since OOo 1.1.2 264*cdf0e10cSrcweir */ 265*cdf0e10cSrcweir [optional] interface com::sun::star::sheet::XCellRangeFormula; 266*cdf0e10cSrcweir 267*cdf0e10cSrcweir //------------------------------------------------------------------------- 268*cdf0e10cSrcweir 269*cdf0e10cSrcweir /** provides access to the cell range address of this range. 270*cdf0e10cSrcweir */ 271*cdf0e10cSrcweir interface com::sun::star::sheet::XCellRangeAddressable; 272*cdf0e10cSrcweir 273*cdf0e10cSrcweir //------------------------------------------------------------------------- 274*cdf0e10cSrcweir 275*cdf0e10cSrcweir /** provides computation of a value based on the contents of all 276*cdf0e10cSrcweir cells of this range and to clear specific cells. 277*cdf0e10cSrcweir */ 278*cdf0e10cSrcweir interface com::sun::star::sheet::XSheetOperation; 279*cdf0e10cSrcweir 280*cdf0e10cSrcweir //------------------------------------------------------------------------- 281*cdf0e10cSrcweir 282*cdf0e10cSrcweir /** provides filling out the cell range automatically with values based 283*cdf0e10cSrcweir on a start value, step count and fill mode. 284*cdf0e10cSrcweir */ 285*cdf0e10cSrcweir interface com::sun::star::sheet::XCellSeries; 286*cdf0e10cSrcweir 287*cdf0e10cSrcweir //------------------------------------------------------------------------- 288*cdf0e10cSrcweir 289*cdf0e10cSrcweir /** provides handling of array formulas. 290*cdf0e10cSrcweir */ 291*cdf0e10cSrcweir interface com::sun::star::sheet::XArrayFormulaRange; 292*cdf0e10cSrcweir 293*cdf0e10cSrcweir //------------------------------------------------------------------------- 294*cdf0e10cSrcweir 295*cdf0e10cSrcweir /** provides access to the Multiple Operations feature. 296*cdf0e10cSrcweir */ 297*cdf0e10cSrcweir interface com::sun::star::sheet::XMultipleOperation; 298*cdf0e10cSrcweir 299*cdf0e10cSrcweir //------------------------------------------------------------------------- 300*cdf0e10cSrcweir 301*cdf0e10cSrcweir /** provides sorting functionality. 302*cdf0e10cSrcweir */ 303*cdf0e10cSrcweir interface com::sun::star::util::XSortable; 304*cdf0e10cSrcweir 305*cdf0e10cSrcweir //------------------------------------------------------------------------- 306*cdf0e10cSrcweir 307*cdf0e10cSrcweir /** provides functionality to import data from external data sources. 308*cdf0e10cSrcweir 309*cdf0e10cSrcweir @see com::sun::star::sheet::DatabaseImportDescriptor 310*cdf0e10cSrcweir 311*cdf0e10cSrcweir */ 312*cdf0e10cSrcweir interface com::sun::star::util::XImportable; 313*cdf0e10cSrcweir 314*cdf0e10cSrcweir //------------------------------------------------------------------------- 315*cdf0e10cSrcweir 316*cdf0e10cSrcweir /** provides calculating SubTotal values in this range. 317*cdf0e10cSrcweir */ 318*cdf0e10cSrcweir interface com::sun::star::sheet::XSubTotalCalculatable; 319*cdf0e10cSrcweir 320*cdf0e10cSrcweir //------------------------------------------------------------------------- 321*cdf0e10cSrcweir 322*cdf0e10cSrcweir /** provides filtering the contents of this range. 323*cdf0e10cSrcweir */ 324*cdf0e10cSrcweir interface com::sun::star::sheet::XSheetFilterableEx; 325*cdf0e10cSrcweir 326*cdf0e10cSrcweir //------------------------------------------------------------------------- 327*cdf0e10cSrcweir 328*cdf0e10cSrcweir /** provide access to a collection of equal-formatted cell ranges. 329*cdf0e10cSrcweir */ 330*cdf0e10cSrcweir interface com::sun::star::sheet::XCellFormatRangesSupplier; 331*cdf0e10cSrcweir 332*cdf0e10cSrcweir //------------------------------------------------------------------------- 333*cdf0e10cSrcweir 334*cdf0e10cSrcweir /** provide access to a collection of equal-formatted cell ranges. 335*cdf0e10cSrcweir */ 336*cdf0e10cSrcweir interface com::sun::star::sheet::XUniqueCellFormatRangesSupplier; 337*cdf0e10cSrcweir 338*cdf0e10cSrcweir //------------------------------------------------------------------------- 339*cdf0e10cSrcweir 340*cdf0e10cSrcweir /** provides modifying the source data cells of a chart and makes 341*cdf0e10cSrcweir it possible to learn about changes in the cell values. 342*cdf0e10cSrcweir */ 343*cdf0e10cSrcweir interface com::sun::star::chart::XChartDataArray; 344*cdf0e10cSrcweir 345*cdf0e10cSrcweir //------------------------------------------------------------------------- 346*cdf0e10cSrcweir 347*cdf0e10cSrcweir [optional] interface com::sun::star::beans::XTolerantMultiPropertySet; 348*cdf0e10cSrcweir 349*cdf0e10cSrcweir //------------------------------------------------------------------------- 350*cdf0e10cSrcweir 351*cdf0e10cSrcweir /** 352*cdf0e10cSrcweir 353*cdf0e10cSrcweir @since OOo 2.0 354*cdf0e10cSrcweir 355*cdf0e10cSrcweir */ 356*cdf0e10cSrcweir [optional] interface com::sun::star::util::XModifyBroadcaster; 357*cdf0e10cSrcweir 358*cdf0e10cSrcweir //========================================================================= 359*cdf0e10cSrcweir 360*cdf0e10cSrcweir /** contains the position of the top left cell of this range in 361*cdf0e10cSrcweir the sheet (in 1/100 mm). 362*cdf0e10cSrcweir 363*cdf0e10cSrcweir <p>This property contains the absolute position in the whole 364*cdf0e10cSrcweir sheet, not the position in the visible area.</p> 365*cdf0e10cSrcweir */ 366*cdf0e10cSrcweir [readonly, property] com::sun::star::awt::Point Position; 367*cdf0e10cSrcweir 368*cdf0e10cSrcweir //------------------------------------------------------------------------- 369*cdf0e10cSrcweir 370*cdf0e10cSrcweir /** contains the size of this range (in 1/100 mm). 371*cdf0e10cSrcweir */ 372*cdf0e10cSrcweir [readonly, property] com::sun::star::awt::Size Size; 373*cdf0e10cSrcweir 374*cdf0e10cSrcweir //------------------------------------------------------------------------- 375*cdf0e10cSrcweir 376*cdf0e10cSrcweir /** contains the conditional formatting settings for this cell. 377*cdf0e10cSrcweir 378*cdf0e10cSrcweir <p>After a conditional format has been changed it has to be 379*cdf0e10cSrcweir reinserted into the property set.</p> 380*cdf0e10cSrcweir 381*cdf0e10cSrcweir @see com::sun::star::sheet::TableConditionalFormat 382*cdf0e10cSrcweir */ 383*cdf0e10cSrcweir [property] com::sun::star::sheet::XSheetConditionalEntries 384*cdf0e10cSrcweir ConditionalFormat; 385*cdf0e10cSrcweir 386*cdf0e10cSrcweir //------------------------------------------------------------------------- 387*cdf0e10cSrcweir 388*cdf0e10cSrcweir /** contains the conditional formatting settings for this cell, 389*cdf0e10cSrcweir using localized formulas. 390*cdf0e10cSrcweir 391*cdf0e10cSrcweir <p>After a conditional format has been changed it has to be 392*cdf0e10cSrcweir reinserted into the property set.</p> 393*cdf0e10cSrcweir 394*cdf0e10cSrcweir @see com::sun::star::sheet::TableConditionalFormat 395*cdf0e10cSrcweir */ 396*cdf0e10cSrcweir [optional, property] com::sun::star::sheet::XSheetConditionalEntries 397*cdf0e10cSrcweir ConditionalFormatLocal; 398*cdf0e10cSrcweir 399*cdf0e10cSrcweir //------------------------------------------------------------------------- 400*cdf0e10cSrcweir 401*cdf0e10cSrcweir /** contains the data validation settings for this cell. 402*cdf0e10cSrcweir 403*cdf0e10cSrcweir <p>After the data validation settings have been changed the 404*cdf0e10cSrcweir validation has to be reinserted into the property set.</p> 405*cdf0e10cSrcweir 406*cdf0e10cSrcweir @see com::sun::star::sheet::TableValidation 407*cdf0e10cSrcweir */ 408*cdf0e10cSrcweir [property] com::sun::star::beans::XPropertySet Validation; 409*cdf0e10cSrcweir 410*cdf0e10cSrcweir //------------------------------------------------------------------------- 411*cdf0e10cSrcweir 412*cdf0e10cSrcweir /** contains the data validation settings for this cell, 413*cdf0e10cSrcweir using localized formulas. 414*cdf0e10cSrcweir 415*cdf0e10cSrcweir <p>After the data validation settings have been changed the 416*cdf0e10cSrcweir validation has to be reinserted into the property set.</p> 417*cdf0e10cSrcweir 418*cdf0e10cSrcweir @see com::sun::star::sheet::TableValidation 419*cdf0e10cSrcweir */ 420*cdf0e10cSrcweir [optional, property] com::sun::star::beans::XPropertySet ValidationLocal; 421*cdf0e10cSrcweir 422*cdf0e10cSrcweir //------------------------------------------------------------------------- 423*cdf0e10cSrcweir 424*cdf0e10cSrcweir /** Returns the absolute adress of the range as string, e.g. "$Sheet1.$B$2:$D$5". 425*cdf0e10cSrcweir */ 426*cdf0e10cSrcweir [optional, readonly, property] string AbsoluteName; 427*cdf0e10cSrcweir}; 428*cdf0e10cSrcweir 429*cdf0e10cSrcweir//============================================================================= 430*cdf0e10cSrcweir 431*cdf0e10cSrcweir}; }; }; }; 432*cdf0e10cSrcweir 433*cdf0e10cSrcweir#endif 434*cdf0e10cSrcweir 435