Re: [libreoffice-users] New bug 64028: Calc forgets cell format when cell is cut (^X)
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 steve.edmo...@ptglobal.com To: MR ZenWiz mrzen...@gmail.com Cc: Michael Manning michaelgmann...@gmail.com; Tom Davies tomdavie...@yahoo.co.uk; LibreOffice users@global.libreoffice.org 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 michaelgmann...@gmail.com wrote: Hi Tom, In my setup, I was unable to recreate the issue being experienced by mrzen...@gmail.com 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 mrzen...@gmail.com was experiencing this issue but it is not reproducible in my system. regards Mike -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org 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: users+h...@global.libreoffice.org 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
Re: [libreoffice-users] New bug 64028: Calc forgets cell format when cell is cut (^X)
Hi Tom, In my setup, I was unable to recreate the issue being experienced by mrzen...@gmail.com 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 mrzen...@gmail.com 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 tomdavie...@yahoo.co.uk 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 michaelgmann...@gmail.com *To:* Tom Davies tomdavie...@yahoo.co.uk *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 tomdavie...@yahoo.co.ukwrote: Hi :) How about ^C instead and then hit the delete key. Also maybe post a feature request? Regards from Tom :) From: MR ZenWiz mrzen...@gmail.com To: users@global.libreoffice.org 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: users+h...@global.libreoffice.org 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: users+h...@global.libreoffice.org 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: users+h...@global.libreoffice.org 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
Re: [libreoffice-users] New bug 64028: Calc forgets cell format when cell is cut (^X)
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 michaelgmann...@gmail.com wrote: Hi Tom, In my setup, I was unable to recreate the issue being experienced by mrzen...@gmail.com 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 mrzen...@gmail.com was experiencing this issue but it is not reproducible in my system. regards Mike -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org 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
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 michaelgmann...@gmail.com wrote: Hi Tom, In my setup, I was unable to recreate the issue being experienced by mrzen...@gmail.com 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 mrzen...@gmail.com was experiencing this issue but it is not reproducible in my system. regards Mike -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org 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
[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: users+h...@global.libreoffice.org 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
Re: [libreoffice-users] New bug 64028: Calc forgets cell format when cell is cut (^X)
Hi :) How about ^C instead and then hit the delete key. Also maybe post a feature request? Regards from Tom :) From: MR ZenWiz mrzen...@gmail.com To: users@global.libreoffice.org 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: users+h...@global.libreoffice.org 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: users+h...@global.libreoffice.org 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