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

            Bug ID: 96588
           Summary: Very slow XLSX Pivot Table load ...
           Product: LibreOffice
           Version: 5.0.2.1 rc
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to