Bug 133858 - opening spreadsheet with large array formula takes 10 mins
Summary: opening spreadsheet with large array formula takes 10 mins
Status: ASSIGNED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.0.0.alpha0+ Master
Hardware: All Linux (All)
: medium normal
Assignee: Noel Grandin
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-06-10 11:43 UTC by Noel Grandin
Modified: 2020-07-02 11:27 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Noel Grandin 2020-06-10 11:43:58 UTC
Description:

This spreadsheet has lots of formulas that do SUM(IF... over a whole column.

The spreadsheet takes 5 min to load on my machine on current master.

This is an internal Collabora bug and the document is not shareable.


Actual Results:
 

Expected Results:
 


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 Commit Notification 2020-06-10 18:44:35 UTC
Noel Grandin committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/9a5f2961b085ce2f23ecdf0a03d1114bacac8e2c

tdf#133858 opening spreadsheet with large array formula takes 10 mins

It will be available in 7.1.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 2 Commit Notification 2020-06-11 06:44:22 UTC
Noel Grandin committed a patch related to this issue.
It has been pushed to "libreoffice-7-0":

https://git.libreoffice.org/core/commit/44a56e277f7e4d222767fa82f0bce2e7f51be6ca

tdf#133858 opening spreadsheet with large array formula takes 10 mins

It will be available in 7.0.0.1.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 3 Joel Madero 2020-06-24 15:27:28 UTC
The solution for this bug created a much more serious issue (see tdf#134234). I think it needs to be reverted.
Comment 4 Commit Notification 2020-06-25 07:24:33 UTC
Noel Grandin committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/6f151be2994b0e78a890c13ccdd9249f1800c6de

Revert "tdf#133858 opening spreadsheet with large array formula takes 10 mins" (tdf#134234)

It will be available in 7.1.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 5 Commit Notification 2020-06-25 09:55:13 UTC
Noel Grandin committed a patch related to this issue.
It has been pushed to "libreoffice-7-0":

https://git.libreoffice.org/core/commit/e2ec8e1f3fac6fc0a426b5735ad21371c68760ae

Revert "tdf#133858 opening spreadsheet with large array formula takes 10 mins" (tdf#134234)

It will be available in 7.0.0.1.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 6 Roman Kuznetsov 2020-06-25 19:58:03 UTC
set to NEW by Comment 5