[Libreoffice-bugs] [Bug 127062] New: Importing a CSV with "0123" as a value removes the leading 0

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 127062
           Summary: Importing a CSV with "0123" as a value removes the
                    leading 0
           Product: LibreOffice
           Version: 6.3.0.4 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: ben at crimson.net.nz

Created attachment 153541
  --> https://bugs.documentfoundation.org/attachment.cgi?id=153541&action=edit
Example file where 0123 becomes 123

I have attached an example CSV file that demonstrates this issue.

When importing the CSV the value "0123" shows in the preview as 0123 but after
clicking OK and viewing the new spreadsheet in Calc both A1 and B1 are set as
123 and the leading 0 is removed.

This causes phone numbers from an export to load without their leading digits
and become invalid.

Tested on the 6.3.0.4 and 6.0.7.3 releases on Ubuntu 18.04.

-- 
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/20190820/e8e779f2/attachment-0001.html>