<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Calc: Display mismatch - initial quote displayed if followed by letters but not if followed by digits"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142050">bug 142050</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>NOTABUG
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>erack@redhat.com
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>RESOLVED
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Calc: Display mismatch - initial quote displayed if followed by letters but not if followed by digits"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142050#c1">Comment # 1</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Calc: Display mismatch - initial quote displayed if followed by letters but not if followed by digits"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142050">bug 142050</a>
from <span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span></b>
<pre>(In reply to Hajo from <a href="show_bug.cgi?id=142050#c0">comment #0</a>)
<span class="quote">> initial quote displayed if followed by letters but not if followed by digits
> An initial quote should not be displayed in a cell.</span >
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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>