<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_RESOLVED bz_closed"
title="RESOLVED NOTOURBUG - Specific file causing LibreOffice to freeze completely when loading (FILEOPEN)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=117418">bug 117418</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;">Status</td>
<td>UNCONFIRMED
</td>
<td>RESOLVED
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>jbfaure@libreoffice.org
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>NOTOURBUG
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTOURBUG - Specific file causing LibreOffice to freeze completely when loading (FILEOPEN)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=117418#c8">Comment # 8</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTOURBUG - Specific file causing LibreOffice to freeze completely when loading (FILEOPEN)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=117418">bug 117418</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>The problem is not in LibreOffice, it is in the file. This file is not
corrupted.
LibreOffice 6.2.0.0.alpha0+ (current master) opens it without freezing the PC
and without crashing. That take only long time and a lot of memory because
there a sheet (Blackbox) with many useless data. These data are copies of the
same two tables containing no data, only headers or labels of cells.
The bigger of both table use 25 rows and 5 columns with some merged cells.
There is copies of these tables up to the last row of the sheet, that is more
than 1 000 000 rows, around 40 000 blocs of 2 tables.
To repair the file:
1/ I removed all blocs but the first one.
2/ I removed the formating in the non used part of the sheet
3/ I removed the merged cells in the non used part of the sheet.
It take me (my PC in fact) long time to do that, but the repaired file size is
now 18,4 kB...
@gregg: your problem is now to know why this sheet Blackbox has been filled
with so many empty tables.
Closing as NotOurBug. Feel free to reopen if you disagree.
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>