At 08:01 15/11/2013 +0100, Stefan Weigel wrote:
Am 14.11.2013 22:39, schrieb Brian Barker:It's worth mentioning that this is a misunderstanding of what is happening. There is no apostrophe in the cell to remove.Yes there is!
Sorry, but that's simply untrue - and you can easily show it. Type '1234 into a cell, so that you get the four-character text string 1234 in the cell (not the five-character string '1234). Now put =LEFT(Xn;1) in another cell - to extract just the first character. According to your theory, this formula should evaluate to just the apostrophe - or perhaps you think that the apostrophe would be suppressed and you would see nothing. But neither of these is that case: instead, you see the true first character, "1".
It's because these cell contents are very different that the apostrophe is necessary as a warning.It's not a warning, it's an operator. It's somewhat like the = at the beginning of a formula.
It's an operator when you include it in typing into a cell: it ensures that what you type is stored as text and not converted to a number. But it's surely not an operator when it appears in the Input Line. If it were an operator there, what operation do you think it would perform?
Brian Barker -- 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