[Libreoffice-bugs] [Bug 133411] New: Replacing lots of cell styles consumes too much memory/CPU

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=133411

            Bug ID: 133411
           Summary: Replacing lots of cell styles consumes too much
                    memory/CPU
           Product: LibreOffice
           Version: 6.3.0.4 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: bibisected, bisected, perf, regression
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu
                CC: caolanm at redhat.com, nemeth at numbertext.org

Created attachment 161303
  --> https://bugs.documentfoundation.org/attachment.cgi?id=161303&action=edit
Example file from Excel

Attached document is containing a lot of cells (78 columns x 10000 rows)
formatted with a cell style.
Using the replace functionality to change the style causes huge CPU and memory
use.

Steps to reproduce:
    1. Open attached document
    2. Open the Find  and Replace dialog
    3. Select the Cell Styles checkbox
    4. Search for the Excel Built-in Accent2 style and Replace it with the
Default style.
    5. Push the “Replace All” button, close the Results dialog and push
“Replace All” again.

Actual results:
CPU use goes to 100% for quite a while, LO “does not respond”. Memory use grows
quickly to about 3.5GB, then the replace is successfully done. Closing the
document also takes a lot of CPU time.

Expected results:
Smooth user experience: before the bibisected change this replace happened in
~1 second.

LibreOffice details:
Version: 7.0.0.0.alpha1+ (x64)
Build ID: fd238380ae7820f12ac1f7c52d0f7180a93f3ba3
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL

Also happens in:
Verzió: 6.3.0.4 (x86)
Build az.: 057fc023c990d676a43019934386b85b21a9ee99
CPU szálak: 4; OS: Windows 6.3; Felületmegjelenítés: alapértelmezett; VCL: win; 
Területi beállítások: hu-HU (hu_HU); Felület nyelve: hu-HU
Calc: CL

But not in:
Verzió: 6.2.0.3
Build az.: 98c6a8a1c6c7b144ce3cc729e34964b47ce25d62
CPU szálak: 4; OS: Windows 6.3; Felületmegjelenítés: GL; VCL: win; 
Területi beállítások: hu-HU (hu_HU); UI nyelve: hu-HU
Calc: threaded


Bibisected using bibisect-win32-6.3 to:
URL:
https://cgit.freedesktop.org/libreoffice/core/commit/?id=f920e86fbf3968104e1dfc0e9934e80652ed0837 
author  Caolán McNamara <caolanm at redhat.com>    2019-03-22 15:59:00 +0000
committer       Caolán McNamara <caolanm at redhat.com>    2019-03-24 18:19:29
+0100

weld SvxSearchDialog

Adding CC to: Caolán McNamara

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200526/b14f9be3/attachment.htm>