DocEvents_PivotTableBeforeAllocateChangesEventHandler DocEvents_PivotTableBeforeAllocateChangesEventHandler DocEvents_PivotTableBeforeAllocateChangesEventHandler Delegate

Definition

A Delegate type used to add an event handler for the PivotTableBeforeAllocateChanges event. The PivotTableBeforeAllocateChanges event occurs before changes are applied to a PivotTable.

public delegate void DocEvents_PivotTableBeforeAllocateChangesEventHandler(PivotTable ^ TargetPivotTable, int ValueChangeStart, int ValueChangeEnd, [Runtime::InteropServices::Out] bool % Cancel);
[System.Runtime.InteropServices.ComVisible(false)]
public delegate void DocEvents_PivotTableBeforeAllocateChangesEventHandler(PivotTable TargetPivotTable, int ValueChangeStart, int ValueChangeEnd, out bool Cancel);
Public Delegate Sub DocEvents_PivotTableBeforeAllocateChangesEventHandler(TargetPivotTable As PivotTable, ValueChangeStart As Integer, ValueChangeEnd As Integer, ByRef Cancel As Boolean)
Parameters
TargetPivotTable

The PivotTable that contains the changes to apply.

ValueChangeStart

The index to the first change in the associated PivotTableChangeList collection. The index is specified by the Order property of the ValueChange object in the PivotTableChangeList collection.

ValueChangeEnd

The index to the last change in the associated PivotTableChangeList collection. The index is specified by the Order property of the ValueChange object in the PivotTableChangeList collection.

Cancel

false when the event occurs. If the event procedure sets this parameter to true, the changes are not applied to the PivotTable and all edits are lost.

Inheritance
DocEvents_PivotTableBeforeAllocateChangesEventHandlerDocEvents_PivotTableBeforeAllocateChangesEventHandlerDocEvents_PivotTableBeforeAllocateChangesEventHandler
Attributes

Applies to