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