:: com :: sun :: star :: sheet ::
|
interface XCellRangesAccess |
|
- Description
- provides access to the cells or to sub-ranges of all sheets.
- See also
- Spreadsheets
|
Methods' Details |
getCellByPosition
- Description
- Returns a single cell within the range.
- Parameter nColumn
- is the column index of the cell inside the sheet.
- Parameter nRow
- is the row index of the cell inside the sheet.
- Parameter nSheet
- is the sheet index of the sheet inside the document.
- Returns
- the specified cell.
- Throws
- ::com::sun::star::lang::IndexOutOfBoundsException
if an index is outside the dimensions of this range.
- See also
- ::com::sun::star::table::Cell
|
|
getCellRangeByPosition
- Description
- Returns a sub-range of cells within the range.
- Parameter nLeft
- is the column index of the first cell inside the range.
- Parameter nTop
- is the row index of the first cell inside the range.
- Parameter nRight
- is the column index of the last cell inside the range.
- Parameter nBottom
- is the row index of the last cell inside the range.
- Parameter nSheet
- is the sheet index of the sheet inside the document.
- Returns
- the specified cell range.
- Throws
- ::com::sun::star::lang::IndexOutOfBoundsException
if an index is outside the dimensions of this range.
- See also
- ::com::sun::star::table::CellRange
|
|
getCellRangesByName
- Description
- 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".
- Parameter aRange
- the name of the sub-range.
- Returns
- the specified cell ranges.
- See also
- ::com::sun::star::table::CellRange
|
|
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.