Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


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.edmonds@ptglobal.com>
To: MR ZenWiz <mrzenwiz@gmail.com> 
Cc: Michael Manning <michaelgmanning@gmail.com>; Tom Davies <tomdavies04@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
<michaelgmanning@gmail.com> wrote:
Hi Tom,
In my setup, I was unable to recreate the issue being experienced by  <
mrzenwiz@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  <mrzenwiz@gmail.com> was experiencing this issue but it is
not reproducible in my system.

regards

Mike



-- 
For unsubscribe instructions e-mail to: users+help@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+help@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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.