Type | Description | |||
Operation as LayoutChangingEnum | A LayoutChangingEnum expression that indicates the operation that ends. |
These events notify your application if any of the following operations occur:
private void LayoutEndChanging(object sender,exontrol.EXPIVOTLib.LayoutChangingEnum Operation) { } Private Sub LayoutEndChanging(ByVal sender As System.Object,ByVal Operation As exontrol.EXPIVOTLib.LayoutChangingEnum) Handles LayoutEndChanging End Sub |
private void LayoutEndChanging(object sender, AxEXPIVOTLib._IPivotEvents_LayoutEndChangingEvent e) { } void OnLayoutEndChanging(long Operation) { } void __fastcall LayoutEndChanging(TObject *Sender,Expivotlib_tlb::LayoutChangingEnum Operation) { } procedure LayoutEndChanging(ASender: TObject; Operation : LayoutChangingEnum); begin end; procedure LayoutEndChanging(sender: System.Object; e: AxEXPIVOTLib._IPivotEvents_LayoutEndChangingEvent); begin end; begin event LayoutEndChanging(long Operation) end event LayoutEndChanging Private Sub LayoutEndChanging(ByVal sender As System.Object, ByVal e As AxEXPIVOTLib._IPivotEvents_LayoutEndChangingEvent) Handles LayoutEndChanging End Sub Private Sub LayoutEndChanging(ByVal Operation As EXPIVOTLibCtl.LayoutChangingEnum) End Sub Private Sub LayoutEndChanging(ByVal Operation As Long) End Sub LPARAMETERS Operation PROCEDURE OnLayoutEndChanging(oPivot,Operation) RETURN |
<SCRIPT EVENT="LayoutEndChanging(Operation)" LANGUAGE="JScript"> </SCRIPT> <SCRIPT LANGUAGE="VBScript"> Function LayoutEndChanging(Operation) End Function </SCRIPT> Procedure OnComLayoutEndChanging OLELayoutChangingEnum llOperation Forward Send OnComLayoutEndChanging llOperation End_Procedure METHOD OCX_LayoutEndChanging(Operation) CLASS MainDialog RETURN NIL void onEvent_LayoutEndChanging(int _Operation) { } function LayoutEndChanging as v (Operation as OLE::Exontrol.Pivot.1::LayoutChangingEnum) end function function nativeObject_LayoutEndChanging(Operation) return |
For instance, you can use the LayoutStartChaging/LayoutEndChaging event to notify your application once the user drag and drop columns/aggregate functions to the control's pivot bar. By default, the control is keeping the layout (size, position, sorting order, ... ) of the generated columns when the user makes changes in the control's pivot bar. In other words, if you include a new value in the column's filter, the new generated columns will be appended at the end of the header list. In order to prevent this, you need to handle the LayoutEndChanging event when exPivotDataColumnSort and exPivotDataColumnFilterChange notifications occur, and call the control's Reset method as in the following sample:
Private Sub Pivot1_LayoutEndChanging(ByVal Operation As EXPIVOTLibCtl.LayoutChangingEnum) If (Operation = exPivotDataColumnSort) Or (Operation = exPivotDataColumnFilterChange) Then Pivot1.Reset "c*.position*" End If End Sub
The sample resets the position of the generated columns when exPivotDataColumnSort and exPivotDataColumnFilterChange notifications occur.