[Libreoffice-bugs] [Bug 138644] New: large spreadsheet severe performance bug while creating pivot table - changing data field function is very slow

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 138644
           Summary: large spreadsheet severe performance bug while
                    creating pivot table - changing data field function is
                    very slow
           Product: LibreOffice
           Version: 6.4.7.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: joseph.ervin at oracle.com

Description:
In a large spreadsheet (10MB) with > 100K rows while creating a pivot table,
and double clicking on an element in the "data field" to change the "data field
function", say from "sum" to "count", there is a long delay that is dependent
on the size of the selected data.  This was not the case in versions from 6
months or a year ago (not sure where it broke).

In my case, double-clicking on the data field eats 100% of my CPU for >5
minutes just to bring up the menu so I can change from "sum" to "count". 

I frequently use libreoffice in my job to create pivot tables of a large
spreadsheet with over 100,000 rows.  It's been great until recently.  The last
time I did it was in July 2020 and have updated libreoffice since then, and
just became aware of the problem. 

Steps to Reproduce:
1.select all rows of a large spreadsheet
2.select Insert->Pivot Table, leave "current selection" selected and click OK
3.drag an available field into the Data Fields area - it comes in with the Sum
function by default.
4. Double-click the just dragged field in the data fields area to change from
Sum, say to Count.  Notice the long delay for the dialog to pop up.  That's the
bug.  It gets longer and longer as the spreadsheet grows. 

Actual Results:
Dialog box to change data field function selection takes a long amount of time
to come up, dependent on the spreadsheet size.  The delay in my working
spreadsheets is *minutes*.

Expected Results:
The dialog box should pop right up with no delay.  


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.4.7.2
Build ID: 6.4.7.2-3.fc32
CPU threads: 4; OS: Linux 5.6; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded

-- 
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/20201203/cc83b5a2/attachment.htm>