The Free and Open Productivity Suite
Follow us on Twitter: @ApacheOO

Developer's Guide

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 | Website Feedback | Contact Us | Donate | Thanks

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