Expand Minimize

DocEvents_PivotTableBeforeAllocateChangesEventHandler Delegate

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

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

[ComVisibleAttribute(false)]
public delegate void DocEvents_PivotTableBeforeAllocateChangesEventHandler(
	PivotTable TargetPivotTable,
	int ValueChangeStart,
	int ValueChangeEnd,
	out bool Cancel
)

Parameters

TargetPivotTable
Type: Microsoft.Office.Interop.Excel.PivotTable
The PivotTable that contains the changes to apply.
ValueChangeStart
Type: System.Int32
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
Type: System.Int32
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
Type: System.Boolean
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.

Community Additions

ADD
Show:
© 2014 Microsoft