https://bugs.freedesktop.org/show_bug.cgi?id=77049
Priority: medium
Bug ID: 77049
Assignee: [email protected]
Summary: FILEOPEN: loss of zero when opening CSV file
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.2.1.1 release
Component: Spreadsheet
Product: LibreOffice
When opening CSV file, we lose the prepended zero when the cells containts only
numbers.
I guess the data is converted as NUMBER but for phone numbers for example, we
need the 0 at the begining (so the data should be kept as TEXT rather than
NUMBER).
Phone number is one example, but in my office, we use a lot of numbers with
some potentiel prepended zero.
When opening, Calc should only convert as NUMBER if the field containts digits
only AND do not start by 0.
--
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
