[Libreoffice-bugs] [Bug 137651] New: Importing CSV automatically converts data with no possibility of tweaking

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 137651
           Summary: Importing CSV automatically converts data with no
                    possibility of tweaking
           Product: LibreOffice
           Version: 7.0.1.2 release
          Hardware: x86-64 (AMD64)
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: andrei.dascalu.eng at gmail.com

Description:
Hello,

I have a CSV with lines in the form of:


A0050,VP 2015-01,P301,ASR Schadeverzekering
N.V.,02500,auto,Motor,02008,Wettelijke
Aansprakelijkheid,02001,303,144,447,m,x,x,x

As not all fields are properly quoted, data like "02500" is automatically
converted to "2500" as a number. It doesn't seem possible to ask Calc to leave
everything as text or some other manual tweaks to prevent loss of data in a
case like this.

I am quite sure that in 6.x checking "format quoted fields as text" also left
this data untouched as text, as I've imported data in this form before.

A definite issue:
- the preview part of the CSV import shows my data correctly (eg 02500 instead
of 2500), however after the import it becomes 2500 with no possibility of
preventing this.

Steps to Reproduce:
1. Have a CSV file in the form described above
2. Open it
3. Observe the data preview
4. complete the import and observe the same data

Actual Results:
preview data: "02500"
after import: "2500"

Expected Results:
1. preview data consistent with data after import
2. have an option to not convert data at all (eg: leave everything as text)


Reproducible: Always


User Profile Reset: No



Additional Info:
Expected result #2 is more of a feature request, it would definitely be useful

-- 
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/20201021/812e891b/attachment-0001.htm>