Description: With lots of rules the load time of such a document goes up to multiple 10s of minutes Actual Results: xxx Expected Results: xxx Reproducible: Always User Profile Reset: No Additional Info: xxx
This is a collabora bug, so the document is sadly internal/customer private
Technically this "problem" started at commit fcd96df8f648439ea191d8c2070e8b21ff0b1001 author Tibor Nagy <nagy.tibor2@nisz.hu> Wed Jan 06 2021 committer László Németh <nemeth@numbertext.org> Wed Jan 13 2021 tdf#113013 XLSX import: fix "Formula is" type conditional formatting rule when the formula contains a reference to another worksheet. But only because before that we did not bother loading the conditional formatting rule at all
https://gerrit.libreoffice.org/c/core/+/166180
Noel Grandin committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/dac30c44c606232ce23d52a423d0bf8010f25d4f tdf#160706 speed up loading conditional formatting rule in XLS It will be available in 24.8.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.
Noel Grandin committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/5060893f0b69c094beae73ab1a0926e3feb249b2 tdf#160706 speed up loading conditional formatting rule in XLS (II) It will be available in 24.8.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.
Noel Grandin committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/e1268721d4266ed1254da99581a7c2c3dfb72ba6 tdf#160706 speed up loading conditional formatting rule in XLS (3) It will be available in 24.8.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.
Noel Grandin committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/9b1bba2f9633b27cd822270d79f01be19db9c640 tdf#160706 speed up loading conditional formatting rule in XLS (4) It will be available in 24.8.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.