[Libreoffice-bugs] [Bug 138537] New: Import CSV sometimes change delimeted char-values to numbers

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=138537

            Bug ID: 138537
           Summary: Import CSV sometimes change delimeted char-values to
                    numbers
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Chart
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: kuerbis42 at yahoo.de

Created attachment 167635
  --> https://bugs.documentfoundation.org/attachment.cgi?id=167635&action=edit
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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201128/03e82084/attachment.htm>