Overview | Module | Use | Devguide | Index

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

:: com :: sun :: star :: sheet ::
service SheetCellRange
Description represents a rectangular range of cells in a spreadsheet document. This service is an extension of the CellRange service for use in spreadsheet documents. 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 - Cell and Cell Range Access 8.3.1 Spreadsheet Documents - Working with Spreadsheet Documents - Document Structure - Cell Ranges

Included Services
::com::sun::star::table::CellRange | Description provides basic handling of cell ranges and 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::XMergeable | Description provides merging and unmerging the cells of this cell range.
::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::table::XAutoFormattable | Description provides applying an AutoFormat to the cell range.
XSheetCellRange | Description provides access to the spreadsheet that contains this cell range.
XCellRangeData | Description provides simultaneous access to the contents of all cells.
XCellRangeFormula | [ OPTIONAL ] Description provides simultaneous access to the formula contents of all cells. Since version OpenOffice.org 1.1.1
XCellRangeAddressable | Description provides access to the cell range address of this range.
XSheetOperation | Description provides computation of a value based on the contents of all cells of this range and to clear specific cells.
XCellSeries | Description provides filling out the cell range automatically with values based on a start value, step count and fill mode.
XArrayFormulaRange | Description provides handling of array formulas.
XMultipleOperation | Description provides access to the Multiple Operations feature.
::com::sun::star::util::XSortable | Description provides sorting functionality.
::com::sun::star::util::XImportable | Description provides functionality to import data from external data sources.
XSubTotalCalculatable | Description provides calculating SubTotal values in this range.
XSheetFilterableEx | Description provides filtering the contents of this range.
XCellFormatRangesSupplier | Description provide access to a collection of equal-formatted cell ranges.
XUniqueCellFormatRangesSupplier | Description provide access to a collection of equal-formatted cell ranges.
::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.

Properties' Summary
Position | contains the position of the top left cell of this range in the sheet (in 1/100 mm).
Size | contains the size of this range (in 1/100 mm).
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 the top left cell of this range 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 range (in 1/100 mm).
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.