DocEvents_PivotTableBeforeCommitChangesEventHandler Delegate
A Delegate type used to add an event handler for the PivotTableBeforeCommitChanges event. The PivotTableBeforeCommitChanges event occurs before changes are committed against the OLAP data source for a PivotTable.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
<ComVisibleAttribute(False)> _
Public Delegate Sub DocEvents_PivotTableBeforeCommitChangesEventHandler ( _
TargetPivotTable As PivotTable, _
ValueChangeStart As Integer, _
ValueChangeEnd As Integer, _
<OutAttribute> ByRef Cancel As Boolean _
)
'Usage
Dim instance As New DocEvents_PivotTableBeforeCommitChangesEventHandler(AddressOf HandlerMethod)
[ComVisibleAttribute(false)]
public delegate void DocEvents_PivotTableBeforeCommitChangesEventHandler(
PivotTable TargetPivotTable,
int ValueChangeStart,
int ValueChangeEnd,
out bool Cancel
)
Parameters
TargetPivotTable
Type: Microsoft.Office.Interop.Excel.PivotTableThe PivotTable that contains the changes to commit
ValueChangeStart
Type: System.Int32The index to the first change in the associated PivotTableChangeList object. The index is specified by the Order property of the ValueChange object in the PivotTableChangeList collection.
ValueChangeEnd
Type: System.Int32The index to the last change in the associated PivotTableChangeList object. The index is specified by the Order property of the ValueChange object in the PivotTableChangeList collection.
Cancel
Type: System.Booleanfalse when the event occurs. If the event procedure sets this parameter to true, the changes are not committed against the OLAP data source of the PivotTable.