FarPoint.Win.Spread
FpSpread Class Members
See Also Properties Methods Events

	Name	Description
	About	Gets the version information about the component.
	AccessibilityObject	(Inherited from System.Windows.Forms.Control)
	AccessibleDefaultActionDescription	(Inherited from System.Windows.Forms.Control)
	AccessibleDescription	(Inherited from System.Windows.Forms.Control)
	AccessibleName	(Inherited from System.Windows.Forms.Control)
	AccessibleRole	(Inherited from System.Windows.Forms.Control)
	ActiveChartIndicator	Gets the active chart indicator.
	ActiveChildControl	Gets or sets the active embedded child control object of the sheet.
	ActiveSheet	Gets or sets the active sheet in the component.
	ActiveSheetIndex	Gets or sets the index of the active sheet in the component.
	AllowCellOverflow	Gets or sets whether data can overflow into adjacent empty cells in the component.
	AllowChildControlDesign	Gets or sets whether child controls allow user actions for design.
	AllowColumnMove	Gets or sets whether to allow the user to move columns.
	AllowColumnMoveMultiple	Gets or sets whether to allow the user to move multiple columns.
	AllowDragDrop	Gets or sets whether to allow the user to drag-and-drop a range of cells in the component.
	AllowDragFill	Gets or sets whether to allow the user to drag and fill cells in the component with the contents of a cell or cells.
	AllowDrop	(Inherited from System.Windows.Forms.Control)
	AllowEditorReservedLocations
	AllowEditOverflow	Gets or sets whether data can overflow into adjacent empty cells in the component while that cell is in edit mode.
	AllowRowMove	Gets or sets whether to allow the user to move rows.
	AllowRowMoveDataAllowAddNew	Gets or sets a value that indicates whether to allow the user to move the add new row or asterisk row.
	AllowRowMoveMultiple	Gets or sets whether to allow the user to move multiple rows.
	AllowSheetMove	Gets or sets whether sheets can be moved by drag-dropping the sheet tab.
	AllowUndo	Gets or sets whether to allow the user to undo edit operations.
	AllowUserFormulas	Gets or sets whether to allow the user to enter formulas in a cell in the component.
	AllowUserZoom	Gets or sets whether the user can scale the display of the component using the Ctrl key and the mouse wheel.
	Anchor	(Inherited from System.Windows.Forms.Control)
	AutoClipboard	Gets or sets whether the component handles the shortcut keys for Clipboard actions.
	AutoLaunchSpreadDesigner	Gets or sets whether Spread Designer automatically launches when a Spread component is placed on a form.
	AutoScrollOffset	(Inherited from System.Windows.Forms.Control)
	BackColor	(Inherited from System.Windows.Forms.Control)
	BackgroundImage	Overridden. Gets or sets the image to paint in the background of the component.
	BackgroundImageLayout	(Inherited from System.Windows.Forms.Control)
	BindingContext	(Inherited from System.Windows.Forms.Control)
	BorderCollapse	Gets or sets whether adjacent cell borders are collapsed into a single line for cells in the component.
	BorderStyle	Gets or sets the style of the border around the component.
	Bottom	(Inherited from System.Windows.Forms.Control)
	Bounds	(Inherited from System.Windows.Forms.Control)
	ButtonDrawMode	Gets or sets whether to display buttons in button and combo box cells in the component.
	CanFocus	(Inherited from System.Windows.Forms.Control)
	CanSelect	(Inherited from System.Windows.Forms.Control)
	Capture	(Inherited from System.Windows.Forms.Control)
	CausesValidation	(Inherited from System.Windows.Forms.Control)
	CellNoteIndicatorRenderer	Gets or sets the cell note indicator renderer for drawing the cell note indicator in the component.
	CellNoteIndicatorVisible	Gets or sets whether the cell note indicator appears in cells in the component.
	ClientRectangle	(Inherited from System.Windows.Forms.Control)
	ClientSize	(Inherited from System.Windows.Forms.Control)
	ClipboardOptions	Gets or sets whether headers are included when data is copied to or pasted from the Clipboard in the component.
	ClipboardPasteToFill	Gets or sets whether a single cell copied to the Clipboard fills the range when pasted from the Clipboard to the component.
	ColumnSplitBoxAlignment	Gets or sets the alignment of the column split box relative to the horizontal scroll bar for this component.
	ColumnSplitBoxPolicy	Gets or sets the display policy for the column split box for this component.
	CompanyName	(Inherited from System.Windows.Forms.Control)
	Container	(Inherited from System.ComponentModel.Component)
	ContainsFocus	(Inherited from System.Windows.Forms.Control)
	ContextMenu	(Inherited from System.Windows.Forms.Control)
	ContextMenuStrip	(Inherited from System.Windows.Forms.Control)
	Controls	(Inherited from System.Windows.Forms.Control)
	Created	(Inherited from System.Windows.Forms.Control)
	Cursor	Overridden. Gets or sets the pointer to display in this component.
	DataBindings	(Inherited from System.Windows.Forms.Control)
	DataMember	Gets or sets the name of the data member that populates the active sheet in this component.
	DataSource	Gets or sets the name of the data source that populates the active sheet in this component.
	DisplayRectangle	(Inherited from System.Windows.Forms.Control)
	Disposing	(Inherited from System.Windows.Forms.Control)
	Dock	(Inherited from System.Windows.Forms.Control)
	EditingControl	Gets the Control object editing the active cell, or null if the component is not in edit mode.
	EditMode	Gets or sets whether the active cell in the component is in edit mode.
	EditModePermanent	Gets or sets whether edit mode remains on for any cell in the component when that cell becomes active.
	EditModeReplace	Gets or sets whether the existing contents of a cell in the component are selected when that cell enters edit mode.
	EnableCrossSheetReference	Enables cross-sheet referencing for this component.
	Enabled	(Inherited from System.Windows.Forms.Control)
	Focused	(Inherited from System.Windows.Forms.Control)
	FocusRenderer	Gets or sets the focus indicator renderer for drawing the focus rectangle in the component.
	Font	Overridden. Gets or sets the default Font for sheets in the component.
	Handle	(Inherited from System.Windows.Forms.Control)
	HasChildren	(Inherited from System.Windows.Forms.Control)
	Height	(Inherited from System.Windows.Forms.Control)
	HorizontalScrollBar	Gets horizontal scroll bar.
	HorizontalScrollBarHeight	Gets or sets the height of horizontal scroll bars in this component.
	HorizontalScrollBarPolicy	Gets or sets when to display the horizontal scroll bars in this component.
	HorizontalScrollBarSmallChange	Gets or sets the small increment for the horizontal scrollbar.
	ImeMode	(Inherited from System.Windows.Forms.Control)
	InterfaceRenderer	Gets or sets the tab strip renderer for drawing tab strip elements.
	InvokeRequired	(Inherited from System.Windows.Forms.Control)
	IsAccessible	(Inherited from System.Windows.Forms.Control)
	IsDisposed	(Inherited from System.Windows.Forms.Control)
	IsHandleCreated	(Inherited from System.Windows.Forms.Control)
	IsLayoutSuspended	Returns whether the layout is suspended in this component.
	IsMirrored	(Inherited from System.Windows.Forms.Control)
	LayoutEngine	(Inherited from System.Windows.Forms.Control)
	Left	(Inherited from System.Windows.Forms.Control)
	LeftTab	Gets or sets the leftmost sheet tab of the component.
	Location	(Inherited from System.Windows.Forms.Control)
	Margin	(Inherited from System.Windows.Forms.Control)
	MaximumSize	(Inherited from System.Windows.Forms.Control)
	MinimumSize	(Inherited from System.Windows.Forms.Control)
	MoveActiveOnFocus	Gets or sets whether the location of the active cell moves when the user moves the focus to the view using the mouse.
	Name	Gets or sets the name of the Spread component.
	NamedStyles	Gets or sets a pre-defined style (NamedStyleCollection object).
	Padding	(Inherited from System.Windows.Forms.Control)
	Parent	(Inherited from System.Windows.Forms.Control)
	PreferredSize	(Inherited from System.Windows.Forms.Control)
	ProductName	(Inherited from System.Windows.Forms.Control)
	ProductVersion	(Inherited from System.Windows.Forms.Control)
	RecreatingHandle	(Inherited from System.Windows.Forms.Control)
	Region	(Inherited from System.Windows.Forms.Control)
	RetainSelectionBlock	Gets or sets whether the selected range of cells remains highlighted when the component loses the focus.
	Right	(Inherited from System.Windows.Forms.Control)
	RightToLeft	(Inherited from System.Windows.Forms.Control)
	RowSplitBoxAlignment	Gets or sets the alignment of the row split box relative to the vertical scroll bar for this component.
	RowSplitBoxPolicy	Gets or sets the display policy of the row split box in this component.
	ScrollBarMaxAlign	Gets or sets whether the scroll bar aligns with the last row and column of the active sheet in the component.
	ScrollBarShowMax	Gets or sets whether the displayed scroll bars are based on the entire number of columns and rows in the sheet.
	ScrollBarTrackPolicy	Gets or sets whether the sheet in the component scrolls when the user moves the scroll box.
	ScrollTipPolicy	Gets or sets whether scroll tips appear when the user moves the scroll box in the component.
	SearchDialog	Gets the dialog associated with searching for text in a cell of a sheet in this component.
	SelectionBlockOptions	Gets or sets which type of selections in the component the user can make.
	SelectionRenderer	Gets or sets the selection renderer for drawing selections in the component.
	Sheets	Gets the sheets (SheetView objects) in the component.
	Site	(Inherited from System.Windows.Forms.Control)
	Size	(Inherited from System.Windows.Forms.Control)
	Skin	Gets or sets the skin for the spread.
	SuspendAnimations	Gets or sets whether to suspend animations such as an animated focus renderer.
	TabIndex	(Inherited from System.Windows.Forms.Control)
	TabStop	(Inherited from System.Windows.Forms.Control)
	TabStrip	Gets the object representing the tab strip for this component.
	TabStripInsertTab	Gets or sets whether a special tab is displayed to allow inserting new sheets.
	TabStripInsertTabImage	Gets or sets the tabstrip insert-tab image.
	TabStripPlacement	Gets or sets the location of the tab strip.
	TabStripPolicy	Gets or sets the display policy for the sheet tab strip for this component.
	TabStripRatio	Gets or sets the width of the tab strip for this component expressed as a percentage of the overall horizontal scroll bar width.
	Tag	Gets or sets extra data for the application for this component.
	TextTipAppearance	Gets or sets the appearance of text tips in the view.
	TextTipDelay	Gets or sets the time (in milliseconds) the component waits before displaying the text tip for the cell or header under the pointer.
	TextTipPolicy	Gets or sets whether to display text tips and cell notes and the location of the tips and notes in this component.
	TitleInfo	Gets or sets the collection of title information objects for the Spread
	Top	(Inherited from System.Windows.Forms.Control)
	TopLevelControl	(Inherited from System.Windows.Forms.Control)
	UndoManager	Gets or sets the undo manager for this Spread component.
	UseWaitCursor	(Inherited from System.Windows.Forms.Control)
	VerticalScrollBar	Gets vertical scroll bar.
	VerticalScrollBarPolicy	Gets or sets when to display the vertical scroll bars in this component.
	VerticalScrollBarSmallChange	Gets or sets the small increment for the horizontal scrollbar.
	VerticalScrollBarWidth	Gets or sets the width of vertical scroll bars in this component.
	Visible	(Inherited from System.Windows.Forms.Control)
	VisualStyles	Gets or sets whether to use visual styles when rendering objects in the component.
	Width	(Inherited from System.Windows.Forms.Control)
	ZoomFactor	Gets or sets the scaling factor of the display of the active sheet in this component.

	Name	Description
	CanEnableIme	(Inherited from System.Windows.Forms.Control)
	CanRaiseEvents	(Inherited from System.Windows.Forms.Control)
	DefaultCursor	(Inherited from System.Windows.Forms.Control)
	DefaultImeMode	(Inherited from System.Windows.Forms.Control)
	DefaultMargin	(Inherited from System.Windows.Forms.Control)
	DefaultMaximumSize	(Inherited from System.Windows.Forms.Control)
	DefaultMinimumSize	(Inherited from System.Windows.Forms.Control)
	DefaultPadding	(Inherited from System.Windows.Forms.Control)
	DefaultSize	Overridden. Gets the default size of the component.
	DesignMode	Gets a value that indicates whether the Component is currently in design mode.
	DoubleBuffered	(Inherited from System.Windows.Forms.Control)
	Events	(Inherited from System.ComponentModel.Component)
	FontHeight	(Inherited from System.Windows.Forms.Control)
	ImeModeBase	(Inherited from System.Windows.Forms.Control)
	ResizeRedraw	(Inherited from System.Windows.Forms.Control)
	ShowFocusCues	(Inherited from System.Windows.Forms.Control)
	ShowKeyboardCues	(Inherited from System.Windows.Forms.Control)

	Name	Description
	AddControl	Overloaded. Adds a child control to the specified sheet at the specified location.
	AddViewport	Overloaded. Adds a row or column of viewports.
	BeginInvoke	Overloaded. (Inherited from System.Windows.Forms.Control)
	BringToFront	(Inherited from System.Windows.Forms.Control)
	CancelAnnotationMode	Cancels annotation mode.
	CancelCellEditing	Cancels cell editing.
	Contains	(Inherited from System.Windows.Forms.Control)
	CreateControl	(Inherited from System.Windows.Forms.Control)
	CreateGraphics	(Inherited from System.Windows.Forms.Control)
	DrawToBitmap	(Inherited from System.Windows.Forms.Control)
	EndInvoke	(Inherited from System.Windows.Forms.Control)
	FindForm	(Inherited from System.Windows.Forms.Control)
	Focus	(Inherited from System.Windows.Forms.Control)
	GetActionMap	Gets the action map, that maps action identifiers (for keystrokes) to particular actions.
	GetActiveColumnViewportIndex	Overloaded. Gets the index of the active viewport column.
	GetActiveRowViewportIndex	Overloaded. Gets the index of the active viewport row.
	GetCellFromPixel	Gets the row and column indexes of the cell at the specified pointer location.
	GetCellRectangle	Gets the rectangle of the cell.
	GetChildAtPoint	Overloaded. (Inherited from System.Windows.Forms.Control)
	GetColumnHeaderRectangle	Gets the rectangle of the column header.
	GetColumnPageBreaks	Overloaded. Gets the column page breaks for the specified sheet.
	GetColumnRangeGroupHeight	Gets the height of the Column RangeGroup.
	GetColumnSplitBarRectangle	Gets the rectangle of the column split bar.
	GetColumnSplitBoxRectangle	Gets the rectangle of the column split box.
	GetColumnViewportCount	Overloaded. Gets the number of viewport columns in a sheet.
	GetColumnViewportIndexFromX	Gets the index of the viewport column for the specified coordinate for the active sheet.
	GetContainerControl	(Inherited from System.Windows.Forms.Control)
	GetCursor	Gets the pointer displayed over different areas of the component.
	GetExcelSheetNames	Overloaded. Gets an array of sheet names from the specified Excel-compatible file or stream
	GetHorizontalScrollBarRectangle	Gets the rectangle of the horizontal scroll bar.
	GetInputMap	Overloaded. Gets the input map defined for the specified focus mode.
	GetInputMapWhenChildHasFocus	Gets the input map when a child control has keyboard focus.
	GetInputMapWhenShapeHasFocus	Gets the input map when a shape has keyboard focus.
	GetMaximumCellOverflowWidth	Gets the maximum cell overflow width in pixels.
	GetOwnerPrintColumnPageBreaks	Gets the column page breaks for the specified sheet under the current printing conditions.
	GetOwnerPrintPageCount	Gets the number of pages required to print a given sheet into the supplied rectangle.
	GetOwnerPrintRowPageBreaks	Gets the row page breaks for the specified sheet under the current printing conditions.
	GetPreferredSize	(Inherited from System.Windows.Forms.Control)
	GetPrintPageCount	Gets the number of pages required to print the specified sheet.
	GetPrintPreview	Gets the print preview dialog.
	GetRootWorkbook	Gets the main workbook associated with the Spread component.
	GetRowHeaderRectangle	Gets the rectangle of the row header.
	GetRowPageBreaks	Overloaded. Gets the row page breaks for the specified sheet.
	GetRowRangeGroupWidth	Gets the width of the Row RangeGroup.
	GetRowSplitBarRectangle	Gets the rectangle of the row split bar.
	GetRowSplitBoxRectangle	Gets the rectangle of the row split box.
	GetRowViewportCount	Overloaded. Gets the number of viewport rows.
	GetRowViewportIndexFromY	Gets the index of the viewport row for the specified coordinate for the active sheet.
	GetSheetFromTag	Gets a sheet with a specific tag.
	GetSheetTabRectangle	Gets the rectangle of the tab associated with a sheet.
	GetTabSplitBoxRectangle	Gets the rectangle of the split box on the tab strip.
	GetTabStripRectangle	Gets the rectangle of the tab strip.
	GetVerticalScrollBarRectangle	Gets the rectangle of the vertical scroll bar.
	GetViewportBottomRow	Overloaded. Gets the index of the bottom row of cells of the viewport row.
	GetViewportLeftColumn	Overloaded. Gets the index of the leftmost column of cells of the viewport column.
	GetViewportPreferredHeight	Overloaded. Gets the maximum height of the viewport row.
	GetViewportPreferredWidth	Overloaded. Gets the maximum width of the viewport column.
	GetViewportRectangle	Gets the rectangle of the viewport.
	GetViewportRightColumn	Overloaded. Gets the index of the rightmost column of cells of the viewport column.
	GetViewportTopRow	Overloaded. Gets the index of the top row of cells of the viewport row.
	GoalSeek	Attempts to find the value for one cell that produces the desired formula result in another cell.
	Hide	(Inherited from System.Windows.Forms.Control)
	HitTest	Performs a hit test.
	Invalidate	Overloaded. (Inherited from System.Windows.Forms.Control)
	Invoke	Overloaded. (Inherited from System.Windows.Forms.Control)
	IsCellInView	Returns whether the cell at the specified location is visible in the specified view.
	IsExcelFile	Overloaded. Opens the data and determines whether it meets the minimal requirements to be considered an Excel file.
	IsExcelStream	Overloaded. Opens the data and determines whether it meets the minimal requirements to be considered an Excel-compatible stream.
	IsSpreadSSFile	Opens the specified file and determines whether it meets the minimal requirements to be considered a Spread SS file.
	IsSpreadXmlFile	Opens the specified file and determines whether it meets the minimal requirements to be considered a Spread XML file.
	LoadFormulas	Loads formulas that are deserialized but not parsed yet, to be used after all sheets have been created and deserialized.
	OnClipboardChanging	Raises the ClipboardChanging event.
	Open	Overloaded. Opens a stream or file and loads it into Spread.
	OpenExcel	Overloaded. Opens Excel-formatted (BIFF8) content and loads it into the Spread component.
	OpenSpreadFile	Opens a saved Spread file.
	OwnerPrintDraw	Prints the specified page of the specified sheet to a specified graphics interface with the specified size.
	PerformLayout	Overloaded. Forces the Spread component to apply layout logic to its child controls.
	PointToClient	(Inherited from System.Windows.Forms.Control)
	PointToScreen	(Inherited from System.Windows.Forms.Control)
	PreProcessControlMessage	(Inherited from System.Windows.Forms.Control)
	PrintSheet	Overloaded. Prints the specified sheet.
	RectangleToClient	(Inherited from System.Windows.Forms.Control)
	RectangleToScreen	(Inherited from System.Windows.Forms.Control)
	Refresh	(Inherited from System.Windows.Forms.Control)
	RemoveControl	Removes a child control from the specified sheet.
	RemoveViewport	Overloaded. Removes a row or column of viewports
	Reset	Resets the component to its original state.
	ResetCellNoteIndicatorRenderer	Resets the focus renderer to its original state.
	ResetFocusRenderer	Resets the focus renderer to its original state.
	ResetText	(Inherited from System.Windows.Forms.Control)
	ResumeLayout	Overloaded. Resumes normal layout logic.
	Save	Overloaded. Saves the contents of the Spread component to the specified stream or file in Spread XML format.
	SaveExcel	Overloaded. Saves the contents of the Spread component to Excel format (BIFF8).
	Search	Overloaded. Searches the text in the cells of a sheet in the Spread component for the specified string.
	SearchHeaders	Overloaded. Searches the text in the header cells in the Spread component for the specified string.
	SearchWithDialog	Overloaded. Searches the text in the cells of the Spread component for the search string with input from a dialog.
	SearchWithDialogAdvanced	Overloaded. Searches the text in the cells of the Spread component for the search string with input from a dialog with additional options.
	SelectNextControl	(Inherited from System.Windows.Forms.Control)
	SendToBack	(Inherited from System.Windows.Forms.Control)
	SetActionMap	Sets the action map, that maps action identifiers (for keystrokes) to particular actions.
	SetActiveViewport	Overloaded. Sets the active viewport.
	SetBounds	Overloaded. (Inherited from System.Windows.Forms.Control)
	SetCursor	Sets the pointer displayed over different areas of the component.
	SetInputMap	Overloaded. Sets the input map for the specified condition.
	SetInputMapWhenChildHasFocus	Sets the input map when a child control has keyboard focus.
	SetInputMapWhenShapeHasFocus	Sets the input map when a shape has keyboard focus.
	SetInsertSheetImage	Sets the custom image displayed on the insert sheet tab.
	SetMaximumCellOverflowWidth	Sets the maximum cell overflow width in pixels.
	SetPrintInfo	Sets the PrintInfo object for the specfied sheet.
	SetPrintPreview	Sets the print preview dialog.
	SetViewportLeftColumn	Overloaded. Sets the index of the leftmost column of cells of the viewport column.
	SetViewportPreferredHeight	Overloaded. Sets the maximum height of the viewport row.
	SetViewportPreferredWidth	Overloaded. Sets the maximum width of the viewport column.
	SetViewportTopRow	Overloaded. Sets the index of the top row of cells of the viewport.
	Show	(Inherited from System.Windows.Forms.Control)
	ShowActiveCell	Moves the active cell to the specified position in the component.
	ShowCell	Moves the specified cell in the specified viewport to the specified position in the component.
	ShowCollectionEditor	Shows the collection editor.
	ShowColumn	Moves a column of cells in the specified viewport to the specified position in the component.
	ShowDependents	Shows the dependents.
	ShowPageSetup	Overloaded. Displays the page setup dialog with the specified buttons for the specified sheet(s).
	ShowPrecedents	Shows the precedents.
	ShowRow	Moves a row in the specified viewport to the specified position in the component.
	StartAnnotationMode	Overloaded. Starts the mode that allows users to draw free-hand on the shapes layer.
	StartCellEditing	Starts cell editing.
	StartInkNotation	Overloaded. Starts ink notation in the active viewport.
	StopAnnotationMode	Stops annotation mode.
	StopCellEditing	Stops cell editing.
	SuspendLayout	Temporarily suspends the layout logic for this component.
	ToString	(Inherited from System.ComponentModel.Component)
	Update	(Inherited from System.Windows.Forms.Control)

	Name	Description
	AccessibilityNotifyClients	Overloaded. (Inherited from System.Windows.Forms.Control)
	CreateAccessibilityInstance	(Inherited from System.Windows.Forms.Control)
	CreateControlsInstance	(Inherited from System.Windows.Forms.Control)
	CreateHandle	(Inherited from System.Windows.Forms.Control)
	DestroyHandle	(Inherited from System.Windows.Forms.Control)
	Finalize	Overridden. The destructor method
	GetAccessibilityObjectById	(Inherited from System.Windows.Forms.Control)
	GetAutoSizeMode	(Inherited from System.Windows.Forms.Control)
	GetScaledBounds	(Inherited from System.Windows.Forms.Control)
	GetService	(Inherited from System.ComponentModel.Component)
	GetStyle	(Inherited from System.Windows.Forms.Control)
	GetTopLevel	(Inherited from System.Windows.Forms.Control)
	InvokeGotFocus	(Inherited from System.Windows.Forms.Control)
	InvokeLostFocus	(Inherited from System.Windows.Forms.Control)
	InvokeOnClick	(Inherited from System.Windows.Forms.Control)
	InvokePaint	(Inherited from System.Windows.Forms.Control)
	InvokePaintBackground	(Inherited from System.Windows.Forms.Control)
	IsInputChar	Overridden. Determines whether the specified character is an input character that the component can handle without preprocessing.
	IsInputKey	Overridden. Determines whether the specified key is an input key that the component can handle without preprocessing.
	MemberwiseClone	Overloaded. (Inherited from System.MarshalByRefObject)
	OnActiveSheetChanged	Raises the ActiveSheetChanged event.
	OnActiveSheetChanging	Raises the ActiveSheetChanging event.
	OnActiveSpreadViewChanged	Raises the ActiveSpreadViewChanged event.
	OnActiveSpreadViewChanging	Raises the ActiveSpreadViewChanging event.
	OnAdvance	Raises the Advance event.
	OnAnnotationModeEnding	Raises the AnnotationModeEnding event.
	OnAnnotationModeStarting	Raises the AnnotationModeStarting event.
	OnAutoFilteredColumn	Raises the AutoFilteredColumn event.
	OnAutoFilteringColumn	Raises the AutoFilteringColumn event.
	OnAutoSizeChanged	(Inherited from System.Windows.Forms.Control)
	OnAutoSortedColumn	Raises the AutoSortedColumn event.
	OnAutoSortingColumn	Raises the AutoSortingColumn event.
	OnBackColorChanged	(Inherited from System.Windows.Forms.Control)
	OnBackgroundImageChanged	(Inherited from System.Windows.Forms.Control)
	OnBackgroundImageLayoutChanged	(Inherited from System.Windows.Forms.Control)
	OnButtonClicked	Raises the ButtonClicked event.
	OnCellClick	Raises the CellClick event.
	OnCellDoubleClick	Raises the CellDoubleClick event.
	OnChange	Raises the Change event.
	OnChildControlActivated	Raises the ChildControlActivated event.
	OnChildControlDeactivated	Raises the ChildControlDeactivated event.
	OnChildViewCreated	Raises the ChildViewCreated event.
	OnChildWorkbookCreated	Raises the ChildWorkbookCreated event.
	OnClick	(Inherited from System.Windows.Forms.Control)
	OnClientSizeChanged	Overridden. Override to adjust the client area
	OnClipboardChanged	Raises the ClipboardChanged event.
	OnClipboardPasted	Raises the ClipboardPasted event.
	OnClipboardPasting	Raises the ClipboardPasting event.
	OnColumnDragMove	Raises the ColumnDragMove event.
	OnColumnDragMoveCompleted	Raises the ColumnDragMoveCompleted event.
	OnColumnViewportWidthChanged	Raises the ColumnViewportWidthChanged event.
	OnColumnWidthChanged	Raises the ColumnWidthChanged event.
	OnColumnWidthChanging	Raises the ColumnWidthChanging event.
	OnComboCloseUp	Raises the ComboCloseUp event.
	OnComboDropDown	Raises the ComboDropDown event.
	OnComboSelChange	Raises the ComboSelChange event.
	OnContextMenuStripChanged	(Inherited from System.Windows.Forms.Control)
	OnControlRemoved	Raises the ControlRemoved event. (Inherited from System.Windows.Forms.Control)
	OnCursorChanged	(Inherited from System.Windows.Forms.Control)
	OnDataColumnConfigure	Raises the DataColumnConfigure event.
	OnDialogChar	Raises the DialogChar event.
	OnDialogKey	Raises the DialogKey event.
	OnDoubleClick	Overridden. Raises the DoubleClick event.
	OnDragDrop	(Inherited from System.Windows.Forms.Control)
	OnDragDropBlock	Raises the DragDropBlock event.
	OnDragDropBlockCompleted	Raises the DragDropBlockCompleted event.
	OnDragEnter	(Inherited from System.Windows.Forms.Control)
	OnDragFillBlock	Raises the DragFillBlock event.
	OnDragFillBlockCompleted	Raises the DragFillBlockCompleted event.
	OnDragLeave	(Inherited from System.Windows.Forms.Control)
	OnDragOver	(Inherited from System.Windows.Forms.Control)
	OnEditChange	Raises the EditChange event.
	OnEditError	Raises the EditError event.
	OnEditModeOff	Raises the EditModeOff event.
	OnEditModeOn	Raises the EditModeOn event.
	OnEditModeStarting	Raises the EditModeStarting event.
	OnEditorFocused	Raises the EditorFocused event.
	OnEnabledChanged	Overridden. Raises the EnableChanged event.
	OnEnter	(Inherited from System.Windows.Forms.Control)
	OnEnterCell	Raises the EnterCell event.
	OnError	Raises the Error event.
	OnExpand	Raises the EnterCell event.
	OnFontChanged	(Inherited from System.Windows.Forms.Control)
	OnForeColorChanged	(Inherited from System.Windows.Forms.Control)
	OnGrouped	Raises the Grouped event.
	OnGrouping	Raises the Grouping event.
	OnHyperLinkClicked	Raises the HyperLinkClicked event.
	OnInvalidated	(Inherited from System.Windows.Forms.Control)
	OnLayout	(Inherited from System.Windows.Forms.Control)
	OnLeave	(Inherited from System.Windows.Forms.Control)
	OnLeaveCell	Raises the LeaveCell event.
	OnLocationChanged	(Inherited from System.Windows.Forms.Control)
	OnMarginChanged	(Inherited from System.Windows.Forms.Control)
	OnMouseCaptureChanged	(Inherited from System.Windows.Forms.Control)
	OnMouseClick	(Inherited from System.Windows.Forms.Control)
	OnMouseDoubleClick	(Inherited from System.Windows.Forms.Control)
	OnMove	(Inherited from System.Windows.Forms.Control)
	OnPaddingChanged	(Inherited from System.Windows.Forms.Control)
	OnPaintGrayArea	Raises the PaintGrayArea event.
	OnPaintGroupBarBackground	Raises the PaintGroupBarBackground event.
	OnPaintTabStrip	Raises the PaintTabStrip event.
	OnPaintTabStripButton	Raises the PaintTabStripButton event.
	OnPaintTabStripTab	Raises the PaintTabStripTab event.
	OnParentBackColorChanged	(Inherited from System.Windows.Forms.Control)
	OnParentBackgroundImageChanged	(Inherited from System.Windows.Forms.Control)
	OnParentBindingContextChanged	(Inherited from System.Windows.Forms.Control)
	OnParentChanged	(Inherited from System.Windows.Forms.Control)
	OnParentCursorChanged	(Inherited from System.Windows.Forms.Control)
	OnParentEnabledChanged	(Inherited from System.Windows.Forms.Control)
	OnParentFontChanged	(Inherited from System.Windows.Forms.Control)
	OnParentForeColorChanged	(Inherited from System.Windows.Forms.Control)
	OnParentRightToLeftChanged	(Inherited from System.Windows.Forms.Control)
	OnParentVisibleChanged	(Inherited from System.Windows.Forms.Control)
	OnPreviewKeyDown	(Inherited from System.Windows.Forms.Control)
	OnPreviewRowFetch	Raises the E:PreviewRowFetch event.
	OnPrint	(Inherited from System.Windows.Forms.Control)
	OnPrintAbort	Raises the PrintAbort event.
	OnPrintBackground	Raises the PrintBackground event.
	OnPrintCancelled	Raises the PrintCancelled event.
	OnPrintHeaderFooterArea	Raises the PrintHeaderFooterArea event.
	OnPrintMessageBox	Raises the PrintMessageBox event.
	OnPrintPreviewShowing	Raises the PrintPreviewShowing event.
	OnQueryContinueDrag	(Inherited from System.Windows.Forms.Control)
	OnRangeGroupStateChanged	Raises the RangeGroupStateChanged event.
	OnRangeGroupStateChanging	Raises the RangeGroupStateChanging event.
	OnRegionChanged	(Inherited from System.Windows.Forms.Control)
	OnResize	Overridden. Raises the Resize event.
	OnRightToLeftChanged	Overridden. Raises the RightToLeftChanged event.
	OnRowDragMove	Raises the RowDragMove event.
	OnRowDragMoveCompleted	Raises the RowDragMoveCompleted event.
	OnRowHeightChanged	Raises the RowHeightChanged event.
	OnRowHeightChanging	Raises the RowHeightChanging event.
	OnRowViewportHeightChanged	Raises the RowViewportHeightChanged event.
	OnScrollTipFetch	Raises the ScrollTipFetch event.
	OnSearchDialogClosing	Raises the SearchDialogClosing event.
	OnSelectionChanged	Raises the SelectionChanged event.
	OnSelectionChanging	Raises the SelectionChanging event.
	OnShapeActivated	Raises the ShapeActivated event.
	OnShapeDeactivated	Raises the ShapeDeactivated event.
	OnSheetTabClick	Raises the SheetTabClick event.
	OnSheetTabDoubleClick	Raises the SheetTabDoubleClick event.
	OnSizeChanged	(Inherited from System.Windows.Forms.Control)
	OnStyleChanged	(Inherited from System.Windows.Forms.Control)
	OnSubEditorClosed	Raises the SubEditorClosed event.
	OnSubEditorOpening	Raises the SubEditorOpening event.
	OnSystemColorsChanged	(Inherited from System.Windows.Forms.Control)
	OnTabIndexChanged	(Inherited from System.Windows.Forms.Control)
	OnTabStopChanged	(Inherited from System.Windows.Forms.Control)
	OnTextChanged	(Inherited from System.Windows.Forms.Control)
	OnTextTipFetch	Raises the TextTipFetch event.
	OnTopChange	Raises the TopChange event.
	OnUngrouped	Raises the Grouped event.
	OnUserFormulaEntered	Raises the UserFormulaEntered event.
	OnUserZooming	Raises the UserZooming event.
	OnValidated	(Inherited from System.Windows.Forms.Control)
	OnValidating	Overridden. Raises the Validating event.
	OnVisibleChanged	Overridden. Raises the VisibleChanged event.
	RecreateHandle	(Inherited from System.Windows.Forms.Control)
	RtlTranslateAlignment	Overloaded. (Inherited from System.Windows.Forms.Control)
	RtlTranslateContent	(Inherited from System.Windows.Forms.Control)
	RtlTranslateHorizontal	(Inherited from System.Windows.Forms.Control)
	RtlTranslateLeftRight	(Inherited from System.Windows.Forms.Control)
	ScaleControl	(Inherited from System.Windows.Forms.Control)
	SetAutoSizeMode	(Inherited from System.Windows.Forms.Control)
	SetBoundsCore	(Inherited from System.Windows.Forms.Control)
	SetClientSizeCore	(Inherited from System.Windows.Forms.Control)
	SetStyle	(Inherited from System.Windows.Forms.Control)
	SetTopLevel	(Inherited from System.Windows.Forms.Control)
	SetVisibleCore	(Inherited from System.Windows.Forms.Control)
	SizeFromClientSize	(Inherited from System.Windows.Forms.Control)
	UpdateBounds	Overloaded. (Inherited from System.Windows.Forms.Control)
	UpdateStyles	(Inherited from System.Windows.Forms.Control)
	UpdateZOrder	(Inherited from System.Windows.Forms.Control)

	Name	Description
	ActiveSheetChanged	Occurs when the user has changed the active sheet.
	ActiveSheetChanging	Occurs when the user changes the active sheet.
	ActiveSpreadViewChanged	Occurs when the user has changed the active SpreadView.
	ActiveSpreadViewChanging	Occurs when the user changes the active SpreadView.
	Advance	Occurs when the user tries to advance from first or last row in Spread.
	AnnotationModeEnding	Occurs when the user ends annotation mode.
	AnnotationModeStarting	Occurs when the user begins annotation mode.
	AutoFilteredColumn	Occurs when a column has just been automatically filtered.
	AutoFilteringColumn	Occurs when a column is about to be automatically filtered.
	AutoSortedColumn	Occurs when a column has just been automatically sorted.
	AutoSortingColumn	Occurs when a column is about to be automatically sorted.
	BackColorChanged	(Inherited from System.Windows.Forms.Control)
	BackgroundImageChanged	(Inherited from System.Windows.Forms.Control)
	BackgroundImageLayoutChanged	(Inherited from System.Windows.Forms.Control)
	BindingContextChanged	(Inherited from System.Windows.Forms.Control)
	ButtonClicked	Occurs when the user clicks a button, check box, or hyperlink in a cell.
	CausesValidationChanged	(Inherited from System.Windows.Forms.Control)
	CellClick	Occurs when the user presses down the left mouse button in a cell.
	CellDoubleClick	Occurs when the user presses down the left mouse button twice (double clicks) in a cell.
	Change	Occurs after the user modifies data in a cell.
	ChangeUICues	(Inherited from System.Windows.Forms.Control)
	ChartIndicatorActivated	Occurs when the chart indicator is activated.
	ChartIndicatorDeactivated	Occurs when the chart indicator is deactivated.
	ChildControlActivated	Occurs when a child control is activated.
	ChildControlDeactivated	Occurs when a child control is deactivated.
	ChildViewCreated	Occurs when a child view of the Spread component is created.
	ChildWorkbookCreated	Occurs when a child workbook of the Spread component is created.
	ClientSizeChanged	(Inherited from System.Windows.Forms.Control)
	ClipboardChanged	Occurs when a Clipboard change occurs that can affect the Spread component.
	ClipboardChanging	Occurs when the Clipboard is changing through a Spread action.
	ClipboardPasted	Occurs when the user pastes from the clipboard.
	ClipboardPasting	Occurs when the user pastes from the clipboard.
	ColumnDragMove	Occurs when AllowColumnMove is true and the user drags to move a column.
	ColumnDragMoveCompleted	Occurs when the user finishes dragging to move a column.
	ColumnViewportWidthChanged	Occurs when a viewport column width has changed.
	ColumnWidthChanged	Occurs when the column width has changed.
	ColumnWidthChanging	Occurs when the column width is changing.
	ComboCloseUp	Occurs when the user closes a combo box in a cell.
	ComboDropDown	Occurs when the user drops down a combo box in a cell.
	ComboSelChange	Occurs when the user changes the selection in a combo box in a cell.
	ContextMenuChanged	(Inherited from System.Windows.Forms.Control)
	ContextMenuStripChanged	(Inherited from System.Windows.Forms.Control)
	ControlAdded	(Inherited from System.Windows.Forms.Control)
	ControlRemoved	(Inherited from System.Windows.Forms.Control)
	CursorChanged	(Inherited from System.Windows.Forms.Control)
	DataColumnConfigure	Occurs when the sheet is binding a column to a data source after it has been initialized.
	DialogChar	Occurs during message preprocessing of dialog characters.
	DialogKey	Occurs during message preprocessing of dialog keys.
	Disposed	(Inherited from System.ComponentModel.Component)
	DockChanged	(Inherited from System.Windows.Forms.Control)
	DoubleClick	(Inherited from System.Windows.Forms.Control)
	DragDrop	(Inherited from System.Windows.Forms.Control)
	DragDropBlock	Occurs when the user drags and drops a range of cells.
	DragDropBlockCompleted	Occurs at the completion of the user dragging and dropping a range of cells.
	DragEnter	(Inherited from System.Windows.Forms.Control)
	DragFillBlock	Occurs when the user drags to fill a range of cells.
	DragFillBlockCompleted	Occurs at the completion of the user dragging to fill a range of cells.
	DragLeave	(Inherited from System.Windows.Forms.Control)
	DragOver	(Inherited from System.Windows.Forms.Control)
	EditChange	Occurs when the user changes the text in a cell in edit mode.
	EditError	Occurs when the user performs an invalid input operation.
	EditModeOff	Occurs when edit mode is stopped.
	EditModeOn	Occurs when edit mode is started.
	EditModeStarting	Occurs when edit mode is about to start in the active sheet's active cell.
	EditorFocused	Occurs when the editing control gets focus.
	EnabledChanged	(Inherited from System.Windows.Forms.Control)
	Enter	(Inherited from System.Windows.Forms.Control)
	EnterCell	Occurs when the user enters a cell.
	Error	Occurs when the user performs an invalid operation.
	Expand	Occurs when a row is expanded or collapsed.
	FontChanged	(Inherited from System.Windows.Forms.Control)
	GiveFeedback	(Inherited from System.Windows.Forms.Control)
	GotFocus	(Inherited from System.Windows.Forms.Control)
	Grouped	Occurs when the grouping is finished.
	Grouping	Occurs when the user performs grouping.
	HandleCreated	(Inherited from System.Windows.Forms.Control)
	HandleDestroyed	(Inherited from System.Windows.Forms.Control)
	HelpRequested	(Inherited from System.Windows.Forms.Control)
	HyperLinkClicked	Occurs when the user clicks on text of hyper link.
	ImeModeChanged	(Inherited from System.Windows.Forms.Control)
	Invalidated	(Inherited from System.Windows.Forms.Control)
	KeyDown	(Inherited from System.Windows.Forms.Control)
	KeyPress	(Inherited from System.Windows.Forms.Control)
	KeyUp	(Inherited from System.Windows.Forms.Control)
	Layout	(Inherited from System.Windows.Forms.Control)
	Leave	(Inherited from System.Windows.Forms.Control)
	LeaveCell	Occurs when the user leaves a cell.
	LeftChange	Occurs when left column changes.
	LocationChanged	(Inherited from System.Windows.Forms.Control)
	LostFocus	(Inherited from System.Windows.Forms.Control)
	MarginChanged	(Inherited from System.Windows.Forms.Control)
	MouseCaptureChanged	(Inherited from System.Windows.Forms.Control)
	MouseClick	(Inherited from System.Windows.Forms.Control)
	MouseDoubleClick	(Inherited from System.Windows.Forms.Control)
	MouseDown	(Inherited from System.Windows.Forms.Control)
	MouseEnter	(Inherited from System.Windows.Forms.Control)
	MouseHover	(Inherited from System.Windows.Forms.Control)
	MouseLeave	(Inherited from System.Windows.Forms.Control)
	MouseMove	(Inherited from System.Windows.Forms.Control)
	MouseUp	(Inherited from System.Windows.Forms.Control)
	MouseWheel	(Inherited from System.Windows.Forms.Control)
	Move	(Inherited from System.Windows.Forms.Control)
	PaddingChanged	(Inherited from System.Windows.Forms.Control)
	Paint	(Inherited from System.Windows.Forms.Control)
	PaintGrayArea	Occurs when the gray area needs painting.
	PaintGroupBarBackground	Occurs when the group bar background is painted.
	PaintTabStrip	Occurs when the TabStrip needs painting.
	PaintTabStripButton	Occurs when a TabStrip button needs painting.
	PaintTabStripTab	Occurs when a TabStrip tab needs painting.
	ParentChanged	(Inherited from System.Windows.Forms.Control)
	PreviewKeyDown	(Inherited from System.Windows.Forms.Control)
	PreviewRowFetch	Occurs when the user custom preview row of the Spread component.
	PrintAbort	Occurs continually as printing occurs in order to give the user the opportunity to discontinue a print job.
	PrintBackground	Occurs before each page is printed.
	PrintCancelled	Occurs when a print job is discontinued by the user.
	PrintHeaderFooterArea	Occurs when header or footer needs printing.
	PrintMessageBox	Occurs before and after a print job.
	PrintPreviewShowing	Occurs before preview dialog appears.
	QueryAccessibilityHelp	(Inherited from System.Windows.Forms.Control)
	QueryContinueDrag	(Inherited from System.Windows.Forms.Control)
	RangeGroupStateChanged	Occurs when the user changed the state of some outline (range group) of rows or columns.
	RangeGroupStateChanging	Occurs before user changes the state of some outline (range group) of rows or columns.
	RegionChanged	(Inherited from System.Windows.Forms.Control)
	Resize	(Inherited from System.Windows.Forms.Control)
	RightToLeftChanged	(Inherited from System.Windows.Forms.Control)
	RowDragMove	Occurs when AllowRowMove is true and the user drags to move a row.
	RowDragMoveCompleted	Occurs when the user finishes dragging to move a row.
	RowHeightChanged	Occurs when the row height has changed.
	RowHeightChanging	Occurs when the column width is changing.
	RowViewportHeightChanged	Occurs when a viewport row height has changed.
	ScrollTipFetch	Occurs when the user scrolls the Spread component.
	SearchDialogClosing	Occurs when the search form is closing.
	SelectionChanged	Occurs when the selection of cells on the sheet is changed.
	SelectionChanging	Occurs when the selection of cells on the sheet is changing.
	ShapeActivated	Occurs when the user changes the active shape object.
	ShapeDeactivated	Occurs when the user deactivates the active shape object.
	SheetTabClick	Occurs when the user clicks the sheet tab.
	SheetTabDoubleClick	Occurs when the user double clicks the sheet tab.
	SizeChanged	(Inherited from System.Windows.Forms.Control)
	StyleChanged	(Inherited from System.Windows.Forms.Control)
	SubEditorClosed	Occurs when a subeditor is closed for a cell.
	SubEditorOpening	Occurs when a subeditor is about to be displayed.
	SystemColorsChanged	(Inherited from System.Windows.Forms.Control)
	TabIndexChanged	(Inherited from System.Windows.Forms.Control)
	TabStopChanged	(Inherited from System.Windows.Forms.Control)
	TextChanged	(Inherited from System.Windows.Forms.Control)
	TextTipFetch	Occurs 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).
	TopChange	Occurs when the top row changes.
	Ungrouped	Occurs when all the grouping is removed.
	UserFormulaEntered	Occurs when the user types a formula.
	UserZooming	Occurs when the user zooms.
	Validated	(Inherited from System.Windows.Forms.Control)
	Validating	(Inherited from System.Windows.Forms.Control)
	VisibleChanged	(Inherited from System.Windows.Forms.Control)

Public Constructors

Public Properties

Protected Properties

Public Methods

Protected Methods

Public Events

See Also

Reference

User-Task Documentation