Re: [libreoffice-users] CALC convert text to numbers

On Mon, 11 Nov 2013 10:12:55 -0700
Oogie McGuire <oogiem@desertweyr.com> 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.


Paul

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