[Libreoffice-bugs] [Bug 136013] New: FILEOPEN Importing tsv/csv with no string delimiter causes whitespace only trailing column to corrupt

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 136013
           Summary: FILEOPEN Importing tsv/csv with no string delimiter
                    causes whitespace only trailing column to corrupt
           Product: LibreOffice
           Version: 5.4.7.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: andrew at brainfloat.com

Description:
When importing a tsv or csv without string delimiters, if the final column
consists of only whitespace it adds corrupt data to that column.

If the final column is empty the row loads correctly. Also if the string
delimiter is set to anything (even if the delimiter character does not appear
in the document) the file loads correctly.

One interesting behavior is initially the csv import dialog doesn't show
corruption in the preview, however if you change any options the corruption
appears.

Tested reproducible on versions 5.4, 6.4, 7.0

Steps to Reproduce:
1. Have CSV/TSV file without string delimiters and with trailing column
consisting of only whitespace
2. Turn off string delimiters in import dialog box
3. Click OK

Actual Results:
Right hand column contains corrupt data

Expected Results:
Right hand column blank


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Version: 7.0.0.3 (x64)
Build ID: 8061b3e9204bef6b321a21033174034a5e2ea88e
CPU threads: 24; OS: Windows 10.0 Build 19041; UI render: Skia/Vulkan; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: CL

-- 
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/20200822/91e53c2c/attachment-0001.htm>