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