Performing Format > Autoformat Styles and choosing any style on blank document causes Calc hang with high CPU usage. To trigger the reported bug: 1) Open blank document 2) Edit > Select All 3) Format > Autoformat > Any style Selecting only part of the document works as intended.
Repro Version: 6.3.0.0.alpha0+ Build ID: 20ea90a557b5bc744fd234e3a20ab1db484cf88b CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win; TinderBox: Win-x86@42, Branch:master, Time: 2019-03-22_03:21:58 Locale: nl-NL (nl_NL); UI-Language: en-US Calc: threaded and with 4.4.7.2 -> I leave it unconfirmed of now; not sure if this qualify's
already reproducible with AOO 4.1.5. possible fix: a warning could appear in case a huge number cells was selected
Doesn't hang. Closing as WFM Version: 7.1.2.2 (x64) / LibreOffice Community Build ID: 8a45595d069ef5570103caea1b71cc9d82b2aae4 CPU threads: 2; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win Locale: fi-FI (fi_FI); UI: fi-FI Calc: threaded
Was wrong, this is a dupe and only seen with row-alternate shading (Box List styles...) *** This bug has been marked as a duplicate of bug 115474 ***
https://gerrit.libreoffice.org/c/core/+/171223
Mike Kaganski committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/42f44a42b625002c8f0e4e832ec457481d89a54c tdf#124341: special-case applying autoformat to whole rows It will be available in 25.2.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.
Now it should be thousands of times faster for all-sheet case, than for all-columns-except-last (which would still hang). Also, it won't help with the "Simple Grid Columns" format, where the pattern is columnar (and it would likewise fail for a checkerboard pattern). There's nothing more I can do here. It's not resolver definitively. So let me unassign myself, and keep it NEW for the other improvements, if people have good ideas.
An implementation note: this fix assumes, that when a user selects whole rows (and the whole sheet as a special case for that), then the user doesn't need the rightmost specially formatted column (which in this case would be column XFD). This would change e.g. how the "Default" format looks (see its "Total" rightmost column, which would not appear in whole-rows selection now), and for all the formats with outer border (because that border is defined as special formatting of outer cells, including rightmost column), so they would loose the right border. Hope that is a sane assumption, that shouldn't break any workflow in practice.