On Mon, 11 Nov 2013 10:12:55 -0700 Oogie McGuire <[email protected]> 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: [email protected] 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
