Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

The answer lies in the fact that Calc loads virtually all of the data into internal memory. As you might appreciate, 100K rows * 27 columns is potentially a huge data array, one that the data structure created by the pivot table code can not process (or only very slowly).