On Wed, 2 Feb 2005, Peter Kupfer wrote: >Eric Wood wrote: >> ----- Original Message ----- From: "Brian" >> >>>> Without Shift, you would end up with A_CBEF or A_CDBF unless you >>>>inserted a blank cell between D&E first. >>> It's the equivalent of OO's Paste Special with cells shifted, but >>>with OO you have to do it thru the Edit > Paste Special > Shift >>>Cells dialogue. >>> I know of no shortcut key or mouse shortcut to do it in as few >>>keystrokes as Excel. >> Unfortunately, Calc 2.0 (m72) does not have this capability either. >>Darn. >> I use SHIFT dragging a lot and this is an important issue for many >>people. Has anyone submitted a enhancement request before 2.0 comes >>out? Let's vote on it. >> One other nice touch Excel does is that it shows you the position >>you're dragging the block to it. >> -eric wood > >As far as I can tell, in OOo you can't even drag a column at all.
This sounds very similar to the suggestion I made a few months ago that OOo should allow you to rearrange rows or columns by drag and drop, which is what the MS Works spreadsheet does. It's very intuitive. (screenshots here:- http://www.xerez.demon.co.uk/ooo/moving-rows.htm I often have to do this sort of thing, re-ordering the headings in a list for instance, or moving rows of data from one category to another, and it's a pain to do in both OOo and Excel but a cinch in MS Works. -- _______________________________________________________________________ Please reply to group only: Do not 'CC' replies to me. _______________________________________________________________________ Sex is not the answer. Sex is the question. 'Yes' is the answer. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
