[Libreoffice-bugs] [Bug 36621] New: Error importing CSV file with empty cells and no text delimiters (FILEOPEN)

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=36621

           Summary: Error importing CSV file with empty cells and no text
                    delimiters (FILEOPEN)
           Product: LibreOffice
           Version: LibO 3.3.2 release
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: phil.ganchev at gmail.com


LibreOffice and OpenOffice misunderstands CSV files that have empty cells and
no text delimiters. Such files are very common.

For example, use a text editor to create a CSV file containing just the
following:

,,1

Then open the file with Calc. Calc should interpret this as two leading blank
cells followed by a cell containing the numeric value '1'. However, Calc shows
this as *one* leading blank cell followed by the value '1'.

The same happens if you use Calc to save a file as CSV using an empty "text
delimiter" string. This creates the CSV file correctly. So Calc cannot read the
CSV files it creates.

Of course, if you use the default text delimiter, the file contents would be:

"","",1

In that case, Calc reads it correctly.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.