On 11/11/2013 09:30 AM, Denis Navas Vega wrote:
El 2013-11-10 07:40 p.m., Paul escribió:
On Mon, 11 Nov 2013 02:56:51 +0200
Ady <[email protected]> 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
Paul,
The problem is with the symbol ' It can't be searched and replaced.
That's why Ady consider it a bug.
The only solution, which I used yesterday, is multiply by one.
More than a bug, we must consider it an incomplete implementation of
the meaning of ' to accept figures as text. The operator should be
reachable from Calc interface and not hidden.
As already said, this is all expected and happens in Excel also. There
is some long technical reason why, I'm sure someone has written about it
online if you google a bit :)
Best,
Joel
--
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
