AppEvents_SheetPivotTableBeforeCommitChangesEventHandler Delegate
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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 AppEvents_SheetPivotTableBeforeCommitChangesEventHandler(System::Object ^ Sh, PivotTable ^ TargetPivotTable, int ValueChangeStart, int ValueChangeEnd, [Runtime::InteropServices::Out] bool % Cancel);
[System.Runtime.InteropServices.ComVisible(false)]
public delegate void AppEvents_SheetPivotTableBeforeCommitChangesEventHandler(object Sh, PivotTable TargetPivotTable, int ValueChangeStart, int ValueChangeEnd, out bool Cancel);
Public Delegate Sub AppEvents_SheetPivotTableBeforeCommitChangesEventHandler(Sh As Object, TargetPivotTable As PivotTable, ValueChangeStart As Integer, ValueChangeEnd As Integer, ByRef Cancel As Boolean)
Parameters
- Sh
- Object
The worksheet that contains the PivotTable.
- TargetPivotTable
- PivotTable
The PivotTable that contains the changes to commit.
- ValueChangeStart
- 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
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
- 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.
- Attributes
Applies to
피드백
https://aka.ms/ContentUserFeedback
출시 예정: 2024년 내내 콘텐츠에 대한 피드백 메커니즘으로 GitHub 문제를 단계적으로 폐지하고 이를 새로운 피드백 시스템으로 바꿀 예정입니다. 자세한 내용은 다음을 참조하세요.다음에 대한 사용자 의견 제출 및 보기