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