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.PivotTable

  The PivotTable that contains the changes to commit

• ValueChangeStart
  Type: System.Int32

  The 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.Int32

  The 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.Boolean

  false 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.

See Also

Reference

Microsoft.Office.Interop.Excel Namespace