Bug 96589 - Very slow XLSX Pivot Table load ...
Summary: Very slow XLSX Pivot Table load ...
Status: RESOLVED DUPLICATE of bug 96588
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.2.1 rc
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: perf
Depends on:
Blocks:
 
Reported: 2015-12-18 22:18 UTC by Michael Meeks
Modified: 2016-01-04 22:56 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Michael Meeks 2015-12-18 22:18:10 UTC 
With an XLSX pivot table - it is possible to base the data source on a range name. That range name can contain a very large range that is full of empty cells =) for example SheetFoo!$A:$Z.

Then as we fillTable on this we burn a huge amount of time iterating over ~1 million empty cells repeatedly looking up the same pointless (blank) information =)

Sadly a private example file, but no doubt reasonably easy to construct one.
Comment 1 MM 2016-01-04 22:56:01 UTC 

*** This bug has been marked as a duplicate of bug 96588 ***