LibreOffice
LibreOffice 6.2 SDK API Reference
Public Member Functions | List of all members
XCellRange Interface Referencepublished

provides access to the cells or to sub-ranges of a cell range. More...

import"XCellRange.idl";

Inheritance diagram for XCellRange:
XInterface XSheetCellRange CellRange TableColumn TableRow XCellCursor XTable CellRange TextTable

Public Member Functions

com::sun::star::table::XCell getCellByPosition ([in] long nColumn, [in] long nRow) 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) raises ( com::sun::star::lang::IndexOutOfBoundsException )
 Returns a sub-range of cells within the range. More...
 
com::sun::star::table::XCellRange getCellRangeByName ([in] string aRange)
 Returns a sub-range of cells within the range. More...
 
- Public Member Functions inherited from XInterface
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...
 

Detailed Description

provides access to the cells or to sub-ranges of a cell range.

See also
com::sun::star::table::CellRange
Developers Guide
Spreadsheets - Cell and Cell Range Access

Member Function Documentation

com::sun::star::table::XCell getCellByPosition ( [in] long  nColumn,
[in] long  nRow 
)
raises (com::sun::star::lang::IndexOutOfBoundsException
)

Returns a single cell within the range.

Parameters
nColumnis the column index of the cell inside the range.
nRowis the row index of the cell inside the range.
Returns
the specified cell.
Exceptions
com::sun::star::lang::IndexOutOfBoundsExceptionif an index is outside the dimensions of this range.
See also
com::sun::star::table::Cell
com::sun::star::table::XCellRange getCellRangeByName ( [in] string  aRange)

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".

Parameters
aRangethe name of the sub-range.
Returns
the specified cell range.
See also
com::sun::star::table::CellRange
com::sun::star::table::XCellRange getCellRangeByPosition ( [in] long  nLeft,
[in] long  nTop,
[in] long  nRight,
[in] long  nBottom 
)
raises (com::sun::star::lang::IndexOutOfBoundsException
)

Returns a sub-range of cells within the range.

Parameters
nLeftis the column index of the first cell inside the range.
nTopis the row index of the first cell inside the range.
nRightis the column index of the last cell inside the range.
nBottomis the row index of the last cell inside the range.
Returns
the specified cell range.
Exceptions
com::sun::star::lang::IndexOutOfBoundsExceptionif an index is outside the dimensions of this range.
See also
com::sun::star::table::CellRange

The documentation for this interface was generated from the following file: