Overview | Module | Use | Devguide | Index

Included Services | Exported Interfaces | Properties' Summary | Properties' Details

:: com :: sun :: star :: sheet ::
service SheetCell
Description represents a single addressable cell in a spreadsheet document. Developers Guide 8.3.1 Spreadsheet Documents - Working with Spreadsheet Documents - Document Structure - Spreadsheet Services - Overview 8.3.1 Spreadsheet Documents - Working with Spreadsheet Documents - Document Structure - Cells

Included Services
::com::sun::star::table::Cell | Description provides basic cell handling and contributes common cell formatting properties.
::com::sun::star::text::Text | Description provides handling of formatted text cells.
::com::sun::star::style::CharacterProperties | Description contributes properties for character formatting of Western text.
::com::sun::star::style::CharacterPropertiesAsian | Description contributes properties for character formatting of Asian text.
::com::sun::star::style::CharacterPropertiesComplex | Description contributes properties for character formatting of Complex text.
::com::sun::star::style::ParagraphProperties | Description contributes properties for paragraph formatting.
SheetRangesQuery | Description provides interfaces to find cells with specific properties.

Exported Interfaces
::com::sun::star::document::XActionLockable | Description provides methods to lock and unlock the update between ::com::sun::star::table::XCell and ::com::sun::star::text::XText .
::com::sun::star::util::XReplaceable | Description provides "Find & Replace" functionality. The property ::com::sun::star::util::SearchDescriptor::SearchWords has a different meaning in spreadsheets: If set to true , the spreadsheet searches for cells containing the serch text only.
::com::sun::star::util::XIndent | Description provides modifying the cell indentation.
::com::sun::star::table::XColumnRowRange | Description provides access to the collections of columns and rows.
XCellAddressable | Description provides access to the cell address of this cell.
XSheetAnnotationAnchor | Description provides access to the annotation attached to this cell.
::com::sun::star::text::XTextFieldsSupplier | Description provides access to the text fields used in this cell.

Properties' Summary
Position | contains the position of this cell in the sheet (in 1/100 mm).
Size | contains the size of this cell (in 1/100 mm).
FormulaLocal | [ OPTIONAL ] contains the formula string with localized function names.
FormulaResultType | contains the result type of a formula.
ConditionalFormat | contains the conditional formatting settings for this cell.
ConditionalFormatLocal | [ OPTIONAL ] contains the conditional formatting settings for this cell, using localized formulas.
Validation | contains the data validation settings for this cell.
ValidationLocal | [ OPTIONAL ] contains the data validation settings for this cell, using localized formulas.

Properties' Details
Position
[ readonly ] ::com::sun::star::awt::Point Position; Description contains the position of this cell in the sheet (in 1/100 mm). This property contains the absolute position in the whole sheet, not the position in the visible area.
Size
[ readonly ] ::com::sun::star::awt::Size Size; Description contains the size of this cell (in 1/100 mm).
FormulaLocal
string FormulaLocal; [ OPTIONAL ] Description contains the formula string with localized function names. This property can also be used to set a new localized formula.
FormulaResultType
[ readonly ] long FormulaResultType; Description contains the result type of a formula. See also FormulaResult
ConditionalFormat
XSheetConditionalEntries ConditionalFormat; Description contains the conditional formatting settings for this cell. After a conditional format has been changed it has to be reinserted into the property set. See also TableConditionalFormat
ConditionalFormatLocal
XSheetConditionalEntries ConditionalFormatLocal; [ OPTIONAL ] Description contains the conditional formatting settings for this cell, using localized formulas. After a conditional format has been changed it has to be reinserted into the property set. See also TableConditionalFormat
Validation
::com::sun::star::beans::XPropertySet Validation; Description contains the data validation settings for this cell. After the data validation settings have been changed the validation has to be reinserted into the property set. See also TableValidation
ValidationLocal
::com::sun::star::beans::XPropertySet ValidationLocal; [ OPTIONAL ] Description contains the data validation settings for this cell, using localized formulas. After the data validation settings have been changed the validation has to be reinserted into the property set. See also TableValidation

Top of Page

Copyright © 2003 Sun Microsystems, Inc.