:: com :: sun :: star :: sheet ::

service SheetCell
Description
represents a single addressable cell in a spreadsheet document.
Developers Guide

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.
::com::sun::star::sheet::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.
::com::sun::star::sheet::XCellAddressable
Description
provides access to the cell address of this cell.
::com::sun::star::sheet::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.
::com::sun::star::beans::XTolerantMultiPropertySet
Usage Restrictions
optional
::com::sun::star::util::XModifyBroadcaster
Usage Restrictions
optional
Description
Since
OpenOffice 2.0.0
Properties' Summary
[ readonly ] ::com::sun::star::awt::Point
Position
contains the position of this cell in the sheet (in 1/100 mm).  
[ readonly ] ::com::sun::star::awt::Size
Size
contains the size of this cell (in 1/100 mm).  
string
FormulaLocal
[ OPTIONAL ]
contains the formula string with localized function names.  
[ readonly ] long
FormulaResultType
contains the result type of a formula.  
::com::sun::star::sheet::XSheetConditionalEntries
ConditionalFormat
contains the conditional formatting settings for this cell.  
::com::sun::star::sheet::XSheetConditionalEntries
ConditionalFormatLocal
[ OPTIONAL ]
contains the conditional formatting settings for this cell, using localized formulas.  
::com::sun::star::beans::XPropertySet
Validation
contains the data validation settings for this cell.  
::com::sun::star::beans::XPropertySet
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;
Usage Restrictions
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
::com::sun::star::sheet::FormulaResult
ConditionalFormat
::com::sun::star::sheet::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
::com::sun::star::sheet::TableConditionalFormat
ConditionalFormatLocal
::com::sun::star::sheet::XSheetConditionalEntries ConditionalFormatLocal;
Usage Restrictions
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
::com::sun::star::sheet::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
::com::sun::star::sheet::TableValidation
ValidationLocal
::com::sun::star::beans::XPropertySet ValidationLocal;
Usage Restrictions
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
::com::sun::star::sheet::TableValidation

 
Top of Page