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