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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
