[Libreoffice-bugs] [Bug 133277] FILEOPEN importing csv file results in error message and rather garbled spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=133277 Dirk Munk changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #7 from Dirk Munk --- I found the problem. It was the string delimiter > ' < . Many names of streets and places look like 's-Gravenhage, and that is where it went wrong. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133277] FILEOPEN importing csv file results in error message and rather garbled spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=133277 QA Administrators changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133277] FILEOPEN importing csv file results in error message and rather garbled spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=133277 --- Comment #6 from QA Administrators --- [Automated Action] NeedInfo-To-Unconfirmed -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133277] FILEOPEN importing csv file results in error message and rather garbled spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=133277 --- Comment #5 from Dirk Munk --- Created attachment 161157 --> https://bugs.documentfoundation.org/attachment.cgi?id=161157=edit csv import dialog This is my import dialog box, doesn't change anything I'm afraid. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133277] FILEOPEN importing csv file results in error message and rather garbled spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=133277 V Stuart Foote changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 --- Comment #4 from V Stuart Foote --- Can not confirm on Windows with Version: 6.4.4.1 (x64) Build ID: b50bc319eca5cd5b66fbfe2ebd0d3bd1eed099b5 CPU threads: 8; OS: Windows 10.0 Build 18362; UI render: GL; VCL: win; Locale: nl-NL (en_US); UI-Language: en-US Calc: CL Please retest but correctly configure the local and then the CSV filters from the Text Import dialog. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133277] FILEOPEN importing csv file results in error message and rather garbled spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=133277 V Stuart Foote changed: What|Removed |Added CC||vstuart.fo...@utsa.edu --- Comment #3 from V Stuart Foote --- Created attachment 161154 --> https://bugs.documentfoundation.org/attachment.cgi?id=161154=edit Text import dialog for the Semicolon separated CSV attachment 161149 I had no issues importing the CSV using the Text Import dialog. I had to be sure the locale set used comma as decimal separator (Tools -> Options -> Languages) and on the Text Import dialog, to set the Searator Options to _just_ the Semicolon check box. I also set the Fields column type to correct date format determined visual scan of the preview. On import sheet is created with 7109 rows, no LO complaint/warning and visual inspection all cells seem correctly populated with no run overs. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133277] FILEOPEN importing csv file results in error message and rather garbled spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=133277 --- Comment #2 from Dirk Munk --- Created attachment 161150 --> https://bugs.documentfoundation.org/attachment.cgi?id=161150=edit The resulting spreadsheet -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 133277] FILEOPEN importing csv file results in error message and rather garbled spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=133277 Dirk Munk changed: What|Removed |Added CC||m...@home.nl --- Comment #1 from Dirk Munk --- Created attachment 161149 --> https://bugs.documentfoundation.org/attachment.cgi?id=161149=edit The file that I was trying to import -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs