[Libreoffice-bugs] [Bug 138644] 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

--- Comment #3 from Joseph Ervin <joseph.ervin at oracle.com> ---
Yeah, the dummy spreadsheet I made seems simple enough, with a lot of the same
data elements used over and over, that the really horrendous delays don't show
up.  That sheet only gives me a delay of a few seconds as you've seen. The real
spreadsheet I'm working with has a lot of columns with tons of unique data, and
several sheets with 50K, 50K, 50K, and 170K rows.  I'm trying to do the pivot
table on the big 170K row sheet, and it ties up my linux box for many minutes.

Prior versions of libreoffice (I don't know exactly where it started) didn't
have this behavior at all, so something has changed that introduced some type
of global spreadsheet operation that happens when trying to bring up that
dialog to change the data function.

Since it creates the appearance of a hard hang (100% CPU for several minutes),
I consider this to be a somewhat serious usability issue. 

There are workarounds, such as creating the pivot table over a trivial number
of rows, and then editing its properties to add in the full range.

-- 
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/20201204/13f107db/attachment.htm>