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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
