On Mon, 11 Nov 2013 02:56:51 +0200 Ady <ady...@hotmail.com> wrote: > As a simple user, I see this "hidden" addition of the initial single > quotation mark as a _BUG_, and as one of those basic "features" that > work poorly in LibreOffice Calc than in several other spreadsheet > tools. I don't know if this behavior can be "corrected" or improved.
As far as I understand it, the "hidden" initial quotation mark is what marks the contents of the cell as text. This is the same in MS Excel, IIRC. So basically, this isn't a bug, but intended behaviour, to give you a way to specify that a number should be interpreted as text and not as a number. For example, if you enter "0283", the leading zero will always be stripped, because it is interpreted as a number and the leading zero is superfluous, but if you enter "'0283", then this means you have entered a text string and the leading zero is kept. The format of the cell doesn't change this behavior, it only changes the *display* of the contents, not the interpretation of the contents. At least, as I understand it. Paul -- To unsubscribe e-mail to: users+unsubscr...@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