Overview | Module | Use | Devguide | Index

Methods' Summary | Methods' Details | Attributes' Summary | Attributes' Details

:: com :: sun :: star :: table ::
interface XCellRange
  Base Hierarchy
      ::com::sun::star::uno::XInterface
       |
       +-XCellRange
Description provides access to the cells or to sub-ranges of a cell range. See also CellRange Developers Guide 8.3.1 Spreadsheet Documents - Working with Spreadsheet Documents - Document Structure - Cell Ranges - Cell and Cell Range Access

Methods' Summary
getCellByPosition | Returns a single cell within the range.
getCellRangeByPosition | Returns a sub-range of cells within the range.
getCellRangeByName | Returns a sub-range of cells within the range.

Methods' Details
getCellByPosition
XCell getCellByPosition( | [in] long [in] long raises( | nColumn, nRow ) ::com::sun::star::lang::IndexOutOfBoundsException );
Description Returns a single cell within the range. Parameter nColumn is the column index of the cell inside the range. Parameter nRow is the row index of the cell inside the range. Returns the specified cell. Throws ::com::sun::star::lang::IndexOutOfBoundsException if an index is outside the dimensions of this range. See also Cell
getCellRangeByPosition
XCellRange getCellRangeByPosition( | [in] long [in] long [in] long [in] long raises( | nLeft, nTop, nRight, nBottom ) ::com::sun::star::lang::IndexOutOfBoundsException );
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. Returns the specified cell range. Throws ::com::sun::star::lang::IndexOutOfBoundsException if an index is outside the dimensions of this range. See also CellRange
getCellRangeByName
XCellRange getCellRangeByName( | [in] string | aRange );
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 "A1:C5" or "$B$2" or even defined names for cell ranges such as "MySpecialCell". Parameter aRange the name of the sub-range. Returns the specified cell range. See also CellRange

Top of Page

Copyright © 2003 Sun Microsystems, Inc.