Spread Windows Forms 8.0 Product Documentation
FpSpread Class Events


For a list of all members of this type, see FpSpread members.

Public Events
 NameDescription
Public EventActiveSheetChangedOccurs when the user has changed the active sheet.  
Public EventActiveSheetChangingOccurs when the user changes the active sheet.  
Public EventActiveSpreadViewChangedOccurs when the user has changed the active SpreadView.  
Public EventActiveSpreadViewChangingOccurs when the user changes the active SpreadView.  
Public EventAdvanceOccurs when the user tries to advance from the first or last row in Spread.  
Public EventAllowUserToTouchZoomChangedOccurs when the AllowUserToZoom property has changed.  
Public EventAnnotationModeEndingOccurs when the user ends annotation mode.  
Public EventAnnotationModeStartingOccurs when the user begins annotation mode.  
Public EventAutoFilteredColumnOccurs when a column has just been automatically filtered.  
Public EventAutoFilteringColumnOccurs when a column is about to be automatically filtered.  
Public EventAutoScrollWhenKeyboardShowingChangedOccurs when the AutoScrollWhenKeyboardShowing property is changed.  
Public EventAutoSortedColumnOccurs when a column has just been automatically sorted.  
Public EventAutoSortingColumnOccurs when a column is about to be automatically sorted.  
Public EventBackColorChangedOccurs when the value of the System.Windows.Forms.Control.BackColor property changes. (Inherited from System.Windows.Forms.Control)
Public EventBackgroundImageChangedOccurs when the value of the System.Windows.Forms.Control.BackgroundImage property changes. (Inherited from System.Windows.Forms.Control)
Public EventBackgroundImageLayoutChangedOccurs when the System.Windows.Forms.Control.BackgroundImageLayout property changes. (Inherited from System.Windows.Forms.Control)
Public EventBindingContextChangedOccurs when the value of the System.Windows.Forms.BindingContext property changes. (Inherited from System.Windows.Forms.Control)
Public EventBoundaryFeedbackModeChangedOccurs when the BoundaryFeedbackMode property has changed.  
Public EventButtonClickedOccurs when the user clicks a button, check box, or hyperlink in a cell.  
Public EventCausesValidationChangedOccurs when the value of the System.Windows.Forms.Control.CausesValidation property changes. (Inherited from System.Windows.Forms.Control)
Public EventCellClickOccurs when the user presses down the left mouse button in a cell.  
Public EventCellDoubleClickOccurs when the user presses down the left mouse button twice (double-clicks) in a cell.  
Public EventCellErrorTextChangedOccurs when the cell error text has changed.  
Public EventChangeOccurs after the user modifies data in a cell.  
Public EventChangeUICuesOccurs when the focus or keyboard user interface (UI) cues change. (Inherited from System.Windows.Forms.Control)
Public EventChartIndicatorActivatedOccurs when the chart indicator is activated.  
Public EventChartIndicatorDeactivatedOccurs when the chart indicator is deactivated.  
Public EventChildControlActivatedOccurs when a child control is activated.  
Public EventChildControlDeactivatedOccurs when a child control is deactivated.  
Public EventChildViewCreatedOccurs when a child view of the Spread component is created.  
Public EventChildWorkbookCreatedOccurs when a child workbook of the Spread component is created.  
Public EventClientSizeChangedOccurs when the value of the System.Windows.Forms.Control.ClientSize property changes. (Inherited from System.Windows.Forms.Control)
Public EventClipboardChangedOccurs when a Clipboard change occurs that can affect the FarPoint Spread component.  
Public EventClipboardChangingOccurs when the Clipboard is changing through a Spread action.  
Public EventClipboardPastedOccurs when the user pastes from the clipboard.  
Public EventClipboardPastingOccurs when the user pastes from the clipboard.  
Public EventColumnDragMoveOccurs when AllowColumnMove is true and the user drags to move a column.  
Public EventColumnDragMoveCompletedOccurs when the user finishes moving a column by dragging.  
Public EventColumnViewportWidthChangedOccurs when a viewport column width has changed.  
Public EventColumnWidthChangedOccurs when the column width has changed.  
Public EventColumnWidthChangingOccurs when the column width is changing.  
Public EventComboCloseUpOccurs when the user closes a combo box in a cell.  
Public EventComboDropDownOccurs when the user drops down a combo box in a cell.  
Public EventComboSelChangeOccurs when the user changes the selection in a combo box in a cell.  
Public EventContextMenuChangedOccurs when the value of the System.Windows.Forms.Control.ContextMenu property changes. (Inherited from System.Windows.Forms.Control)
Public EventContextMenuStripChangedOccurs when the value of the System.Windows.Forms.Control.ContextMenuStrip property changes. (Inherited from System.Windows.Forms.Control)
Public EventControlAddedOccurs when a new control is added to the System.Windows.Forms.Control.ControlCollection. (Inherited from System.Windows.Forms.Control)
Public EventControlRemovedOccurs when a control is removed from the System.Windows.Forms.Control.ControlCollection. (Inherited from System.Windows.Forms.Control)
Public EventCursorChangedOccurs when the value of the System.Windows.Forms.Control.Cursor property changes. (Inherited from System.Windows.Forms.Control)
Public EventCustomNameChangedOccurs when the custom name of the data model changes.  
Public EventDataColumnConfigureOccurs when the sheet is binding a column to a data source after it has been initialized.  
Public EventDialogCharOccurs during message preprocessing of dialog characters.  
Public EventDialogKeyOccurs during message preprocessing of dialog keys.  
Public EventDisposed (Inherited from System.ComponentModel.Component)
Public EventDockChangedOccurs when the value of the System.Windows.Forms.Control.Dock property changes. (Inherited from System.Windows.Forms.Control)
Public EventDoubleClickOccurs when the control is double-clicked. (Inherited from System.Windows.Forms.Control)
Public EventDragDropOccurs when a drag-and-drop operation is completed. (Inherited from System.Windows.Forms.Control)
Public EventDragDropBlockOccurs when the user drags and drops a range of cells.  
Public EventDragDropBlockCompletedOccurs at the completion of the user dragging and dropping a range of cells.  
Public EventDragEnterOccurs when an object is dragged into the control's bounds. (Inherited from System.Windows.Forms.Control)
Public EventDragFillBlockOccurs when the user drags to fill a range of cells.  
Public EventDragFillBlockCompletedOccurs at the completion of the user dragging to fill a range of cells.  
Public EventDragLeaveOccurs when an object is dragged out of the control's bounds. (Inherited from System.Windows.Forms.Control)
Public EventDragOverOccurs when an object is dragged over the control's bounds. (Inherited from System.Windows.Forms.Control)
Public EventEditChangeOccurs when the user changes the text in a cell in edit mode.  
Public EventEditErrorOccurs when the user performs an invalid input operation.  
Public EventEditModeOffOccurs when edit mode is stopped.  
Public EventEditModeOnOccurs when edit mode is started.  
Public EventEditModeStartingOccurs when edit mode is about to start in the active sheet's active cell.  
Public EventEditorFocusedOccurs when the editing control gets focus.  
Public EventEnabledChangedOccurs when the System.Windows.Forms.Control.Enabled property value has changed. (Inherited from System.Windows.Forms.Control)
Public EventEnterOccurs when the control is entered. (Inherited from System.Windows.Forms.Control)
Public EventEnterCellOccurs when the user enters a cell.  
Public EventErrorOccurs when the user performs an invalid operation.  
Public EventExpandOccurs when a row is expanded or collapsed.  
Public EventFilterBarClickOccurs when the user presses down the left mouse button in a filter bar cell.  
Public EventFilterBarDoubleClickOccurs when the user presses down the left mouse button twice (double-clicks) in a filter bar cell.  
Public EventFilterBarDropDownSelectionChangingOccurs when the user selects a value from the drop-down list in the filter bar editor.  
Public EventFontChangedOccurs when the System.Windows.Forms.Control.Font property value changes. (Inherited from System.Windows.Forms.Control)
Public EventGiveFeedbackOccurs during a drag operation. (Inherited from System.Windows.Forms.Control)
Public EventGotFocusOccurs when the control receives focus. (Inherited from System.Windows.Forms.Control)
Public EventGroupedOccurs when the grouping is finished.  
Public EventGroupingOccurs when the user performs grouping.  
Public EventHandleCreatedOccurs when a handle is created for the control. (Inherited from System.Windows.Forms.Control)
Public EventHandleDestroyedOccurs when the control's handle is in the process of being destroyed. (Inherited from System.Windows.Forms.Control)
Public EventHeaderIndicatorPositionAdjustingChangedOccurs when the HeaderIndicatorPositionAdjusting property has changed.  
Public EventHelpRequestedOccurs when the user requests help for a control. (Inherited from System.Windows.Forms.Control)
Public EventHyperLinkClickedOccurs when the user clicks on hyper link text.  
Public EventImeModeChangedOccurs when the System.Windows.Forms.Control.ImeMode property has changed. (Inherited from System.Windows.Forms.Control)
Public EventInputScopeChangedOccurs when the InputScope property is changed.  
Public EventInvalidatedOccurs when a control's display requires redrawing. (Inherited from System.Windows.Forms.Control)
Public EventKeyDownOccurs when a key is pressed while the control has focus. (Inherited from System.Windows.Forms.Control)
Public EventKeyPressOccurs when a key is pressed while the control has focus. (Inherited from System.Windows.Forms.Control)
Public EventKeyUpOccurs when a key is released while the control has focus. (Inherited from System.Windows.Forms.Control)
Public EventLayoutOccurs when a control should reposition its child controls. (Inherited from System.Windows.Forms.Control)
Public EventLeaveOccurs when the input focus leaves the control. (Inherited from System.Windows.Forms.Control)
Public EventLeaveCellOccurs when the user leaves a cell.  
Public EventLeftChangeOccurs when the left column changes.  
Public EventLocationChangedOccurs when the System.Windows.Forms.Control.Location property value has changed. (Inherited from System.Windows.Forms.Control)
Public EventLostFocusOccurs when the control loses focus. (Inherited from System.Windows.Forms.Control)
Public EventMarginChangedOccurs when the control's margin changes. (Inherited from System.Windows.Forms.Control)
Public EventMouseCaptureChangedOccurs when the control loses mouse capture. (Inherited from System.Windows.Forms.Control)
Public EventMouseClickOccurs when the control is clicked by the mouse. (Inherited from System.Windows.Forms.Control)
Public EventMouseDoubleClickOccurs when the control is double clicked by the mouse. (Inherited from System.Windows.Forms.Control)
Public EventMouseDownOccurs when the mouse pointer is over the control and a mouse button is pressed. (Inherited from System.Windows.Forms.Control)
Public EventMouseEnterOccurs when the mouse pointer enters the control. (Inherited from System.Windows.Forms.Control)
Public EventMouseHoverOccurs when the mouse pointer rests on the control. (Inherited from System.Windows.Forms.Control)
Public EventMouseLeaveOccurs when the mouse pointer leaves the control. (Inherited from System.Windows.Forms.Control)
Public EventMouseMoveOccurs when the mouse pointer is moved over the control. (Inherited from System.Windows.Forms.Control)
Public EventMouseUpOccurs when the mouse pointer is over the control and a mouse button is released. (Inherited from System.Windows.Forms.Control)
Public EventMouseWheelOccurs when the mouse wheel moves while the control has focus. (Inherited from System.Windows.Forms.Control)
Public EventMoveOccurs when the control is moved. (Inherited from System.Windows.Forms.Control)
Public EventPaddingChangedOccurs when the control's padding changes. (Inherited from System.Windows.Forms.Control)
Public EventPaintOccurs when the control is redrawn. (Inherited from System.Windows.Forms.Control)
Public EventPaintGrayAreaOccurs when the gray area needs painting.  
Public EventPaintGroupBarBackgroundOccurs when the group bar background is painted.  
Public EventPaintTabStripOccurs when the tab strip needs painting.  
Public EventPaintTabStripButtonOccurs when a TabStrip button needs painting.  
Public EventPaintTabStripTabOccurs when a TabStrip tab needs painting.  
Public EventPanningModeChangedOccurs when the PanningMode property has changed.  
Public EventParentChangedOccurs when the System.Windows.Forms.Control.Parent property value changes. (Inherited from System.Windows.Forms.Control)
Public EventPreviewKeyDownOccurs before the System.Windows.Forms.Control.KeyDown event when a key is pressed while focus is on this control. (Inherited from System.Windows.Forms.Control)
Public EventPreviewRowFetchOccurs when the user customizes the preview row of the Spread component.  
Public EventPrintAbortOccurs continually as printing occurs in order to give the user the opportunity to discontinue a print job.  
Public EventPrintBackgroundOccurs before each page is printed.  
Public EventPrintCancelledOccurs when a print job is discontinued by the user.  
Public EventPrintDocumentOccurs when printing a sheet.  
Public EventPrintHeaderFooterAreaOccurs when the header or footer needs printing.  
Public EventPrintMessageBoxOccurs before and after a print job.  
Public EventPrintPreviewShowingOccurs before the preview dialog appears.  
Public EventQueryAccessibilityHelpOccurs when System.Windows.Forms.AccessibleObject is providing help to accessibility applications. (Inherited from System.Windows.Forms.Control)
Public EventQueryContinueDragOccurs during a drag-and-drop operation and enables the drag source to determine whether the drag-and-drop operation should be canceled. (Inherited from System.Windows.Forms.Control)
Public EventRangeGroupStateChangedOccurs when the user has changed the state of the row or column outline (range group).  
Public EventRangeGroupStateChangingOccurs before the user changes the state of row or column outlines (range group).  
Public EventRegionChangedOccurs when the value of the System.Windows.Forms.Control.Region property changes. (Inherited from System.Windows.Forms.Control)
Public EventResizeOccurs when the control is resized. (Inherited from System.Windows.Forms.Control)
Public EventResizeZeroIndicatorChangedOccurs when the ResizeZeroIndicator property has changed.  
Public EventRightToLeftChangedOccurs when the System.Windows.Forms.Control.RightToLeft property value changes. (Inherited from System.Windows.Forms.Control)
Public EventRowDragMoveOccurs when AllowRowMove is true and the user drags to move a row.  
Public EventRowDragMoveCompletedOccurs when the user finishes moving a row by dragging.  
Public EventRowErrorTextChangedOccurs when the row error text has changed.  
Public EventRowHeightChangedOccurs when the row height has changed.  
Public EventRowHeightChangingOccurs when the column width is changing.  
Public EventRowViewportHeightChangedOccurs when a viewport row height has changed.  
Public EventScrollTipFetchOccurs when the user scrolls the Spread component.  
Public EventSearchDialogClosingOccurs when the search form is closing.  
Public EventSelectionChangedOccurs when the selection of cells on the sheet has changed.  
Public EventSelectionChangingOccurs when the selection of cells on the sheet is changing.  
Public EventShapeActivatedOccurs when the user changes the active shape object.  
Public EventShapeDeactivatedOccurs when the user deactivates the active shape object.  
Public EventSheetTabClickOccurs when the user clicks the sheet tab.  
Public EventSheetTabDoubleClickOccurs when the user double-clicks the sheet tab.  
Public EventShowGrippersInEditingStatusChangedOccurs when the ShowGrippersInEditingStatus value is changed.  
Public EventSizeChangedOccurs when the System.Windows.Forms.Control.Size property value changes. (Inherited from System.Windows.Forms.Control)
Public EventStyleChangedOccurs when the control style changes. (Inherited from System.Windows.Forms.Control)
Public EventSubEditorClosedOccurs when a subeditor is closed for a cell.  
Public EventSubEditorOpeningOccurs when a subeditor is about to be displayed.  
Public EventSystemColorsChangedOccurs when the system colors change. (Inherited from System.Windows.Forms.Control)
Public EventTabIndexChangedOccurs when the System.Windows.Forms.Control.TabIndex property value changes. (Inherited from System.Windows.Forms.Control)
Public EventTableChangedOccurs when the custom name of the data model changes.  
Public EventTabStopChangedOccurs when the System.Windows.Forms.Control.TabStop property value changes. (Inherited from System.Windows.Forms.Control)
Public EventTapToAddSelectionChangedOccurs when the TapToAddSelection property is changed.  
Public EventTextChangedOccurs when the System.Windows.Forms.Control.Text property value changes. (Inherited from System.Windows.Forms.Control)
Public EventTextTipFetchOccurs when the pointer (cursor) is over a cell and the text tip or cell note should be displayed (the TextTip property is set to a value other than Off).  
Public EventTopChangeOccurs when the top row changes.  
Public EventTouchDropDownScaleChangedOccurs when the TouchDropDownScale property has changed.  
Public EventTouchSelectionGripperBackColorChangedOccurs when the TouchSelectionGripperBackColor is changed.  
Public EventTouchSelectionGripperLineColorChangedOccurs when TouchSelectionGripperLineColor is changed.  
Public EventTouchSelectionGripperThicknessChangedOccurs when the TouchSelectionGripperThickness is changed.  
Public EventTouchStripOpeningOccurs when FpSpread tries to show a FarPoint.Win.Spread.TouchStrip in a touch device.  
Public EventTouchZoomSnapDistanceChangedOccurs when the TouchZoomSnapDistance property has changed.  
Public EventUngroupedOccurs when all the grouping is removed.  
Public EventUseOptimizedSelectionForTouchChangedOccurs when the UseOptimizedSelectionForTouch is changed.  
Public EventUserFormulaEnteredOccurs when the user types a formula.  
Public EventUserZoomingOccurs when the user zooms.  
Public EventValidatedOccurs when the control is finished validating. (Inherited from System.Windows.Forms.Control)
Public EventValidatingOccurs when the control is validating. (Inherited from System.Windows.Forms.Control)
Public EventVisibleChangedOccurs when the System.Windows.Forms.Control.Visible property value changes. (Inherited from System.Windows.Forms.Control)
Top
See Also

Reference

FpSpread Class
FarPoint.Win.Spread Namespace

User-Task Documentation

Customizing the Appearance
Customizing the User Interaction

 

 


Copyright © GrapeCity, inc. All rights reserved.