Build 4.5.0.5 of xlsgen is a fix pack for pivot tables in XLSX (and variants), XLSB and XLS files.

It includes the following :

- improved pivot table insertion point whenever the pivot table has at least one field in the Page area (also known as Report filters area). The insertion point refers to row headers, and page headers are above it. Inserting at row 1 would cause Excel to show an error message "There isn't enough memory to complete this action. " only because internally the row for page headers becomes negative, equivalent to a very large 32-bit number, and Excel can't allocate the corresponding memory. The error message is mostly bogus anyway, but with this fix it won't appear anymore.

- exposure of the ShowExpandControls boolean property in pivot table options : defaulting to true, this option shows or hides the [-] expand/collapse controls next to row items

- exposure of the ResizeOnUpdate boolean property in pivot table options : defaulting to true, instructs Excel to reshape and resize whenever there is a data refresh.

- exposure of the MergeItems boolean property in pivot table options : defaulting to false, instructs Excel to show row items merged wherever applicable.

- exposure of the ShowGrandTotalsForRows boolean property in pivot table options : defaulting to true, instructs Excel to show grand totals for rows.

- exposure of the ShowGrandTotalsForColumns boolean property in pivot table options : defaulting to true, instructs Excel to show grand totals for columns.