Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

API

SDK

Tips ‘n’ Tricks

Miscellaneous

Overview Module Use Devguide Index
Methods' Summary Attributes' Summary Methods' Details Attributes' Details

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

Copyright © 2013, The Apache Software Foundation, Licensed under the Apache License, Version 2.0. Apache, the Apache feather logo, Apache OpenOffice and OpenOffice.org are trademarks of The Apache Software Foundation. Other names may be trademarks of their respective owners.

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.