<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 - Symbol ' inserted before number when changing language in number formating screen"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=136892">bug 136892</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;">Status</td>
<td>UNCONFIRMED
</td>
<td>RESOLVED
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>NOTABUG
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Symbol ' inserted before number when changing language in number formating screen"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=136892#c1">Comment # 1</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Symbol ' inserted before number when changing language in number formating screen"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=136892">bug 136892</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>This is not a bug. When you are opening a CSV, you may fine-tune how the
characters there should be treated; which locale to use to decide if cells
contain numbers or texts. If your CSV had numbers using dots as decimal
separators, you should either chose respective language in the CSV import
dialog, or set column types explicitly.
If you had imported your CSV using wrong settings, and your data could not be
converted to numbers because of those wrong settings, the data is of course
textual. From now on, it will stay textual, no matter how you reformat your
cells, unless you re-enter the data (e.g., convert it using Data->Text to
Columns).
When you change the language of the cells that already contain text into en-US,
those cells that contain text that *looks* like numbers in that language gets a
hint - the leading apostrophe - to show you that the cell has *text* that would
otherwise be handled as number, if you re-enter it into this cell.
This is works as expected.</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>