English:

The Free and Open Productivity Suite
Help us Help the World

Developer's Guide

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

Logo ApacheCon Europe 2014

Apache Feather

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.