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: [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
