Build 4.5.0.77 of xlsgen adds a number of user interface properties to the object model, for pivot tables. Those properties affect the experience of viewing or working with pivot tables in Excel.
They are :
in pivot table
options- 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) : when set to no, makes it impossible for the user to refresh the data source associated to the pivot table