:: 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 © 1995, 2012, 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.