:: com :: sun :: star :: sheet ::

interface XSheetCellRanges
Base Interfaces
XSheetCellRanges
┗ ::com::sun::star::container::XIndexAccess
   ┗ ::com::sun::star::container::XElementAccess

::com::sun::star::container::XIndexAccess
(referenced interface's summary:)
provides access to the elements of a collection through an index.
Description
provides methods to access cell ranges in a collection via index and other helper methods.
See also
SheetCellRanges

Methods' Summary
getCells returns the collection of all used cells.  
getRangeAddressesAsString creates a string with addresses of all contained cell ranges.  
getRangeAddresses creates a sequence with addresses of all contained cell ranges.  
Methods' Details
getCells
::com::sun::star::container::XEnumerationAccess
getCells();

Description
returns the collection of all used cells.
See also
Cells
getRangeAddressesAsString
string
getRangeAddressesAsString();

Description
creates a string with addresses of all contained cell ranges.

The range addresses are separated with semicolons. For instance the string could have the form "Sheet1.A1:C3;Sheet2.D5:F8".

Returns
a string containing the addresses of all cell ranges.
getRangeAddresses
sequence< ::com::sun::star::table::CellRangeAddress >
getRangeAddresses();

Description
creates a sequence with addresses of all contained cell ranges.
Returns
a sequence with the addresses of all cell ranges.
Top of Page