At 11:02 14/06/2009 +0200, Dotan Cohen wrote:
Hi all, I have a user who just moved to Kubuntu from MS Windows XP
and is enjoying Open Office 3.1 installed from the Ubuntu OOo PPA.
One feature that she is missing is the ability to highlight an
entire row, and then move the highlight up / down a row. Apparently
MSO could do this, though I cannot figure out how to do it there, either.
To be clear, the user selects (for instance) row 8, then with the
keyboard (either arrow keys, or maybe page up/down) moves the
selection from row 8 to row 9. This effectively highlights a row,
which helps her in her workflow (calling people, the spreadsheet is
a list of contact information).
If I understand you correctly, I think this is a known difference
between Excel and Calc. In Excel, if you move the cursor to the edge
of a selection of rows, it changes and you can then use it to drag
the selected rows elsewhere in the sheet. You can choose to move or
copy, and the move option deletes the original rows, of course. In
addition, when you cut or copy a row or rows, they are only marked
until you choose what to do with the contents. Instead of pasting
them, there is an option to Insert | Cut Cells (or Insert | Copied
Cells); again, the Cut option deletes the original rows, not just
their contents. (I don't have Excel here to confirm all this, though.)
Thanks in advance for any ideas on how to do this in OOo 3.1.
The workaround is fairly messy:
o Select the relevant rows.
o Cut or Copy the selection.
o Use Delete Rows to delete the selection.
o Select the rows where you want the material to appear.
o Use Insert Rows to create new blank rows (and move other rows down).
o Use Paste or Paste Special to paste the material into the new rows.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
