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

On Mon, 11 Nov 2013 10:12:55 -0700
Oogie McGuire <> wrote:

What I would consider a bug is that changing the format of a cell
doesn't change the data.
And it shouldn't, it changes only the *format* of the data, not the
data itself.

I often get confused by this, expecting that when I change the format,
my data has changed, but format is just about how the data is
displayed, not about what the data is. Mostly this is absolutely
correct, and format should *absolutely not* change the data. Most of
the time when I have been expecting format to change the data is when I
have values that are text instead of numbers, and I format as numbers
and then expect to have numbers in the cell. There should be an easy
way to change from numbers to text and back (and the same for dates and
any other data types), but format isn't the way.

Just like i consider it a bug that if I select all cells in a
spreadsheet and change the font or the font size I expect the
contents of all cells to be modified to the new settings and it
doesn't happen that way. 
This doesn't work for you? I'm surprised. I haven't checked, but I'm
fairly sure it works as expected for me.


To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.