1/************************************************************** 2 * 3 * Licensed to the Apache Software Foundation (ASF) under one 4 * or more contributor license agreements. See the NOTICE file 5 * distributed with this work for additional information 6 * regarding copyright ownership. The ASF licenses this file 7 * to you under the Apache License, Version 2.0 (the 8 * "License"); you may not use this file except in compliance 9 * with the License. You may obtain a copy of the License at 10 * 11 * http://www.apache.org/licenses/LICENSE-2.0 12 * 13 * Unless required by applicable law or agreed to in writing, 14 * software distributed under the License is distributed on an 15 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16 * KIND, either express or implied. See the License for the 17 * specific language governing permissions and limitations 18 * under the License. 19 * 20 *************************************************************/ 21 22 23 24#ifndef __com_sun_star_sheet_SheetCellRanges_idl__ 25#define __com_sun_star_sheet_SheetCellRanges_idl__ 26 27 28#ifndef __com_sun_star_table_CellProperties_idl__ 29#include <com/sun/star/table/CellProperties.idl> 30#endif 31 32#ifndef __com_sun_star_style_CharacterProperties_idl__ 33#include <com/sun/star/style/CharacterProperties.idl> 34#endif 35 36#ifndef __com_sun_star_style_CharacterPropertiesAsian_idl__ 37#include <com/sun/star/style/CharacterPropertiesAsian.idl> 38#endif 39 40#ifndef __com_sun_star_style_CharacterPropertiesComplex_idl__ 41#include <com/sun/star/style/CharacterPropertiesComplex.idl> 42#endif 43 44#ifndef __com_sun_star_style_ParagraphProperties_idl__ 45#include <com/sun/star/style/ParagraphProperties.idl> 46#endif 47 48#ifndef __com_sun_star_sheet_SheetRangesQuery_idl__ 49#include <com/sun/star/sheet/SheetRangesQuery.idl> 50#endif 51 52 53#ifndef __com_sun_star_util_XReplaceable_idl__ 54#include <com/sun/star/util/XReplaceable.idl> 55#endif 56 57#ifndef __com_sun_star_util_XIndent_idl__ 58#include <com/sun/star/util/XIndent.idl> 59#endif 60 61#ifndef __com_sun_star_sheet_XSheetOperation_idl__ 62#include <com/sun/star/sheet/XSheetOperation.idl> 63#endif 64 65#ifndef __com_sun_star_chart_XChartDataArray_idl__ 66#include <com/sun/star/chart/XChartDataArray.idl> 67#endif 68 69#ifndef __com_sun_star_sheet_XSheetCellRangeContainer_idl__ 70#include <com/sun/star/sheet/XSheetCellRangeContainer.idl> 71#endif 72 73#ifndef __com_sun_star_container_XEnumerationAccess_idl__ 74#include <com/sun/star/container/XEnumerationAccess.idl> 75#endif 76 77#ifndef __com_sun_star_container_XNameContainer_idl__ 78#include <com/sun/star/container/XNameContainer.idl> 79#endif 80 81 82#ifndef __com_sun_star_sheet_XSheetConditionalEntries_idl__ 83#include <com/sun/star/sheet/XSheetConditionalEntries.idl> 84#endif 85 86#ifndef __com_sun_star_beans_XPropertySet_idl__ 87#include <com/sun/star/beans/XPropertySet.idl> 88#endif 89 90//============================================================================= 91 92module com { module sun { module star { module sheet { 93 94//============================================================================= 95 96/** represents a collection of cell ranges in a spreadsheet document. 97 98 @see com::sun::star::sheet::SheetCellRange 99 */ 100published service SheetCellRanges 101{ 102 //------------------------------------------------------------------------- 103 104 /** contributes common cell formatting properties. 105 */ 106 service com::sun::star::table::CellProperties; 107 108 //------------------------------------------------------------------------- 109 110 /** contributes properties for character formatting of Western text. 111 */ 112 service com::sun::star::style::CharacterProperties; 113 114 //------------------------------------------------------------------------- 115 116 /** contributes properties for character formatting of Asian text. 117 */ 118 service com::sun::star::style::CharacterPropertiesAsian; 119 120 //------------------------------------------------------------------------- 121 122 /** contributes properties for character formatting of Complex text. 123 */ 124 service com::sun::star::style::CharacterPropertiesComplex; 125 126 //------------------------------------------------------------------------- 127 128 /** contributes properties for paragraph formatting. 129 */ 130 service com::sun::star::style::ParagraphProperties; 131 132 //------------------------------------------------------------------------- 133 134 /** provides interfaces to find cells with specific properties. 135 */ 136 service com::sun::star::sheet::SheetRangesQuery; 137 138 //========================================================================= 139 140 /** provides "Find & Replace" functionality. 141 142 <p>The property 143 <member scope="com::sun::star::util">SearchDescriptor::SearchWords</member> 144 has a different meaning in spreadsheets: If set to <TRUE/>, the 145 spreadsheet searches for cells containing the serch text only.</p> 146 */ 147 interface com::sun::star::util::XReplaceable; 148 149 //------------------------------------------------------------------------- 150 151 /** provides modifying the cell indentation. 152 */ 153 interface com::sun::star::util::XIndent; 154 155 //------------------------------------------------------------------------- 156 157 /** provides computation of a value based on the contents of all 158 cells of this range and to clear specific cells. 159 */ 160 interface com::sun::star::sheet::XSheetOperation; 161 162 //------------------------------------------------------------------------- 163 164 /** provides modifying the source data cells of a chart and makes 165 it possible to learn about changes in the cell values. 166 */ 167 interface com::sun::star::chart::XChartDataArray; 168 169 //------------------------------------------------------------------------- 170 171 /** provides methods to access cell ranges via index and to add and 172 remove cell ranges. 173 */ 174 interface com::sun::star::sheet::XSheetCellRangeContainer; 175 176 //------------------------------------------------------------------------- 177 178 /** creates an enumeration of all cell ranges. 179 180 @see com::sun::star::sheet::SheetCellRangesEnumeration 181 */ 182 interface com::sun::star::container::XEnumerationAccess; 183 184 //------------------------------------------------------------------------- 185 186 /** provides access of the cell ranges via an user-defined name. 187 188 <p>Later the range can be found, replaced or removed using that 189 name.</p> 190 */ 191 interface com::sun::star::container::XNameContainer; 192 193 //========================================================================= 194 195 /** contains the conditional formatting settings for this cell. 196 197 <p>After a conditional format has been changed it has to be 198 reinserted into the property set.</p> 199 200 @see com::sun::star::sheet::TableConditionalFormat 201 */ 202 [property] com::sun::star::sheet::XSheetConditionalEntries 203 ConditionalFormat; 204 205 //------------------------------------------------------------------------- 206 207 /** contains the conditional formatting settings for this cell, 208 using localized formulas. 209 210 <p>After a conditional format has been changed it has to be 211 reinserted into the property set.</p> 212 213 @see com::sun::star::sheet::TableConditionalFormat 214 */ 215 [optional, property] com::sun::star::sheet::XSheetConditionalEntries 216 ConditionalFormatLocal; 217 218 //------------------------------------------------------------------------- 219 220 /** contains the data validation settings for this cell. 221 222 <p>After the data validation settings have been changed the 223 validation has to be reinserted into the property set.</p> 224 225 @see com::sun::star::sheet::TableValidation 226 */ 227 [property] com::sun::star::beans::XPropertySet Validation; 228 229 //------------------------------------------------------------------------- 230 231 /** contains the data validation settings for this cell, 232 using localized formulas. 233 234 <p>After the data validation settings have been changed the 235 validation has to be reinserted into the property set.</p> 236 237 @see com::sun::star::sheet::TableValidation 238 */ 239 [optional, property] com::sun::star::beans::XPropertySet ValidationLocal; 240 241 //------------------------------------------------------------------------- 242 243 /** Returns the absolute address of the ranges as string, e.g. "$Sheet1.$B$2:$D$5". 244 */ 245 [optional, readonly, property] string AbsoluteName; 246}; 247 248//============================================================================= 249 250}; }; }; }; 251 252#endif 253 254