<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 - Import CSV sometimes change delimeted char-values to numbers"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138537">138537</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Import CSV sometimes change delimeted char-values to numbers
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>unspecified
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (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>Chart
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>kuerbis42@yahoo.de
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=167635" name="attach_167635" title="IP-Table">attachment 167635</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=167635&action=edit" title="IP-Table">[details]</a></span>
IP-Table
When importing this: (Line 575)
First occured at line 1, then 73
.....
"1.72.0.0","1.79.255.255","JP","Japan"
"1.80.0.0","1.95.255.255","CN","China"
"1.96.0.0","1.111.255.255","KR","Korea (Republic of)"
"1.112.0.0","1.115.255.255","JP","Japan"
"1.116.0.0","1.119.255.255","CN","China"
"1.120.0.0","1.159.255.255","AU","Australia"
"1.160.0.0","1.174.206.255","TW","Taiwan (Province of China)"
"1.174.207.0","1.174.207.255","NO","Norway"
"1.174.208.0","1.175.255.255","TW","Taiwan (Province of China)"
.....
"1.208.0.0","1.255.255.255","KR","Korea (Republic of)"
"2.0.0.0","2.16.0.255","FR","France"
....
the result is this (misformated tab 'cause of copy&paste, that's not the
fault):
....
1.72.0.0 1.79.255.255 JP Japan
1.80.0.0 1.95.255.255 CN China
1.96.0.0 1111255255 KR Korea (Republic of)
1.112.0.0 1115255255 JP Japan
1.116.0.0 1119255255 CN China
1.120.0.0 1159255255 AU Australia
1.160.0.0 1174206255 TW Taiwan (Province of China)
1.174.207.0 1174207255 NO Norway
1.174.208.0 1175255255 TW Taiwan (Province of China)
....
1.208.0.0 1255255255 KR Korea (Republic of)
2.0.0.0 2.16.0.255 FR France
.....
But not only at the beginning, there are serveral faults like this after
import.
Anonther fault:
Line 288:
if your list is ,-seperated, this makes trouble:
....
"34729984","34732031","IT","Italy"
"34732032","34732287","UG","Uganda"
"34732288","34732543","AM","Armenia"
"34732544","34732799","TZ","Tanzania, United Republic of"
"34732800","34733055","DE","Germany"
"34733056","34733823","TR","Turkey"
"34733824","34734079","US","United States of America"
....
result in:
2.17.240.0 2.17.247.255 IT Italy
2.17.248.0 2.17.248.255 UG Uganda
2.17.249.0 2.17.249.255 AM Armenia
2.17.250.0 2.17.250.255 TZ Tanzania"2.17.251.0 2.17.251.255
DE Germany
2.17.252.0 2.17.254.255 TR Turkey
2.17.255.0 2.17.255.255 US United States of America
2.18.0.0 2.18.3.255 IT Italy
At the preview, all looks fine
Reproducible: Always
Steps to Reproduce:
1. right click attached csv
2. select open with libreoffice
3. use standard setting (UTF-8, german, Seperator: , character delimeter: ")
Version: 6.4.7.2 (x64)
Build-ID: 639b8ac485750d5696d7590a72ef1b496725cfb5
CPU-Threads: 12; BS: Windows 10.0 Build 18363; UI-Render: GL; VCL: win;
Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE
Calc: threaded</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>