Build 4.5.0.78 xlsgen follows previous build (4.5.0.77) related to pivot table UI settings in Excel.
This build writes back the UI settings listed below, including existing pivot tables, i.e. pivot tables that were not created using xlsgen.
Also the automatic source code generator now generates the corresponding source code for those.
Pivot table UI settings (in Excel) :
- EnablePivotTableUI (yes/no) : when set to no, the entire user interface for manipulating pivot tables is hidden
- ShowDetails (yes/no) : when set to no, non-aggregate values do not appear
- EnableFieldListUI (yes/no) : when set to no, the field list view is hidden
- EnableFieldPropertiesUI (yes/no) : when set to no, field properties dialog does not appear (looks like a bug for the end user because Excel does not gray out the menu)
- ShowFieldHeaders (yes/no) : when set to no, hides field elements
And also, in pivot table data source options,
- RefreshEnabled (yes/no)