Overview | Module | Use | Devguide | Index

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

:: com :: sun :: star :: sheet ::
service SheetCellRanges
Description represents a collection of cell ranges in a spreadsheet document. See also SheetCellRange 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 - Cell Ranges and Cells Container

Included Services
::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
::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' Summary
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
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.