Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

API

SDK

Tips ‘n’ Tricks

Miscellaneous


:: 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

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.