Re: Implementation of Row Exchange Button in Calc

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 [email protected]
For additional commands send email to [email protected]
with Subject: help