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
|
Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.