[Libreoffice-bugs] [Bug 133332] New: CSV Import in Calc ignores null values

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sun May 24 02:19:32 UTC 2020


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

            Bug ID: 133332
           Summary: CSV Import in Calc ignores null values
           Product: LibreOffice
           Version: 6.4.2.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: ed.ackerman at gmail.com

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

-- 
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/20200524/1eb9d183/attachment.htm>


More information about the Libreoffice-bugs mailing list