LibreOffice
LibreOffice 4.2 SDK API Reference
|
provides access to the cells or to sub-ranges of all sheets. More...
import"XCellRangesAccess.idl";
Public Member Functions | |
com::sun::star::table::XCell | getCellByPosition ([in] long nColumn, [in] long nRow, [in] long nSheet) raises ( com::sun::star::lang::IndexOutOfBoundsException ) |
Returns a single cell within the range. More... | |
com::sun::star::table::XCellRange | getCellRangeByPosition ([in] long nLeft, [in] long nTop, [in] long nRight, [in] long nBottom, [in] long nSheet) raises ( com::sun::star::lang::IndexOutOfBoundsException ) |
Returns a sub-range of cells within the range. More... | |
sequence < com::sun::star::table::XCellRange > | getCellRangesByName ([in] string aRange) raises ( com::sun::star::lang::IllegalArgumentException ) |
Returns a sub-range of cells within the range. More... | |
![]() | |
any | queryInterface ([in] type aType) |
queries for a new interface to an existing UNO object. More... | |
void | acquire () |
increases the reference counter by one. More... | |
void | release () |
decreases the reference counter by one. More... | |
provides access to the cells or to sub-ranges of all sheets.
com::sun::star::table::XCell getCellByPosition | ( | [in] long | nColumn, |
[in] long | nRow, | ||
[in] long | nSheet | ||
) | |||
raises | ( | com::sun::star::lang::IndexOutOfBoundsException | |
) |
Returns a single cell within the range.
nColumn | is the column index of the cell inside the sheet. |
nRow | is the row index of the cell inside the sheet. |
nSheet | is the sheet index of the sheet inside the document. |
com::sun::star::lang::IndexOutOfBoundsException | if an index is outside the dimensions of this range. |
com::sun::star::table::XCellRange getCellRangeByPosition | ( | [in] long | nLeft, |
[in] long | nTop, | ||
[in] long | nRight, | ||
[in] long | nBottom, | ||
[in] long | nSheet | ||
) | |||
raises | ( | com::sun::star::lang::IndexOutOfBoundsException | |
) |
Returns a sub-range of cells within the range.
nLeft | is the column index of the first cell inside the range. |
nTop | is the row index of the first cell inside the range. |
nRight | is the column index of the last cell inside the range. |
nBottom | is the row index of the last cell inside the range. |
nSheet | is the sheet index of the sheet inside the document. |
com::sun::star::lang::IndexOutOfBoundsException | if an index is outside the dimensions of this range. |
sequence<com::sun::star::table::XCellRange> getCellRangesByName | ( | [in] string | aRange | ) | |
raises | ( | com::sun::star::lang::IllegalArgumentException | |||
) |
Returns a sub-range of cells within the range.
The sub-range is specified by its name. The format of the range name is dependent of the context of the table. In spreadsheets valid names may be "Sheet1.A1:C5" or "$Sheet1.$B$2" or even defined names for cell ranges such as "MySpecialCell".
aRange | the name of the sub-range. |