Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Took too long time to open 400K .xlsx files.|
|Product:||Calc||Reporter:||Li Lin Yi <lilinyi921734>|
|Component:||open-import||Assignee:||AOO issues mailing list <issues>|
|Status:||ACCEPTED ---||QA Contact:|
|Priority:||P2||CC:||hdu, issues, jingbaibetsy, kschenk, oliver.brinzing, oooforum|
|Issue Type:||PATCH||Latest Confirmation in:||4.1.7|
|Issue Depends on:|
Description Li Lin Yi 2012-04-16 08:42:10 UTC
Created attachment 77450 [details] Sample file. Took 1:14 minutes to open the attached sample file. It took only 11 seconds to open the same file on OO3.3.
Comment 2 email@example.com 2012-10-10 14:05:53 UTC
This regression was to be introduced by the CWS dr78: #164376# use XCellRangeData to increase import performance as it indirectly causes a lot of reformatting operations. Reverting the relevant changes or even just disabling the mechanism with a one-liner gets the performance of loading the document back to OOo33 levels. It would be interesting to have access to #164376# to identify use cases that benefit from the CWS changes, but this closed bugtracking system has apparently been lost for good. If the new AOO automated PVT tests show that just removing/disabling the changes helps without too much impact, then this should be done.
Comment 3 firstname.lastname@example.org 2012-10-17 14:27:30 UTC
Created attachment 79789 [details] remove the oox::xls::CellBlock cache The CellBlock cache introduced in CWS dr78 caused a major performance regression because it resulted in the document being reformatted over and over during XLSX import. As there is no simple fix to avoid the reformattings caused by the CellBlock cache it should be removed altogether.
Comment 4 email@example.com 2012-10-17 14:32:07 UTC
Comment on attachment 79789 [details] remove the oox::xls::CellBlock cache The patch reverts parts of the commit from CWS dr78 on 2011-02-25 "dr78: #164376# use XCellRangeData to increase import performance" but keeps the cleanups.
Comment 5 Kay 2016-07-17 23:09:34 UTC
This change was not included in 4.0.0. However, it may be still needed. We need some testing on this.
Comment 6 Marcus 2017-05-20 11:01:01 UTC
Reset assigne to the default "firstname.lastname@example.org".