Description: Large file with lots of formula, conditional formatting and comments loading in 500 seconds or more. This is the TDF side of Collabora bug T58790. Actual Results: x Expected Results: x Reproducible: Always User Profile Reset: No Additional Info: x
Created attachment 200906 [details] sample file
Noel Grandin committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/79322a7025bb6fd61928204f90230560b09b4ba9 tdf#166684 strip out some unnecessary UNO work It will be available in 25.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/56da031f73f544d712b369f732f1ded1d3926fc2 tdf#166684 strip out some unnecessary UNO work (2) It will be available in 25.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/916e00d3a9a91680c6ce757ca2f37b81df732784 tdf#166684 suppress scanning of rotation attributes It will be available in 25.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/04986d105a2b81a2b549d722541f5aa3a04f3937 tdf#166684 avoid O(n^2) loop in ScDocument::AddValidationEntry It will be available in 25.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/c8742f36fa2bdc9d23042378f5b587ccda8b54dd tdf#166684 reduce cost of CellAttributeHelper::registerAndCheck It will be available in 25.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.
The improvements so far are outstanding. With 25.2 I get real 12m21,872s user 12m20,400s sys 0m1,112s With master including the previous commits I get real 0m8,802s user 0m9,717s sys 0m0,567s
Noel Grandin committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/b3df12b9781daa19eff2b1e30526e65ca2aaa193 tdf#166684 avoid O(n^2) loop when importing comments It will be available in 25.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/3d9f900c9e5466a66b9beeaa0d2b82c22063628a tdf#166684 make ScCondFormatItem hashable It will be available in 25.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.
Calc’s slow crawl when opening XLSX files stuffed with formulas and comments has been patched up, tagged for 25.8, and blessed with all the usual markers—filter:xlsx, perf, and a seat in the release notes. https://git.libreoffice.org/core/commit/79322a7025bb6fd61928204f90230560b09b4ba9 https://brainrot-clicker.io . A small victory, but in the land of spreadsheets, even shaving a second off loading time feels like opening a window in a stuffy room.
Noel Grandin committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/b1df5786458223f21f0eaa9627c0f4c6fa5f1747 tdf#166684 use hashing in CellAttributeHelper::registerAndCheck It will be available in 26.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/faf60b6443dab44bd46535f88f76b271b33b4d36 tdf#166684 use unordered_map/sorted_vector in registerAndCheck() It will be available in 26.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/e72a16a5002433a470f0ec8ac9bf3cf0db202774 tdf#166684 inline SfxStyleSheetIterator::GetSearchFamily It will be available in 26.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/b3024367fd9ba9d8b1a91dd22b37ca55ab8280e2 tdf#166684 avoid re-creating ExtConditional stylesheets It will be available in 26.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/2c115e8892cb26040c02b12b7b374430728361eb tdf#166684 used unordered_set for maCacheOwners It will be available in 26.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/1d9cc5964c7a2fd4dd9326c2c0bfa6ee48d67006 tdf#166684 fix O(n^2) loop in SvxStyleToolBoxControl::FillStyleBox It will be available in 26.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.