Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

API

SDK

Tips ‘n’ Tricks

Miscellaneous


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

interface XCellRangeMovement
Description
provides methods for moving ranges of cells in a sheet.

Methods' Summary
insertCells inserts cells, moving other cells down or right.  
removeRange deletes cells, moving other cells up or left.  
moveRange moves a cell range to another position in the document.  
copyRange copies a cell range to another position in the document.  
Methods' Details
insertCells
void
insertCells( [in] ::com::sun::star::table::CellRangeAddress  aRange,
[in] CellInsertMode  nMode );

Description
inserts cells, moving other cells down or right.

Non-empty cells cannot be moved off the sheet.

Parameter aRange
the cell range in which empty cells will be inserted.
Parameter nMode
describes how to move existing cells.
removeRange
void
removeRange( [in] ::com::sun::star::table::CellRangeAddress  aRange,
[in] CellDeleteMode  nMode );

Description
deletes cells, moving other cells up or left.
Parameter aRange
the cell range to remove.
Parameter nMode
describes how to move following cells.
moveRange
void
moveRange( [in] ::com::sun::star::table::CellAddress  aDestination,
[in] ::com::sun::star::table::CellRangeAddress  aSource );

Description
moves a cell range to another position in the document.

After copying the contents of the cell range, all cells will be cleared.

Parameter aDestination
the address of the top left cell of the destination range.
Parameter aSource
the cell range which will be copied.
copyRange
void
copyRange( [in] ::com::sun::star::table::CellAddress  aDestination,
[in] ::com::sun::star::table::CellRangeAddress  aSource );

Description
copies a cell range to another position in the document.

The source cell range keeps unchanged.

Parameter aDestination
the address of the top left cell of the destination range.
Parameter aSource
the cell range which will be copied.
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.