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: libreoffice-bugs@lists.freedesktop.org Reporter: jackvig...@yahoo.com 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 Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs