Collapse the table of content
Expand the table of content
Expand Minimize
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer

AppEvents_SheetPivotTableBeforeCommitChangesEventHandler Delegate

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.

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

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

Parameters

Sh
Type: System.Object

The worksheet that contains the PivotTable.

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.

Show:
© 2016 Microsoft