Hi :) I think it is and always has been the default behaviour of all spreadsheets on all OSes. It's never occurred to me that it is oddly cumbersome. I suspect Mike just didn't notice because it's such a normal thing to have happen.
In the bug-report someone suggested a Cut Special just as there is a Paste Special and to use the shift key for that one too. I think that could be a brilliant idea. I just wonder why no-one else seems to have thought of this or why the idea might have been rejected if it ever was put forwards Regards from Tom :) >________________________________ > From: Steve Edmonds <[email protected]> >To: MR ZenWiz <[email protected]> >Cc: Michael Manning <[email protected]>; Tom Davies ><[email protected]>; LibreOffice <[email protected]> >Sent: Tuesday, 30 April 2013, 1:35 >Subject: Re: [libreoffice-users] New bug 64028: Calc forgets cell format when >cell is cut (^X) > > >I can confirm that CTL+X removes the character and number formatting in >LO 3.6 on opensuse. >Steve >On 2013-04-30 12:19, MR ZenWiz wrote: >> I'm running Xubuntu 12.04, LO 4.0.2.2. >> >> The pasted cell has the right format, but when I entered a 0 (zero) in >> the old cell (that was cut), it shows as 0, not $0.00, and the format >> shows as "Numbers" instead of "Currency." >> >> It happened over and over, even after I did several row cell re-formattings. >> >> I did not try doing copy, paste and reset, but I wouldn't expect that >> to be a problem. I'm guessing that the cut (^X) removes the >> formatting or resets it to the default. >> >> Strictly speaking, I used ^X to cut the cells and <return> to paste >> them (not ^V). Don't know if that makes a difference. >> >> I can produce a series of screen captures if that will help - it >> happens every time. >> >> Maybe it's not a problem on Windows (uh-oh...). >> >> On Mon, Apr 29, 2013 at 4:36 PM, Michael Manning >> <[email protected]> wrote: >>> Hi Tom, >>> In my setup, I was unable to recreate the issue being experienced by < >>> [email protected]> >>> Copying the currency-formatted cell to another cell copied both the value >>> and the formatting. The old cell retained its formatting as well. >>> >>> Not sure why <[email protected]> was experiencing this issue but it is >>> not reproducible in my system. >>> >>> regards >>> >>> Mike >>> > > >-- >For unsubscribe instructions e-mail to: [email protected] >Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette >List archive: http://listarchives.libreoffice.org/global/users/ >All messages sent to this list will be publicly archived and cannot be deleted > > > -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
