Am 17.06.2011 17:38, tora - Takamichi Akiyama wrote:
On 2011/06/17 16:38, Martin Hediger wrote:
Its true, i havent thought of the implications of what it means to
switch rows. Should references pointing to cell A1 remain pointing to
A1, when the content of A1 is "traded" for the content of B1? What
should the references follow?
But apart from that, the way to exchange two rows is I believe indeed
achieved most easily by a combination of the insert_row(), move_row(),
delete_row() methods.
If you want to swap the contents of two rows or columns but you do not
want to change their references, it might be a set of
1. insert_row as a temporal space,
2. COPY_row 1 to the temporal space,
3. COPY_row from 2 to 1,
4. COPY_row from the temporal row to 2,
5. and delete_row the temporal space.
Select the cell range, row or column.
Drag the cell selection (not the column/row header).
Hold the Alt key before you drop.
--
-----------------------------------------------------------------
To unsubscribe send email to dev-unsubscr...@openoffice.org
For additional commands send email to sy...@openoffice.org
with Subject: help
