<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:jbfaure@libreoffice.org" title="Jean-Baptiste Faure <jbfaure@libreoffice.org>"> <span class="fn">Jean-Baptiste Faure</span></a>
</span> changed
<a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - big CSV, Calc hangs when separator used in CSV was not selected when last file was opened"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=141505">bug 141505</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>jbfaure@libreoffice.org
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - big CSV, Calc hangs when separator used in CSV was not selected when last file was opened"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=141505#c4">Comment # 4</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - big CSV, Calc hangs when separator used in CSV was not selected when last file was opened"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=141505">bug 141505</a>
from <span class="vcard"><a class="email" href="mailto:jbfaure@libreoffice.org" title="Jean-Baptiste Faure <jbfaure@libreoffice.org>"> <span class="fn">Jean-Baptiste Faure</span></a>
</span></b>
<pre>Created <span class=""><a href="https://bugs.documentfoundation.org/attachment.cgi?id=171591" name="attach_171591" title="exemple of big CSV file with semicolon separator">attachment 171591</a> <a href="https://bugs.documentfoundation.org/attachment.cgi?id=171591&action=edit" title="exemple of big CSV file with semicolon separator">[details]</a></span>
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:
<a href="https://www.data.gouv.fr/fr/datasets/donnees-hospitalieres-relatives-a-lepidemie-de-covid-19/">https://www.data.gouv.fr/fr/datasets/donnees-hospitalieres-relatives-a-lepidemie-de-covid-19/</a>
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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>