[Libreoffice-bugs] [Bug 114249] New: FILEOPEN, UI: "Text Import" dialog: option to treat every column as "text"

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 114249
           Summary: FILEOPEN, UI: "Text Import" dialog: option to treat
                    every column as "text"
           Product: LibreOffice
           Version: 5.4.3.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: clemty at gmail.com

Description:
By default, importing text into calc imports everything column as 'standard';
this may lead to unintended results[1]. A firsthand example is pasting barcodes
(i.e. text strings) which begin with leading zeroes - calc by default treats
these as numbers.

[1]:
https://science.slashdot.org/story/16/08/23/2222258/20-of-scientific-papers-on-genes-contain-conversion-errors-caused-by-excel-says-report

Steps to Reproduce:
1. paste/open csv data with leading zeroes (e.g. "00001")
2. in the import dialog, leave column type as "standard"
3. (note that the data is still presented as "00001" in the preview)
4. click ok
5. input gets converted to "1"

Actual Results:  
input gets changed to number (e.g. "1")

Expected Results:
depending on task, "00001" may be intended


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
I suggest a checkbox with text like "treat all input as text", which
disables/greys out the "column type" dropdown, and changes all column types to
"text" - leaving that box checked should make it much harder to shoot oneself
in the foot by accidentally converting strings to numbers/dates


User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; rv:11.0) like
Gecko

-- 
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/20171204/db252e3b/attachment.html>