Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

API

SDK

Tips ‘n’ Tricks

Miscellaneous


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

service SheetCellRanges
Description
represents a collection of cell ranges in a spreadsheet document.
See also
SheetCellRange
Developers Guide
Spreadsheets - Spreadsheet Services - Overview
Spreadsheets - Cell Ranges and Cells Container

Included Services - Summary
::com::sun::star::table::CellProperties

contributes common cell formatting properties.

::com::sun::star::style::CharacterProperties

contributes properties for character formatting of Western text.

::com::sun::star::style::CharacterPropertiesAsian

contributes properties for character formatting of Asian text.

::com::sun::star::style::CharacterPropertiesComplex

contributes properties for character formatting of Complex text.

::com::sun::star::style::ParagraphProperties

contributes properties for paragraph formatting.

SheetRangesQuery

provides interfaces to find cells with specific properties.

Exported Interfaces - Summary
::com::sun::star::util::XReplaceable

provides "Find & Replace" functionality. (details)

::com::sun::star::util::XIndent

provides modifying the cell indentation.

XSheetOperation

provides computation of a value based on the contents of all cells of this range and to clear specific cells.

::com::sun::star::chart::XChartDataArray

provides modifying the source data cells of a chart and makes it possible to learn about changes in the cell values.

XSheetCellRangeContainer

provides methods to access cell ranges via index and to add and remove cell ranges.

::com::sun::star::container::XEnumerationAccess

creates an enumeration of all cell ranges. (details)

::com::sun::star::container::XNameContainer

provides access of the cell ranges via an user-defined name. (details)

Properties' Summary
XSheetConditionalEntries
ConditionalFormat
contains the conditional formatting settings for this cell.  
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.  
[ readonly ] string
AbsoluteName
[ OPTIONAL ]
Returns the absolute adress of the ranges as string, e.g. "$Sheet1.$B$2:$D$5".  
Included Services - Details
::com::sun::star::table::CellProperties
Description
contributes common cell formatting properties.
::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 - Details
::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.
XSheetOperation
Description
provides computation of a value based on the contents of all cells of this range and to clear specific cells.
::com::sun::star::chart::XChartDataArray
Description
provides modifying the source data cells of a chart and makes it possible to learn about changes in the cell values.
XSheetCellRangeContainer
Description
provides methods to access cell ranges via index and to add and remove cell ranges.
::com::sun::star::container::XEnumerationAccess
Description
creates an enumeration of all cell ranges.
See also
SheetCellRangesEnumeration
::com::sun::star::container::XNameContainer
Description
provides access of the cell ranges via an user-defined name.

Later the range can be found, replaced or removed using that name.

Properties' Details
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;
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
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;
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
TableValidation
AbsoluteName
[ readonly ] string AbsoluteName;
Usage Restrictions
optional
Description
Returns the absolute adress of the ranges as string, e.g. "$Sheet1.$B$2:$D$5".

 
Top of Page

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.