Overview | Module | Use | Devguide | Index |
Services' Summary | Interfaces' Summary | Properties' Summary | Services' Details | Interfaces' Details | Properties' Details |
service SheetCellRange |
|
Included Services - Summary | |
::com::sun::star::table::CellRange | provides basic handling of cell ranges and 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::XMergeable | provides merging and unmerging the cells of this cell range. |
::com::sun::star::util::XIndent | provides modifying the cell indentation. |
::com::sun::star::table::XColumnRowRange | provides access to the collections of columns and rows. |
::com::sun::star::table::XAutoFormattable | provides applying an AutoFormat to the cell range. |
XSheetCellRange | provides access to the spreadsheet that contains this cell range. |
XCellRangeData | provides simultaneous access to the contents of all cells. |
XCellRangeFormula | provides simultaneous access to the formula contents of all cells. (details) |
XCellRangeAddressable | provides access to the cell range address of this range. |
XSheetOperation | provides computation of a value based on the contents of all cells of this range and to clear specific cells. |
XCellSeries | provides filling out the cell range automatically with values based on a start value, step count and fill mode. |
XArrayFormulaRange | provides handling of array formulas. |
XMultipleOperation | provides access to the Multiple Operations feature. |
::com::sun::star::util::XSortable | provides sorting functionality. |
::com::sun::star::util::XImportable | provides functionality to import data from external data sources. (details) |
XSubTotalCalculatable | provides calculating SubTotal values in this range. |
XSheetFilterableEx | provides filtering the contents of this range. |
XCellFormatRangesSupplier | provide access to a collection of equal-formatted cell ranges. |
XUniqueCellFormatRangesSupplier | provide access to a collection of equal-formatted cell ranges. |
::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. |
::com::sun::star::beans::XTolerantMultiPropertySet | |
::com::sun::star::util::XModifyBroadcaster |
Properties' Summary | |
[ readonly ] ::com::sun::star::awt::Point Position |
contains the position of the top left cell of this range in the sheet (in 1/100 mm). |
[ readonly ] ::com::sun::star::awt::Size Size |
contains the size of this range (in 1/100 mm). |
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 range as string, e.g. "$Sheet1.$B$2:$D$5". |
Included Services - Details | |
::com::sun::star::table::CellRange
|
|
::com::sun::star::style::CharacterProperties
|
|
::com::sun::star::style::CharacterPropertiesAsian
|
|
::com::sun::star::style::CharacterPropertiesComplex
|
|
::com::sun::star::style::ParagraphProperties
|
|
SheetRangesQuery
|
Exported Interfaces - Details | |
::com::sun::star::util::XReplaceable
|
|
::com::sun::star::util::XMergeable
|
|
::com::sun::star::util::XIndent
|
|
::com::sun::star::table::XColumnRowRange
|
|
::com::sun::star::table::XAutoFormattable
|
|
XSheetCellRange
|
|
XCellRangeData
|
|
XCellRangeFormula
|
|
XCellRangeAddressable
|
|
XSheetOperation
|
|
XCellSeries
|
|
XArrayFormulaRange
|
|
XMultipleOperation
|
|
::com::sun::star::util::XSortable
|
|
::com::sun::star::util::XImportable
|
|
XSubTotalCalculatable
|
|
XSheetFilterableEx
|
|
XCellFormatRangesSupplier
|
|
XUniqueCellFormatRangesSupplier
|
|
::com::sun::star::chart::XChartDataArray
|
|
::com::sun::star::beans::XTolerantMultiPropertySet
|
|
::com::sun::star::util::XModifyBroadcaster
|
Properties' Details | |
Position
|
|
Size
|
|
ConditionalFormat
|
|
ConditionalFormatLocal
|
|
Validation
|
|
ValidationLocal
|
|
AbsoluteName
|
Top of Page
Copyright © 2013, The Apache Software Foundation, Licensed under the Apache License, Version 2.0. Apache, the Apache feather logo, Apache OpenOffice and OpenOffice.org are trademarks of The Apache Software Foundation. Other names may be trademarks of their respective owners.