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

            Bug ID: 89456
           Summary: CSV file missing columns
           Product: LibreOffice
           Version: 4.4.0.3 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: blocker
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs@lists.freedesktop.org
          Reporter: rob...@prino.org

Created attachment 113490
  --> https://bugs.documentfoundation.org/attachment.cgi?id=113490&action=edit
Five column CSV file

When opening the attached FIVE-column (where the first X in the fifth column
only appears in row 1670!) "lift & v100+.s8.csv", with the following options on
the import dialogue

Western Europe (DOS/OS2-437/US)
English (UK)
>From row 1

Separated by Comma + Merge Delimiters + Text delimiter "

Quoted Fields as text + Detect Special numbers both ticked

The "Fields area" only shows FOUR columns. Only scrolling down to row 1670 will
expand this to the expected 5 "standard" columns - BAD!

It gets worse:

Now click "Fixed width" and the "Fields area" shows only 22 columns - the
column containing the "X"es is gone again. Only scrolling down to row 1670 will
expand this to the expected 24 columns - BAD! 

It gets even worse:

Now, without doing anything, re-select "Separated by" and this time the "Fields
area" only shows TWO columns (and I've seen even one on occasion) - VERY BAD!

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to