[Libreoffice-bugs] [Bug 117418] Specific file causing LibreOffice to freeze completely when loading (FILEOPEN)

[bugzilla-daemon at bugs.documentfoundation.org]

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

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

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |jbfaure at libreoffice.org
         Resolution|---                         |NOTOURBUG

--- Comment #8 from Jean-Baptiste Faure <jbfaure at libreoffice.org> ---
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

-- 
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/20180616/7bef9465/attachment.html>