[Libreoffice-bugs] [Bug 141505] big CSV, Calc hangs when separator used in CSV was not selected when last file was opened

[bugzilla-daemon at bugs.documentfoundation.org]

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

Jean-Baptiste Faure <jbfaure at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |jbfaure at libreoffice.org

--- Comment #4 from Jean-Baptiste Faure <jbfaure at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210502/b04fabe3/attachment.htm>