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 address 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 © 2000, 2014 LibreOffice contributors and/or their affiliates. All rights reserved.
LibreOffice was created by The Document Foundation, based on OpenOffice.org, which is Copyright 2000, 2010 Oracle and/or its affiliates.
The Document Foundation acknowledges all community members, please find more info at our website.
Privacy Policy | Impressum (Legal Info) | Copyright information: The source code of LibreOffice is licensed under the GNU Lesser General Public License (LGPLv3). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.