<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 - FILEOPEN, UI: "Text Import" dialog: option to treat every column as "text""
href="https://bugs.documentfoundation.org/show_bug.cgi?id=114249">114249</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILEOPEN, UI: "Text Import" dialog: option to treat every column as "text"
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.4.3.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>enhancement
</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>clemty@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
By default, importing text into calc imports everything column as 'standard';
this may lead to unintended results[1]. A firsthand example is pasting barcodes
(i.e. text strings) which begin with leading zeroes - calc by default treats
these as numbers.
[1]:
<a href="https://science.slashdot.org/story/16/08/23/2222258/20-of-scientific-papers-on-genes-contain-conversion-errors-caused-by-excel-says-report">https://science.slashdot.org/story/16/08/23/2222258/20-of-scientific-papers-on-genes-contain-conversion-errors-caused-by-excel-says-report</a>
Steps to Reproduce:
1. paste/open csv data with leading zeroes (e.g. "00001")
2. in the import dialog, leave column type as "standard"
3. (note that the data is still presented as "00001" in the preview)
4. click ok
5. input gets converted to "1"
Actual Results:
input gets changed to number (e.g. "1")
Expected Results:
depending on task, "00001" may be intended
Reproducible: Always
User Profile Reset: Yes
OpenGL enabled: Yes
Additional Info:
I suggest a checkbox with text like "treat all input as text", which
disables/greys out the "column type" dropdown, and changes all column types to
"text" - leaving that box checked should make it much harder to shoot oneself
in the foot by accidentally converting strings to numbers/dates
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; rv:11.0) like
Gecko</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>