On Wednesday 21 March 2007, TomW wrote: > Wendy Howard wrote: > > I'm running Windows XP Pro and OOo 2.1 > > > > Is there a one-step equivalent in Calc to Excel's > > "Insert Cut Cells" after one has "Cut" a row? I can't > > see how to do it without taking the extra steps of (1) > > inserting a new row before pasting the contents into it > > and (2) deleting the old row. > > > > Have been a subscriber to this list for a couple of > > weeks now, and have learned a lot. Hoping someone can > > add to that knowledge now, on something that has been > > puzzling me for a while. :-) > > > > Kind Regards, > > Wendy Howard > > Kaiwaka, New Zealand > > > > ------------------------------------------------------- > >-------------- To unsubscribe, e-mail: > > [EMAIL PROTECTED] For additional > > commands, e-mail: [EMAIL PROTECTED] > > I find the behavior of OO Calc very odd when trying to > insert a row (or column) of data. One can 'Copy' a row, > and using a PasteSpecial option, insert the row. But if > one 'Cuts' the row, PasteSpecial only allows you to > 'overwrite' or 'shift right'. With cutting an entire > row, this will fail. Cutting a column behaves the same. > It gets even stranger. If you take your 'Cut' row and > 'Paste' it to some row, you then can use the > 'PasteSpecial' option to insert a row with the proper > shift. Trying to insert a 'cut' column will only allow a > 'shift down' in 'PasteSpecial. > Trying to insert cells behaves similarly. > It is like the default row or column 'insert' movements > are reversed. > > TomW > WinXP SP2 OO 2.1 > > --------------------------------------------------------- >------------ To unsubscribe, e-mail: > [EMAIL PROTECTED] For additional commands, > e-mail: [EMAIL PROTECTED]
Why are you using pastespecial and not just paste? -- If the word following begins with a vowel, the word you want is... to read the rest of this, go here http://www.wsu.edu/~brians/errors/a.html --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
