<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - large spreadsheet severe performance bug while creating pivot table - changing data field function is very slow" href="https://bugs.documentfoundation.org/show_bug.cgi?id=138644#c3">Comment # 3</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - large spreadsheet severe performance bug while creating pivot table - changing data field function is very slow" href="https://bugs.documentfoundation.org/show_bug.cgi?id=138644">bug 138644</a> from <a class="email" href="mailto:joseph.ervin@oracle.com" title="Joseph Ervin <joseph.ervin@oracle.com>"> Joseph Ervin</a> <pre>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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>