offapi/com/sun/star/sheet/SheetCell.idl

   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  */
  19
  20 #ifndef __com_sun_star_sheet_SheetCell_idl__
  21 #define __com_sun_star_sheet_SheetCell_idl__
  22
  23
  24 #include <com/sun/star/table/Cell.idl>
  25 #include <com/sun/star/text/Text.idl>
  26 #include <com/sun/star/style/CharacterProperties.idl>
  27 #include <com/sun/star/style/CharacterPropertiesAsian.idl>
  28 #include <com/sun/star/style/CharacterPropertiesComplex.idl>
  29 #include <com/sun/star/style/ParagraphProperties.idl>
  30 #include <com/sun/star/style/ParagraphPropertiesAsian.idl>
  31 #include <com/sun/star/style/ParagraphPropertiesComplex.idl>
  32 #include <com/sun/star/sheet/SheetRangesQuery.idl>
  33
  34
  35 #include <com/sun/star/document/XActionLockable.idl>
  36 #include <com/sun/star/util/XReplaceable.idl>
  37 #include <com/sun/star/util/XIndent.idl>
  38 #include <com/sun/star/table/XColumnRowRange.idl>
  39 #include <com/sun/star/sheet/XCellAddressable.idl>
  40 #include <com/sun/star/sheet/XSheetAnnotationAnchor.idl>
  41 #include <com/sun/star/text/XTextFieldsSupplier.idl>
  42
  43
  44 #include <com/sun/star/awt/Point.idl>
  45 #include <com/sun/star/awt/Size.idl>
  46 #include <com/sun/star/sheet/XSheetConditionalEntries.idl>
  47 #include <com/sun/star/beans/XPropertySet.idl>
  48 #include <com/sun/star/beans/XTolerantMultiPropertySet.idl>
  49 #include <com/sun/star/util/XModifyBroadcaster.idl>
  50
  51
  52 module com {  module sun {  module star {  module sheet {
  53
  54
  55 /** represents a single addressable cell in a spreadsheet document.
  56  */
  57 published service SheetCell
  58 {
  59
  60     /** provides basic cell handling and contributes common cell
  61         formatting properties.
  62      */
  63     service com::sun::star::table::Cell;
  64
  65
  66     /** provides handling of formatted text cells.
  67      */
  68     service com::sun::star::text::Text;
  69
  70
  71     /** contributes properties for character formatting of Western text.
  72      */
  73     service com::sun::star::style::CharacterProperties;
  74
  75
  76     /** contributes properties for character formatting of Asian text.
  77      */
  78     service com::sun::star::style::CharacterPropertiesAsian;
  79
  80
  81     /** contributes properties for character formatting of Complex text.
  82      */
  83     service com::sun::star::style::CharacterPropertiesComplex;
  84
  85
  86     /** contributes properties for paragraph formatting.
  87      */
  88     service com::sun::star::style::ParagraphProperties;
  89
  90
  91     /** contributes properties for paragraph formatting of Asian text.
  92      */
  93     [optional] service com::sun::star::style::ParagraphPropertiesAsian;
  94
  95
  96     /** contributes properties for paragraph formatting of Complex text.
  97      */
  98     [optional] service com::sun::star::style::ParagraphPropertiesComplex;
  99
 100
 101     /** provides interfaces to find cells with specific properties.
 102      */
 103     service com::sun::star::sheet::SheetRangesQuery;
 104
 105
 106     /** provides methods to lock and unlock the update between
 107         <type scope="com::sun::star::table">XCell</type> and
 108         <type scope="com::sun::star::text">XText</type>.
 109     */
 110     interface com::sun::star::document::XActionLockable;
 111
 112
 113     /** provides "Find & Replace" functionality.
 114
 115         <p>The property
 116         <member scope="com::sun::star::util">SearchDescriptor::SearchWords</member>
 117         has a different meaning in spreadsheets: If set to <TRUE/>, the
 118         spreadsheet searches for cells containing the search text only.</p>
 119      */
 120     interface com::sun::star::util::XReplaceable;
 121
 122
 123     /** provides modifying the cell indentation.
 124      */
 125     interface com::sun::star::util::XIndent;
 126
 127
 128     /** provides access to the collections of columns and rows.
 129      */
 130     interface com::sun::star::table::XColumnRowRange;
 131
 132
 133     /** provides access to the cell address of this cell.
 134      */
 135     interface com::sun::star::sheet::XCellAddressable;
 136
 137
 138     /** provides access to the annotation attached to this cell.
 139      */
 140     interface com::sun::star::sheet::XSheetAnnotationAnchor;
 141
 142
 143     /** provides access to the text fields used in this cell.
 144      */
 145     interface com::sun::star::text::XTextFieldsSupplier;
 146
 147
 148     [optional] interface com::sun::star::beans::XTolerantMultiPropertySet;
 149
 150
 151     /**
 152
 153     @since OOo 2.0
 154
 155     */
 156     [optional] interface com::sun::star::util::XModifyBroadcaster;
 157
 158
 159     /** contains the position of this cell in the sheet (in 1/100 mm).
 160
 161         <p>This property contains the absolute position in the whole
 162         sheet, not the position in the visible area.</p>
 163      */
 164     [readonly, property] com::sun::star::awt::Point Position;
 165
 166
 167     /** contains the size of this cell (in 1/100 mm).
 168      */
 169     [readonly, property] com::sun::star::awt::Size Size;
 170
 171
 172     /** contains the formula string with localized function names.
 173
 174         <p>This property can also be used to set a new localized formula.</p>
 175      */
 176     [optional, property] string FormulaLocal;
 177
 178
 179     /** contains the result type of a formula.
 180
 181         @see com::sun::star::sheet::FormulaResult
 182      */
 183     [readonly, property] long FormulaResultType;
 184
 185
 186     /** contains the conditional formatting settings for this cell.
 187
 188         <p>After a conditional format has been changed it has to be
 189         reinserted into the property set.</p>
 190
 191         @see com::sun::star::sheet::TableConditionalFormat
 192      */
 193     [property] com::sun::star::sheet::XSheetConditionalEntries
 194         ConditionalFormat;
 195
 196
 197     /** contains the conditional formatting settings for this cell,
 198         using localized formulas.
 199
 200         <p>After a conditional format has been changed it has to be
 201         reinserted into the property set.</p>
 202
 203         @see com::sun::star::sheet::TableConditionalFormat
 204      */
 205     [optional, property] com::sun::star::sheet::XSheetConditionalEntries
 206         ConditionalFormatLocal;
 207
 208
 209     /** contains the data validation settings for this cell.
 210
 211         <p>After the data validation settings have been changed the
 212         validation has to be reinserted into the property set.</p>
 213
 214         @see com::sun::star::sheet::TableValidation
 215      */
 216     [property] com::sun::star::beans::XPropertySet Validation;
 217
 218
 219     /** contains the data validation settings for this cell,
 220         using localized formulas.
 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     [optional, property] com::sun::star::beans::XPropertySet ValidationLocal;
 228
 229
 230     /** Returns the absolute address of the range as string, e.g. "$Sheet1.$B$2".
 231      */
 232     [optional, readonly, property] string AbsoluteName;
 233 };
 234
 235
 236 }; }; }; };
 237
 238 #endif
 239
 240 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */