> 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. >
Thanks, Brian, but I think that you went to far. The user has a list of contacts: Mary Jow 435-3739 Bob Hendrix 431-9860 Trent Reznor 438-7254 She needs to call them all in turn. So she highlights (selects, but for purposes of her workflow she is highlighting) the Mary line, dials the number, finishes the conversation, then wants the Bob row highlighted. In Excel she can hit the down arrow. Not so in Calc. Should I file a feature request? -- Dotan Cohen http://what-is-what.com http://gibberish.co.il --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
