method Pivot.Reset ([IncludeMask as Variant], [ExcludeMask as Variant])
Resets the control's layouts, so no filtering, sorting, ... is applied to the view.

TypeDescription
IncludeMask as Variant A String expression that specifies the mask of properties to be reset.

The mask can include the following special characters:

  • *, indicates any combination of characters
  • ?, specifies any single character 
  • #, any digit character
  • space, specifies the separators of multiple patterns.
ExcludeMask as Variant A String expression that specifies the mask of properties to be keep.

The mask can include the following special characters:

  • *, indicates any combination of characters
  • ?, specifies any single character 
  • #, any digit character
  • space, specifies the separators of multiple patterns.
The Reset method resets the control's layout. The Layout property of the control includes information about sorting, filtering, sizing or positions of the columns ( data columns ). The pivot columns are displayed in the control's pivot bar, while the data columns are displayed on the control's data view. The LayoutStartChanging / LayoutEndChanging events notify your application when user performs operations in the control's pivot bar, for instance, sorts a pivot column.

For instance, the following VB sample resets the position properties when user changes the filter of a pivot column:

Private Sub Pivot1_LayoutEndChanging(ByVal Operation As EXPIVOTLibCtl.LayoutChangingEnum)
	If Operation = exPivotDataColumnFilterChange Then
		Pivot1.Reset "c*.position*"
	End If
End Sub

When user changes the pivot columns, like adding new pivot columns, the control keeps the layout of the data view, so the position, size of data columns is keep. The same thing is happen for sorting, filtering and so on.