<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Importing a CSV with "0123" as a value removes the leading 0"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=127062">127062</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Importing a CSV with "0123" as a value removes the leading 0
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.3.0.4 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>ben@crimson.net.nz
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=153541" name="attach_153541" title="Example file where 0123 becomes 123">attachment 153541</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=153541&action=edit" title="Example file where 0123 becomes 123">[details]</a></span>
Example file where 0123 becomes 123
I have attached an example CSV file that demonstrates this issue.
When importing the CSV the value "0123" shows in the preview as 0123 but after
clicking OK and viewing the new spreadsheet in Calc both A1 and B1 are set as
123 and the leading 0 is removed.
This causes phone numbers from an export to load without their leading digits
and become invalid.
Tested on the 6.3.0.4 and 6.0.7.3 releases on Ubuntu 18.04.</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>