Bug 133332 - CSV Import in Calc ignores null values
Summary: CSV Import in Calc ignores null values
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.2.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-05-24 02:19 UTC by Ed Ackerman
Modified: 2020-05-24 23:12 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Import options screenshot (69.47 KB, image/png)
2020-05-24 08:42 UTC, m_a_riosv 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Ed Ackerman 2020-05-24 02:19:32 UTC 
Description:
When importing a CSV file with null values ie. '99,,,,99' the null values do not go into the appropriate columns. Instead of '99| | | |99' with the vertical bars indicating columns you get '99|99'

Steps to Reproduce:
1. Go to covidtracking.com
2. select USA history in CSV format
3. open file with CALC

Actual Results:
99|99

Expected Results:
99| | | |99


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Vertical bars represent columns
Comment 1 m_a_riosv 2020-05-24 08:42:09 UTC 
Created attachment 161218 [details]
Import options screenshot

With the options for import as in the attached, works fine for me.
Comment 2 Ed Ackerman 2020-05-24 23:12:54 UTC 
It was the merge delimiters option, it is checked by default in my version. Unchecking it resolved the issue.