https://bugs.documentfoundation.org/show_bug.cgi?id=149526
Bug ID: 149526
Summary: Calc Pivot Table where the range includes many empty
rows takes 30 minutes and 9GB of Ram before crashing
Product: LibreOffice
Version: 7.2.7.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
I'm no expert but having failed four times with LO I tried Excel and the result
was impeccable - leads me to believe it's a LO bug.
I have a sheet with 2500 rows and perhaps 20 columns - only 8 of the columns
are in the Pivot Table array
Some of the cells are VLOOKUP() results, some are "same row" calculations
All columns are autofiltered.
993 rows are populated and the remaining empty rows contain formulae checking
for "source" cells. Empty source cells will generate "forced null" results
where appropriate.
If I define the pivot table array as including the 1507 empty rows then LO
meanders its way through 9 of 12gB of memory and I suspect the crash (which
occurs around 30 minutes after initiation) coincides with the requirement to
use a paging file - I'm not sure if this is "memory leakage" I read about in
bug100244.
All other open processes become unstable and the only remedy is to kill them
through Task Manager. Sometimes it works, other times I have to reboot the PC.
The "unstable" processes will often still require activating and closing down -
following the restart - before they stabilise.
If I define the pivot table array exclusively as the populated rows then I get
a pivot table within a few moments.
As I mentioned, Excel has no problem with the empty rows which satisfied me
that it's not just my inexperience with pivot tables.
I imagine you have more than your fair share of sample sheets accompanying all
the reports in hand, if you need me to submit mine then I can easily anonymise
the data.
Version: 7.2.7.2 (x64) / LibreOffice Community
Build ID: 8d71d29d553c0f7dcbfa38fbfda25ee34cce99a2
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: sv-SE (en_GB); UI: en-GB
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
