[Libreoffice-bugs] [Bug 119722] New: Losing Dots when importing a CSV with IPv4 addresses

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 119722
           Summary: Losing Dots when importing a CSV with IPv4 addresses
           Product: LibreOffice
           Version: 6.0.5.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: thomas.seeling at gmx.net

Created attachment 144713
  --> https://bugs.documentfoundation.org/attachment.cgi?id=144713&action=edit
CSV file with IPv4 addresses

I have to work with CSV files quite often (reports generated from scripts). I
noticed that LO has a serious problem with IPv4 addresses (IPs and subnet
masks). Some IPs get imported as they should while others lose the dots. LO
shouldn't change the data at all. When I look at the format menu the column is
marked as "number" but obviously it cannot be a number if it contains 3 dots,
so LO should autoformat as "Text".

See attached bugreport.csv. First line is ok, second and third not.

Open Dialog, select CSV file, select "semicolon" and leave other settings as
default.

Works:
10.112.0.171

Does not work:
10111216147
10111216148

For now as a quick workaround my scripts generate CSV with quotes. The quotes
get imported into the cells as well, so then I mark all columns as "Text" and
do a global search+replace from " to <nothing> but this is quite ugly.

-- 
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/20180906/2f1faa2d/attachment.html>