[Libreoffice-bugs] [Bug 142050] Calc: Display mismatch - initial quote displayed if followed by letters but not if followed by digits

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=142050

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
                 CC|                            |erack at redhat.com
             Status|UNCONFIRMED                 |RESOLVED

--- Comment #1 from Mike Kaganski <mikekaganski at hotmail.com> ---
(In reply to Hajo from comment #0)
> initial quote displayed if followed by letters but not if followed by digits
> An initial quote should not be displayed in a cell.

This is a misconception.
Initial single quote is *only* treated specially on input when the rest of the
string *may* be treated as number, in a cell that otherwise tries to interpret
the input (has number format other than "Text"). It is used to indicate that
this following "number" should be treated as literal text. The single quote is
not a part of the data in cell, would not be written into the file, would not
be found when searching, and would only be shown in formula bar to help you see
this "number being a string".

When the data may *not* be converted to number, the leading single quote is not
treated specially. This works as intended.

Case when single quote before *alphabetical* characters is treated specially:
in en-US locale, enter

'Oct 10

Case when single quote before *numeric* characters is not treated specially:

'123+123

In first case, the interpreter *could* convert "Oct 10" to a date, and thus the
quote is treated as a hint to not do that. In the second case, the "123+123"
cannot be converted to a number, and thus the whole string (including the
leading apostrophe) is considered verbatim.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210503/933741a3/attachment.htm>