| blob | 0361a1af4ef1234f538bf31d6f9870cf8c85417d |
1 /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
2 /*
3 * This file is part of the LibreOffice project.
4 *
5 * This Source Code Form is subject to the terms of the Mozilla Public
6 * License, v. 2.0. If a copy of the MPL was not distributed with this
7 * file, You can obtain one at http://mozilla.org/MPL/2.0/.
8 *
9 * This file incorporates work covered by the following license notice:
10 *
11 * Licensed to the Apache Software Foundation (ASF) under one or more
12 * contributor license agreements. See the NOTICE file distributed
13 * with this work for additional information regarding copyright
14 * ownership. The ASF licenses this file to you under the Apache
15 * License, Version 2.0 (the "License"); you may not use this file
16 * except in compliance with the License. You may obtain a copy of
17 * the License at http://www.apache.org/licenses/LICENSE-2.0 .
18 */
20 #ifndef __com_sun_star_sheet_SheetCellRange_idl__
21 #define __com_sun_star_sheet_SheetCellRange_idl__
65 /** represents a rectangular range of cells in a spreadsheet document.
67 <p>This service is an extension of the CellRange service for use
68 in spreadsheet documents.</p>
69 */
70 published service SheetCellRange
71 {
73 /** provides basic handling of cell ranges and contributes common cell
74 formatting properties.
75 */
79 /** contributes properties for character formatting of Western text.
80 */
84 /** contributes properties for character formatting of Asian text.
85 */
89 /** contributes properties for character formatting of Complex text.
90 */
94 /** contributes properties for paragraph formatting.
95 */
99 /** provides interfaces to find cells with specific properties.
100 */
104 /** provides "Find & Replace" functionality.
106 <p>The property
107 com::sun::star::util::SearchDescriptor::SearchWords
108 has a different meaning in spreadsheets: If set to `TRUE`, the
109 spreadsheet searches for cells containing the search text only.</p>
110 */
114 /** provides merging and unmerging the cells of this cell range.
115 */
119 /** provides modifying the cell indentation.
120 */
124 /** provides access to the collections of columns and rows.
125 */
129 /** provides applying an AutoFormat to the cell range.
130 */
134 /** provides access to the spreadsheet that contains this cell range.
135 */
139 /** provides simultaneous access to the contents of all cells.
140 */
144 /** provides simultaneous access to the formula contents of all cells.
146 @since OOo 1.1.2
147 */
151 /** provides access to the cell range address of this range.
152 */
156 /** provides computation of a value based on the contents of all
157 cells of this range and to clear specific cells.
158 */
162 /** provides filling out the cell range automatically with values based
163 on a start value, step count and fill mode.
164 */
168 /** provides handling of array formulas.
169 */
173 /** provides access to the Multiple Operations feature.
174 */
178 /** provides sorting functionality.
179 */
183 /** provides functionality to import data from external data sources.
185 @see com::sun::star::sheet::DatabaseImportDescriptor
187 */
191 /** provides calculating SubTotal values in this range.
192 */
196 /** provides filtering the contents of this range.
197 */
201 /** provide access to a collection of equal-formatted cell ranges.
202 */
206 /** provide access to a collection of equal-formatted cell ranges.
207 */
211 /** provides modifying the source data cells of a chart and makes
212 it possible to learn about changes in the cell values.
213 */
220 /**
222 @since OOo 2.0
224 */
228 /** contains the position of the top left cell of this range in
229 the sheet (in 1/100 mm).
231 <p>This property contains the absolute position in the whole
232 sheet, not the position in the visible area.</p>
233 */
237 /** contains the size of this range (in 1/100 mm).
238 */
242 /** contains the conditional formatting settings for this cell.
244 <p>After a conditional format has been changed it has to be
245 reinserted into the property set.</p>
247 @see com::sun::star::sheet::TableConditionalFormat
248 */
250 ConditionalFormat;
253 /** contains the conditional formatting settings for this cell,
254 using localized formulas.
256 <p>After a conditional format has been changed it has to be
257 reinserted into the property set.</p>
259 @see com::sun::star::sheet::TableConditionalFormat
260 */
262 ConditionalFormatLocal;
265 /** contains the data validation settings for this cell.
267 <p>After the data validation settings have been changed the
268 validation has to be reinserted into the property set.</p>
270 @see com::sun::star::sheet::TableValidation
271 */
275 /** contains the data validation settings for this cell,
276 using localized formulas.
278 <p>After the data validation settings have been changed the
279 validation has to be reinserted into the property set.</p>
281 @see com::sun::star::sheet::TableValidation
282 */
286 /** Returns the absolute address of the range as string, e.g. "$Sheet1.$B$2:$D$5".
287 */
289 };
292 }; }; }; };
294 #endif
296 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */