https://bugs.freedesktop.org/show_bug.cgi?id=87266
Bug ID: 87266
Summary: FILEOPEN: CSV (Text Import) data type Text incorectly
guessed as Numerical (Standard) while data begins with
zero
Product: LibreOffice
Version: 4.3.4.1 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Libreoffice
Assignee: [email protected]
Reporter: [email protected]
When opening a .csv file (FILEOPEN: CSV)
the Text Import tool launches (in background... see bug ID 73751 not resolved)
every column has a data type, the standard type makes th program guess the type
(theorical reminder)
when the type is text a database primary key may begin whith zero (i.e. 01234
is a text, 12345 is numeral), but the data type Text is incorectly guessed as
Numerical by the Standard methid. Therefore the zeros are truncated (01234 →
1234) and if user saves the file, data is altered.
This column should be recognised as a Text data type.
Note that this bug is unherited from the original Excell, maybe because primary
keys can't begin with a zero in the USA... However they do begin in with a zero
around here in Europe at gouvernemental agencies, this is serious.
Thank you.
Sample dataset (.csv EOF=End of file):
pk;city;zipcode;name;
01001;L ABERGEMENT CLEMENCIAT;01400;L'Abergement-Clémenciat;
EOF
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
