WorkbookEvents_SheetPivotTableBeforeCommitChangesEventHandler WorkbookEvents_SheetPivotTableBeforeCommitChangesEventHandler WorkbookEvents_SheetPivotTableBeforeCommitChangesEventHandler Delegate

Definition

A Delegate type used to add an event handler for the SheetPivotTableBeforeCommitChanges event. The SheetPivotTableBeforeCommitChanges event occurs before changes are committed against the OLAP data source for a PivotTable.

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

Parameters

Sh
Object Object Object

The worksheet that contains the PivotTable.

TargetPivotTable
PivotTable PivotTable PivotTable

The PivotTable that contains the changes to commit.

ValueChangeStart
Int32 Int32 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
Int32 Int32 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

false when the event occurs. If the event procedure sets this argument to true, the changes are not committed against the OLAP data source of the PivotTable.

Inheritance
WorkbookEvents_SheetPivotTableBeforeCommitChangesEventHandlerWorkbookEvents_SheetPivotTableBeforeCommitChangesEventHandlerWorkbookEvents_SheetPivotTableBeforeCommitChangesEventHandler
Attributes

Applies to