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 On Tue, Apr 30, 2013 at 1:09 AM, Tom Davies <[email protected]> wrote: > Hi :) > Has > Ctrl C > solved the problem? The old cell keeps the formatting doesn't it? > > If a new problem is that you don't want the new cell to have the same > formatting as the old cell then try > Shift Ctrl V > to get the "Paste Special" dialogue up and choose "Paste as unformattted > text" in there. However i didn't think this was part of your problem, i > thought you liked the new cell having the same formatting the old one had? > Regards from > Tom :) > > > > ------------------------------ > *From:* Michael Manning <[email protected]> > *To:* Tom Davies <[email protected]> > *Sent:* Monday, 29 April 2013, 4:05 > *Subject:* Re: [libreoffice-users] New bug 64028: Calc forgets cell > format when cell is cut (^X) > > I am using Windows 7 and LO Version 4.0.2.2 (Build ID: > 4c82dcdd6efcd48b1d8bba66bfe1989deee49c3) > > In my test spreadsheet, I have numbers formatted as currency. If I copy a > cell (ctrl-C) or cut a cell (ctrl-X) and then paste that into a new cell > with ctrl-V, the new cell not only contains the value but is also formatted > as currency. > > regards Mike > > > > On Mon, Apr 29, 2013 at 11:51 AM, Tom Davies <[email protected]>wrote: > > Hi :) > How about ^C instead and then hit the delete key. > > Also maybe post a feature request? > Regards from > Tom :) > > > > > > >________________________________ > > From: MR ZenWiz <[email protected]> > >To: [email protected] > >Sent: Monday, 29 April 2013, 0:47 > >Subject: [libreoffice-users] New bug 64028: Calc forgets cell format when > cell is cut (^X) > > > > > >FYI for the list: > > > >I use ^X to cut the contents of a cell to transfer it to another cell, > >and Calc forgets what the format in that cell was. I have to reformat > >the cell to get it back. > > > >Most of my Calc cells are formatted for currency, with a few > >exceptions, all in the same spreadsheet. > > > >This is really irritating and totally wrong. > > > >MR > > > >-- > >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 > > > > > -- 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
