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: [email protected]
Reporter: [email protected]
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
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs