New bug 64028: Calc forgets cell format when cell is cut (^X)

classic Classic list List threaded Threaded
7 messages Options
MR ZenWiz MR ZenWiz
Reply | Threaded
Open this post in threaded view
|

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: [hidden email]
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

Tom Tom
Reply | Threaded
Open this post in threaded view
|

Re: 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 <[hidden email]>
>To: [hidden email]
>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: [hidden email]
>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: [hidden email]
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

odfman odfman
Reply | Threaded
Open this post in threaded view
|

Re: 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  <
[hidden email]>
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  <[hidden email]> 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 <[hidden email]> 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 <[hidden email]>
> *To:* Tom Davies <[hidden email]>
> *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 <[hidden email]>wrote:
>
> Hi :)
> How about ^C instead and then hit the delete key.
>
> Also maybe post a feature request?
> Regards from
> Tom :)
>
>
>
>
>
> >________________________________
> > From: MR ZenWiz <[hidden email]>
> >To: [hidden email]
> >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: [hidden email]
> >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: [hidden email]
> 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: [hidden email]
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

MR ZenWiz MR ZenWiz
Reply | Threaded
Open this post in threaded view
|

Re: 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
<[hidden email]> wrote:

> Hi Tom,
> In my setup, I was unable to recreate the issue being experienced by  <
> [hidden email]>
> 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  <[hidden email]> was experiencing this issue but it is
> not reproducible in my system.
>
> regards
>
> Mike
>

--
For unsubscribe instructions e-mail to: [hidden email]
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

V Stuart Foote V Stuart Foote
Reply | Threaded
Open this post in threaded view
|

Re: New bug 64028: Calc forgets cell format when cell is cut (^X)

In reply to this post by MR ZenWiz
Not clear if you are concerned with formatting of the source cell (which would be cleared bya  <Ctrl>+X) or with the formatting of the pasted cell which with <Ctrl>+V will paste formatting with default settings but could be set other than default.

Suspect all is functioning as designed.  Please see comments to fdo#64028 and respond there.
steveedmonds steveedmonds
Reply | Threaded
Open this post in threaded view
|

Re: New bug 64028: Calc forgets cell format when cell is cut (^X)

In reply to this post by MR ZenWiz
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
> <[hidden email]> wrote:
>> Hi Tom,
>> In my setup, I was unable to recreate the issue being experienced by  <
>> [hidden email]>
>> 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  <[hidden email]> was experiencing this issue but it is
>> not reproducible in my system.
>>
>> regards
>>
>> Mike
>>


--
For unsubscribe instructions e-mail to: [hidden email]
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

Tom Tom
Reply | Threaded
Open this post in threaded view
|

Re: 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 <[hidden email]>
>To: MR ZenWiz <[hidden email]>
>Cc: Michael Manning <[hidden email]>; Tom Davies <[hidden email]>; LibreOffice <[hidden email]>
>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
>> <[hidden email]> wrote:
>>> Hi Tom,
>>> In my setup, I was unable to recreate the issue being experienced by  <
>>> [hidden email]>
>>> 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  <[hidden email]> was experiencing this issue but it is
>>> not reproducible in my system.
>>>
>>> regards
>>>
>>> Mike
>>>
>
>
>--
>For unsubscribe instructions e-mail to: [hidden email]
>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: [hidden email]
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