Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

API

SDK

Tips ‘n’ Tricks

Miscellaneous


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

interface XUsedAreaCursor
Description
provides methods to find the used area of the entire sheet.

The used area is the smallest cell range that contains all cells of the spreadsheet with any contents (values, text, formulas) or visible formatting (borders and background color).

See also
SheetCellCursor
Developers Guide
Spreadsheets - Cell Cursor - Used Area

Methods' Summary
gotoStartOfUsedArea points the cursor to the start of the used area.  
gotoEndOfUsedArea points the cursor to the end of the used area.  
Methods' Details
gotoStartOfUsedArea
void
gotoStartOfUsedArea( [in] boolean  bExpand );

Description
points the cursor to the start of the used area.
Parameter bExpand
true = expands the current cursor range, false = sets size of the cursor to a single cell.
gotoEndOfUsedArea
void
gotoEndOfUsedArea( [in] boolean  bExpand );

Description
points the cursor to the end of the used area.
Parameter bExpand
true = expands the current cursor range, false = sets size of the cursor to a single cell.
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.