https://bugs.documentfoundation.org/show_bug.cgi?id=141505
Jean-Baptiste Faure <jbfa...@libreoffice.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |jbfa...@libreoffice.org
--- Comment #4 from Jean-Baptiste Faure <jbfa...@libreoffice.org> ---
Created attachment 171591
--> https://bugs.documentfoundation.org/attachment.cgi?id=171591&action=edit
exemple of big CSV file with semicolon separator
We have a similar problem with the CSV file
"donnees-hospitalieres-covid19-2021-05-01-19h09.csv" provided here:
https://www.data.gouv.fr/fr/datasets/donnees-hospitalieres-relatives-a-lepidemie-de-covid-19/
and attached here.
Step to reproduce the problem:
1/ open a small CSV file with comma separator with LO Calc then close it;
2/ try to open the attached file (first unzip it); you can use 2 methods:
2a/ File > Open
2b/ Sheet > Insert Sheet from File
In both cases Calc hangs and doesn't show the CSV import dialog and consumes
100% of its CPU.
In fact, in this CSV file, the third first columns are text enclosed between ""
even if data seems being numerical data.
If, using a text editor, I remove all "" except in the first row, then the file
opens without problem in Calc regardless of the separator that the CSV import
dialog has stored.
My guess is that the CSV import dialog try to find the first row with data and
considers that rows starting with " belong to the header.
Best regards. JBF
--
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
