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


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


On Tue, Apr 30, 2013 at 1:09 AM, Tom Davies <tomdavies04@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 <michaelgmanning@gmail.com>
*To:* Tom Davies <tomdavies04@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 <tomdavies04@yahoo.co.uk>wrote:

Hi :)
How about ^C instead and then hit the delete key.

Also maybe post a feature request?
Regards from
Tom :)





________________________________
From: MR ZenWiz <mrzenwiz@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+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






-- 
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.