Provides the base classes, interfaces, enumerations, and event handlers for the Spread for Windows Forms spreadsheet component.

Classes

	Class	Description
	Action	Represents an action in the component that is used for mapping to keys.
	ActionMap	Represents an action map, which provides mappings from objects to actions.
	ActiveSheetChangingEventArgs	Represents the event data for the ActiveSheetChanging event for the component, which occurs when the component changes to another active sheet.
	AdvancedSearchDialog	Represents an advanced search dialog.
	AdvanceEventArgs	Represents the event data for the Advance event for the Spread component, which occurs when focus is advanced to another control.
	AlternatingRow	Represents a set of style information for alternating rows in the component.
	AlternatingRows	Represents a one-dimensional collection of AlternatingRow objects, which set the style information for alternating rows in the component.
	AnimatedDefaultFocusIndicatorRenderer	Represents the renderer of the default changing (or animated) focus indicator.
	AnnotationModeEventArgs	Represents the event data for the AnnotationMode events for the Spread component, which allows the user to be notified when annotation mode is starting and ending.
	Appearance	Represents the appearance settings for an object.
	AutoFilteredColumnEventArgs	Represents the event data for the AutoFilteredColumn event for the Spread component, which occurs when the column has been automatically filtered.
	AutoFilteringColumnEventArgs	Represents the event data for the AutoFilteringColumn event for the Spread component, which occurs when columns are being automatically filtered.
	AutoSortedColumnEventArgs	Represents the event data for the AutoSortedColumn event for the Spread component, which occurs when the column has been automatically sorted.
	AutoSortingColumnEventArgs	Represents the event data for the AutoSortingColumn event for the Spread component, which occurs when columns are being automatically sorted.
	AverageConditionalFormattingRule	Represents an above or below average conditional formatting rule.
	BaseFilterItem	Represents the basis for a custom filter.
	BaseSparkline	Base class that represents sparkline data infomation.
	BeforeSettingPropertyValueEventArgs	Represents before setting property value event arguments.
	BestFitColumnRule	Represents the rules that determine how best to print the columns.
	BetweenValuesConditionalFormattingRule	Represents a conditional formatting rule that accept or does not accept a value in a range.
	BlankConditionalFormattingRule	Represents a conditional formatting rule that accepts blank or nonblank values.
	CalculateExceptionEventArgs	Represents the event data for the CalculateException event, that contains the exception thrown when calculating the result of a formula.
	Cell	Represents a cell in the Spread component.
	CellClickEventArgs	Represents the event data for the CellClick and CellDoubleClick events for the Spread component, which occurs when the user clicks or double-clicks the mouse button with the pointer on a cell.
	CellErrorTextChangedEventArgs	/// Provides data for the Cell event of a FpSpread control.
	CellFooter	Represents a footer cell.
	CellPadding	Represents padding information associated with a cell.
	Cells	Represents a two-dimensional collection of Cell objects.
	CellTouchStrip	Represent a special SpreadTouchStrip that pops up in the cell area.
	ChangeEventArgs	Represents the event data for the Change event for the Spread component, which occurs when a cell changes.
	ChartTouchStrip	Represents a special SpreadTouchStrip which includes some common items.
	ChildControlEventArgs	Represents the event data for the child control related events for the Spread component.
	ChildViewCreatedEventArgs	Represents the event data for a ChildViewCreated event for the Spread component, which occurs when a child sheet is created in a hierarchical spreadsheet.
	ChildWorkbookCreatedEventArgs	Represents the event data for a ChildWorkbookCreated event for the Spread component, which occurs when a child sheet is created in a hierarchical spreadsheet.
	ClipboardPastedEventArgs	Represents the event data for the ClipboardPasted event for the Spread component, which occurs after the Clipboard paste action.
	ClipboardPastingEventArgs	Represents the event data for the ClipboardPastingEvent event for the Spread component, which occurs when the user invokes the Clipboard paste action.
	ColorFilterItem	Provides a ColorFilter class to filter cells using the color specified in the filter criteria.
	Column	Represents a column in the component.
	ColumnFooter	Represents the column footer portion of the control.
	ColumnHeader	Represents the column header portion of the control.
	Columns	Represents a one-dimensional collection of Column objects.
	Columns.DefaultColumn	Represents the default column in the component.
	ColumnSparklineRenderer	Represents the renderer of the column sparklines.
	ColumnTouchStrip	Represents a special SpreadTouchStrip that pops up in the column area.
	ColumnViewportWidthChangedEventArgs	Represents the event data for the ColumnViewportWidthChanged event for the Spread component, which occurs when the width of a viewport column has changed.
	ColumnWidthChangedEventArgs	Represents the event data for the ColumnWidthChanged event for the Spread component, which occurs when the width of a column has changed.
	ColumnWidthChangeExtents	Represents an object that contains first and last columns in a contiguous selection whose widths are changing.
	ColumnWidthChangingEventArgs	Represents the event data for the ColumnWidthChanging event for the Spread component, which occurs when the width of a column is changing.
	ConditionalFormat	Represents a conditional format.
	ConditionalFormatInfo	Internal use only.
	ConditionalFormatting	Represents a conditional format.
	ConditionalFormattingChangedEventArgs	Represents the event data for the Changed event of conditional formatting.
	ConditionalFormattingColorValue	Represents a color conditional formatting value.
	ConditionalFormattingColorValueCollection	Represents a collection of conditional formatting color values.
	ConditionalFormattingIconRuleSet	Represents a set of icons which are used for an icon conditional formatting rule.
	ConditionalFormattingIconValue	Represents a complex value of the conditional formatting icon rule.
	ConditionalFormattingModel	Represents the conditional formatting model for a sheet.
	ConditionalFormattingModelEventArgs	Represents the event data for the Changed event of the conditional formatting model for the sheet.
	ConditionalFormattingRule	Represents the base class for conditional format rules.
	ConditionalFormattingRulePropertyChangedEventArgs	Provides data for the IConditionalFormatting.PropertyChanged event.
	ConditionalFormattingUtils	The collection function to use for conditional formatting
	ConditionalFormattingValue	Represents a complex value of a conditional formatting rule.
	ConditionalFormattingValueCollection	Represents a collection of conditional formatting values.
	CustomFillSeriesList	Present Custom list for drag fill in series mode
	CustomFilterItem	Provides a CustomFilters class that groups custom filter elements together.
	CustomFocusIndicatorRenderer	Represents a custom renderer of the focus indicator.
	CustomIconContainer	Provides an icon object container.
	CustomImageInfo	Represents a complex identification for custom images.
	CustomNameChangedEventArgs	Represents the data for changes to the custom name.
	DataAddNewException	Represents an exception thrown when adding AutoAddNewRow.
	DatabarConditionalFormattingRule	Represents the data bar conditional formatting rule.
	DataColumnConfigureEventArgs	Represents the event data for the DataColumnConfigure event, which occurs when the column is being configured for data binding.
	DefaultErrorIconRenderer	Represents the default painter for the ErrorIcon in a cell.
	DefaultFilterItem	Represents the default filtering of rows based on specified criteria.
	DefaultFocusIndicatorRenderer	Represents the renderer of the default focus indicator.
	DefaultGroupFooter	Contains the default setting for the group footer.
	DefaultGroupFooterCollection	Contains default group footers for grouping
	DefaultNoteIndicatorRenderer	Represents the default painter for the indicator of a note in a cell.
	DefaultRangeGroupModel	Represents the relevant default information about an outline (range group) of rows and columns.
	DefaultRowFilter	Represents a default row filter that extends to implement the supported row filters.
	DefaultScrollBarRenderer	Represents the scroll bar renderer that uses the default skin.
	DefaultSelectionRenderer	Represents the default selection renderer.
	DefaultSkins	Read-only collection of default (built-in) skins.
	DefaultSparklineContainer	Represents the full (concrete) implementation of the ISparklineContainer interface for a sparkline model for a sheet, which represents sparklines.
	DefaultSpreadSkins	Represents the read-only collection of default (built-in) Spread skins.
	DefaultStyleCollection	Represents the read-only collection of default NamedStyle objects.
	DialogCharEventArgs	Represents the event data for the DialogChar event of a Spread component.
	DialogKeyEventArgs	Represents the event data for the DialogKey event of a Spread component.
	DragDropBlockCompletedEventArgs	Represents the event data for the DragDropBlockCompleted event for the Spread component, which occurs when the dragging and dropping of a range of cells is completed.
	DragDropBlockEventArgs	Represents the event data for the DragDropBlock event for the Spread component, which occurs when a range of cells is being dragged and dropped.
	DragFillBlockCompletedEventArgs	Represents the event data for the DragFillBlockCompleted event for the Spread component, which occurs when the dragging and filling of a range of cells is completed.
	DragFillBlockEventArgs	Represents the event data for the DragFillBlock event for the Spread component, which occurs when the range of cells is being dragged and filled.
	DragMoveCompletedEventArgs	Represents the event data for the ColumnDragMoveCompleted and RowDragMoveCompleted event for the Spread component.
	DragMoveEventArgs	Represents the event data for the ColumnDragMove and RowDragMove events for the Spread component.
	DynamicFilterItem	Provides a DynamicFilter class to filter cells based on a set of built-in definitions due to DynamicFilterType.
	EditErrorEventArgs	Represents the event data for the EditError event for the Spread component, which occurs when errors are generated when using the editor.
	EditingFocusIndicatorRenderer	Represents the renderer for the editor focus.
	EditModeStartingEventArgs	Represents the event data for the EditModeOn event for the Spread component, which occurs when edit mode is starting.
	EditorNotifyEventArgs	Represents the event data for the EditorNotify event for the component, which occurs when the editor notifies the component of one of several changes.
	EnhancedFocusIndicatorRenderer	Represents the renderer for drawing the border around the active cell (that has focus).
	EnhancedInterfaceRenderer	Represents the painter of the visual elements with Excel2007 style.
	EnhancedScrollBarRenderer	Represents the renderer that paints the the scroll bar with the enhanced skin.
	EnterCellEventArgs	Represents the event data for the EnterCell event for the Spread component, which occurs when the focus enters a cell.
	ErrorConditionalFormattingRule	Represents a conditional formatting rule that accepts error or nonerror values.
	ErrorEventArgs	Represents the event data for the Error event for the Spread component, which occurs when errors are generated by user interaction.
	EventListener	Represents an event listener.
	EventListener.EventHandlerAdapter	Represents an event handler adapter.
	EventNameConverter	Converter for EventName
	ExcelBaseSparkLineRenderer	Abstract class that represents the renderer of the Excel-like sparklines.
	ExcelSparkline	Represents sparkline data based on the cell range.
	ExcelSparklineGroup	Represents a group of Excel-like sparklines.
	ExcelSparklineSetting	Represents a setting of an Excel-like sparkline.
	ExpandEventArgs	Represents the event data for the Expand event for the Spread component, which occurs when the hierarchy display is being expanded (showing child sheet views).
	ExpressionConsumerFormulaInfo	Contains information about IExpressionConsumer and the expressions corresponding to its formulas.
	ExtraRendererSettings	Represents the extra setting for the renderer to paint.
	FilterBar	Provides a FilterBarInfo class that represents information about the filter bar in the Spread component.
	FilterBarEventArgs	Represents the event data for the FilterBarClick and FilterBarDoubleClick events for the Spread component, which occur when the user clicks or double-clicks the mouse button with the pointer on the filter bar.
	FilterBarHitTestInformation	Represents hit test information for the filter bar of the spreadsheet.
	FilterColumnDefinition	Represents a filter column definition.
	FilterColumnDefinitionCollection	Represents a collection of filter column definitions.
	FilterCondition	Provides a CustomFilter class that specifies an operator and a value.
	FilterItemCollection	Represents a collection of custom filters.
	FilterItemValue	Provides a ValueFilterItem class used as filter criteria.
	FilterItemValueCollection	Provides a ValueFilterItemCollection object used as a collection of alternative ValueFilterItem elements.
	FormulaConditionalFormattingRule	Represents the conditional formatting rule that uses a formula to determine which cells to format before starting to paint the background.
	FormulaProvider	Represents a way to provide a formula property (and trigger event) to any control on the form.
	FormulaTextBox	Represents the floating formula editor.
	FpHorizontalScrollBar	Represents the FarPoint horizontal scroll bar.
	FpScrollBar	Represents the FarPoint scroll bar.
	FpScrollBarButton	Represents the FarPoint scroll bar button.
	FpScrollBarButtonBackwardHome	Represents a FarPoint scroll bar backward-to-home button.
	FpScrollBarButtonBackwardLine	Represents a FarPoint scroll bar back-by-line button.
	FpScrollBarButtonBackwardPage	Represents a FarPoint scroll bar page back button.
	FpScrollBarButtonClickEventArgs	Represents the event data for the FpScrollBarButtonClickEvent, for the Spread component, which occurs when the Spread scroll bar button is clicked.
	FpScrollBarButtonCollection	Represents the collection of the elements of the FarPoint scroll bar.
	FpScrollBarButtonForwardEnd	Represents a FarPoint scroll bar forward-to-end button.
	FpScrollBarButtonForwardLine	Represents a FarPoint scroll bar forward-by-line button.
	FpScrollBarButtonForwardPage	Represents a FarPoint scroll bar page forward button.
	FpScrollBarComboThumb	Represents a combination of the backward track, forward track, and thumb of the scroll bar.
	FpScrollBarGripper	Represents the FarPoint scroll bar grip.
	FpScrollBarThumb	Represents a FarPoint scroll bar thumb.
	FpScrollBarTrack	Represents a FarPoint scroll bar track.
	FpScrollBarTrackBackward	Represents the backward track of the FarPoint scroll bar.
	FpScrollBarTrackForward	Represents the forward track of the FarPoint scroll bar.
	FpSpread	Represents the Spreadsheet component.
	FpVerticalScrollBar	Represents the FarPoint vertical scroll bar.
	GetCustomIconEventArgs	The event arguments for the CustomIcon event handler.
	GradientInterfaceRenderer	Represents the painter of gradients in the interface.
	GradientSelectionRenderer	Represents a renderer for displaying a gradient for a selection in the spreadsheet.
	GridLine	Represents the grid lines.
	GroupBarInfo	Represents information about the grouping bar in the Spread component.
	GroupInfo	Represents the grouping information.
	GroupInfoCollection	Represents the read-only collection of GroupInfo objects.
	GroupingEventArgs	Represents the event data for grouping events in the Spread component.
	HeaderHitTestInformation	Represents hit test information for the headers of the spreadsheet.
	HideRowFilter	Represents the filter that hides rows based on certain criteria.
	HighlightConditionalFormattingRule	Represents the conditional formatting rule that is used before starting to paint the background.
	HighlightConditionalFormattingStyle	Represents the highlight style which applies the conditional formatting rule using highlighting.
	HitTestInformation	Represents hit test information for the data area of the spreadsheet.
	HyperLinkClickedEventArgs	Represents the event data for the HyperLinkClicked event for the component, which occurs when the hyper link cell is clicked.
	IconFilterItem	Provides an IconFilter class to filter cells using an icon specified in the filter criteria.
	IconSetConditionalFormattingRule	Represents the rule that paints an icon in the cell.
	ImageFocusIndicatorRenderer	Represents the renderer of the image focus indicator.
	InputMap	Represents the map between input by the user and the action that occurs.
	InvalidFileFormatException	Exception is thrown when fail to load input map file.
	ItemEventArgs	Provides data for an event in a collection.
	ItemTrackedEventArgs	Represents the event data for the element in a collection that has been updated.
	KeystrokeFactory	Represents a means of creating Keystroke objects in environments that do not support parameterized constructors.
	LandscapeRule	Represents the rules that determine whether to print in landscape format.
	LeaveCellEventArgs	Represents the event data for the LeaveCell event for the Spread component, which occurs when the focus leaves a cell.
	LeftChangeEventArgs	Represents the event data for the LeftChange event for the Spread component, which occurs when the left column in the view changes.
	LineSparklineRenderer	Represents the line sparkline renderer.
	ListBase.ListChangedEventArgs<T>	Provides data for the System.ComponentModel.IBindingList.ListChanged event.
	MarqueeFocusIndicatorRenderer	Represents the renderer of the marquee (or animated) focus indicator.
	ModelessTextBox	ModelessTextBox
	MultiValuesFilterItem	Provides a Filters class to filter items using a criteria values list.
	NameBox	Represents the custom name texbox.
	NamedStyle	Represents a custom style, an object that can be used to set style information for other objects.
	NamedStyleCollection	Represents a collection of NamedStyle objects.
	NamedStyleCollectionEventArgs	Represents the event data for the NamedStyleCollection object's Changed event.
	NoteEventArgs	Represents the data for the note event.
	OwnerPrintInfo	Represents the printing information for OwnerPrintDraw.
	PaintGrayAreaEventArgs	Represents the event data for the PaintGrayArea event for the Spread component.
	PaintGroupBarBackgroundEventArgs	Represents the event data for PaintGroupBarBackground events in the Spread component.
	PaintTabStripButtonEventArgs	Represents the event data for the PaintTabStripButton event for the Spread component.
	PaintTabStripEventArgs	Represents the event data for the PaintTabStrip event for the Spread component.
	PaintTabStripTabEventArgs	Represents the event data for the PaintTabStripTab event for the Spread component.
	PrePaintConditionalFormattingRule	Represents a conditional format rule that is executed before painting the cell.
	PrePaintResult	Represents the executed result of a conditional formatting rule.
	PrePaintTextConditionalFormattingRule	Represents the conditional formatting rule that is used for painting before the text is painted.
	PrePaintTextResult	Represents the painting result of a conditional formatting rule.
	PreviewRowFetchEventArgs	Represents the event data for the PreviewRowFetch event for the Spread component, which occurs for formatting the preview row content.
	PreviewRowInfo	Represents information about preview row in the Spread component.
	PrintAbortEventArgs	Represents the event data for the PrintAbort event for the Spread component, which allows the user to discontinue the printing at any time during a print job.
	PrintBackgroundEventArgs	Represents the event data for the PrintBackground event for the Spread component, which occurs when the background is printing.
	PrintCancelledEventArgs	Represents the event data for the PrintCancelled event for the Spread component, which occurs when the printing is discontinued by the user.
	PrintDocumentEventArgs	Represents the event data for the PrintDocument event for the Spread component, which occurs during the print process of the sheetview.
	PrintHeaderFooterAreaEventArgs	Represents the event data for the PrintHeaderFooterArea event for the Spread component, which occurs when the background is printing.
	PrintInfo	Represents the information to use when printing a sheet of the control.
	PrintMargin	Represents the margin for the printed page.
	PrintMessageBoxEventArgs	Represents the event data for the PrintMessageBox event for the Spread component, which occurs when the print message box is to be displayed.
	PrintPreviewShowingEventArgs	Represents the event data for the PrintPreviewShowing event for the Spread component, which occurs before the print preview dialog appears.
	PropertyTrackChangedEventArgs	Represents raising an event when the property has changed and has infomation about the current value and the previous value.
	QueryValueEventArgs	This is event argument which is used to contain the result when querying value from client
	RangeElement<T>	Keeps the information about which cell ranges contain the elements.
	RangeGroupHitTestInformation	Represents hit test information for the outline (range group) of the spreadsheet.
	RangeGroupInfo	Represents the relevant information of an outline (range group) of rows or columns.
	RangeGroupInfoEventArgs	Represents the event data for the Changed event of the outline (range group) model for the sheet.
	RangeGroupModelEventArgs	Represents the event data for the Changed event of the outline (range group) for the sheet.
	RangeGroupStateChangedEventArgs	Represents the event data for the RangeGroupStateChanged event for an outline (range group) of rows and columns in the Spread component.
	RangeGroupStateChangingEventArgs	Represents the event data for the RangeGroupStateChanging event for an outline (range group) of rows and columns in the Spread component.
	ReloadSheetCellRangeFormulaEventArgs	Represents the event data for the FormulaChanged event, which occurs when an object that contains the sheet cell ranges notifies that formulas have been changed and that the SheetCellRange needs to be updated.
	Row	Represents a row in the component.
	RowErrorTextChangedEventArgs	/// Provides data for the Cell event of a FpSpread control.
	RowHeader	Represents the row header portion of the control.
	RowHeightChangedEventArgs	Represents the event data for the RowHeightChanged event for the Spread component, which occurs when the height of a row is changed.
	RowHeightChangeExtents	Represents an object that contains first and last rows in contiguous selection whose heights are changing.
	RowHeightChangingEventArgs	Represents the event data for the RowHeightChanging event for the Spread component, which occurs when the height of a row is changing.
	Rows	Represents a one-dimensional collection of Row objects.
	Rows.DefaultRow	Represents the default row in the component.
	RowTouchStrip	Represents a special SpreadTouchStrip that pops up in the row area.
	RowViewportHeightChangedEventArgs	Represents the event data for the RowViewportHeightChanged event for the Spread component, which occurs when the height of a viewport row has changed.
	ScaleRule	Represents the rules that determine how to scale the printed sheet.
	ScrollingContentInfo	Represents information about the scrolling grid content in the Spread component.
	ScrollTipFetchEventArgs	Represents the event data for the ScrollTipFetch event for the Spread component, which occurs when the spread is scrolled.
	SearchDialog	Represents a search dialog.
	SelectionChangedEventArgs	Represents the event data for the SelectionChanged event for the Spread component, which occurs when the user has changed the selection by selecting another range of cells.
	SelectionChangingEventArgs	Represents the event data for the SelectionChanging event for the Spread component, which occurs when the user is selecting another range of cells.
	ShapeTouchStrip	Represents a special SpreadTouchStrip which includes some common items.
	SheetCorner	Represents the corner of the control.
	SheetSkin	Represents a skin, which provides style settings for a sheet.
	SheetStyleProperty	Represents a style property in the StyleInfo object.
	SheetTab	Represents an individual sheet name tab.
	SheetTabClickEventArgs	Represents the event data for the SheetTabClick event for the Spread component, which occurs when the user clicks the mouse button with the pointer on the sheet name tab.
	SheetTabDoubleClickEventArgs	Represents the event data for the SheetTabDoubleClick event for the Spread component, which occurs when the user double-clicks on a sheet name tab.
	SheetView	Represents an individual sheet in the Spread component.
	SheetView.DocumentModels	Represents the SheetView.DocumentModels object that contains the models that make up the sheet.
	SheetView.MultipleColumnMovingException	Exception thrown when moving multiple columns.
	SheetView.MultipleRowMovingException	Exception thrown when moving multiple rows.
	SheetView.SaveAutoSortColumns	Represents the SheetView.SaveAutoSortColumns object that contains the automatic sorting settings for the sheet.
	SheetViewCollection	Represents a collection of sheets (SheetView objects).
	SheetViewEventArgs	Represents the event data for the sheet.
	SheetViewPropertyChangeEventArgs	Represents the data for changes to the sheet properties.
	SmartPaperRule	Represents the rules that determine the paper size.
	SmartPrintRule	Represents the rules that determine how best to print.
	SmartPrintRulesCollection	Represents the set of rules that determine how best to print.
	SolidFocusIndicatorRenderer	Represents the renderer of the solid focus indicator.
	SortInfo	Represents the information related to sorting columns, rows, or a range of cells.
	Sparkline	Represents a sparkline in a cell.
	SparklineInfo	Represents sparkline information in a cell.
	SparklineModelUpdateEventArgs	Represents the event data for the UpdatedCellRanges event, which occurs when a list of cellranges are updated.
	SpreadActions	Represents navigation, selection, clipboard, and other actions.
	SpreadFontStyle	Specifies the font style information applied to the text.
	SpreadSkin	Represents the skin of the Spread component.
	SpreadSparklineRenderes	Read-only collection of default (built-in) sparkline renderers.
	SpreadTouchStrip	Represents the SpreadTouchStrip for FpSpread.
	SpreadView	Represents a view of the spreadsheet display.
	StickyNoteEventArgs	Obsolete. Use NoteEventArgs class instead. Represents the data for the sticky note event.
	StyleContainerEventArgs	Internal use only.
	StyleInfo	Represents the set of cell-level style settings for objects.
	StyleNameConverter	Provides a drop-down list of style names for the StyleName property in the Cell, Column, Row, and AlternatingRow classes.
	StyleRowFilter	Represents the filter that sets the styles of rows based on certain criteria.
	SubEditorClosedEventArgs	Represents the event data for the SubEditorClosed event for the Spread component, which occurs when the subeditor in a cell has closed.
	SubEditorOpeningEventArgs	Represents the event data for the SubEditorOpening event in the Spread component, which occurs when the subeditor in a cell is opening.
	TabStrip	Represents the set of sheet tabs.
	TabStripHitTestInformation	Represents hit test information for the tab strip of the spreadsheet.
	TextConditionalFormattingRule	Represents the conditional formatting rule used for checking text values.
	TextTipFetchEventArgs	Represents the event data for the TextTipFetch event for the Spread component, which occurs when the text tip is being fetched.
	ThreeColorScaleConditionalFormattingRule	Represents the color scale conditional formatting rule with one middle value.
	TimePeriodConditionalFormattingRule	Represents a conditional formatting rule that accepts periods of time.
	TipAppearance	Represents the appearance settings for various tips in the interface (text tips, scroll tips, and cell notes).
	TitlebarHitTestInformation	Represents hit test information for the title and subtitle.
	TitleInfo	Represents information about the title bar in the Spread component.
	Top10FilterItem	Provides a Top10Filter class to filter cells whose values are numeric.
	TopChangeEventArgs	Represents the event data for the TopChange event in the Spread component, which occurs when the top row changes.
	TopRankedValuesConditionalFormattingRule	Represents a top bottom conditional formatting rule.
	TouchStripButton	Represents a tool strip button for a touch device.
	TouchStripOpeningEventArgs	Represents the event arguments for the FpSpread.TouchStripOpening event.
	TriangleNoteIndicatorRenderer	Represents the painter that drawing the indicator shape for a triangle for the indicator of a note in a cell.
	TwoColorScaleConditionalFormattingRule	Represents the two color scale conditional formatting rule.
	UnaryComparisonConditionalFormattingRule	Represents the conditional formatting rule that is used before starting to paint the background.
	UniqueOrDuplicatedConditionalFormattingRule	Represents a conditional formatting rule that accepts unique or duplicated values.
	UserFormulaEnteredEventArgs	Represents the event data for the UserFormulaEntered event for the Spread component, which occurs when the user has entered a formula in a cell.
	UserSpecifiedFilterItem	Represents a user specified filter item.
	ViewportHitTestInformation	Represents hit test information for the viewports of the spreadsheet.
	WinLossSparklineRenderer	Represents the renderer of the win/loss sparklines.
	ZoomEventArgs	Represents the event data for the UserZooming event for the Spread component, which occurs when the user zooms.

Interfaces

	Interface	Description
	IAllowArrowKeysMoveActiveCell	Interface that defines the methods and properties required by objects used to allow the arrows to move the active cell.
	IAnimatedFocusIndicatorRenderer	Interface that supports painting a changing (or animated) focus indicator.
	IConditionalFormatSupport	Interface that supports conditional formatting of cells on a sheet.
	IConditionalFormatSupport2	Interface that supports conditional formatting of cells on a sheet.
	IConditionalFormattingDataRule	Represents an interface which provides supported requirements for a conditional formatting rule.
	IConditionalFormattingModel	Represents the conditional formatting model for a sheet.
	IConditionalFormattingRule	Represents a conditional formatting rule.
	IConditionalFormattingRuleCellRangeInvalidatingRequest	Represent an interface which provides invalidating request
	ICustomizeColor	Interface that defines the methods and properties required by objects used as customization of the color of TabStrip.
	IEnhancedInterfaceRenderer	Interface that defines the enhanced methods and properties required by objects used as painters of tab sheets.
	IEnhancedPdfRenderer	Interface that supports printing to PDF, which supports extended features.
	IEnhancedRenderer	Interface that defines the methods and properties required by objects used as enhanced renderers which supports extended features. Renderers are responsible for painting cells.
	IErrorIconRenderer	Interface that defines the methods and properties required by objects used as painters of the error icon.
	IExcelExporter	Provides a unified way of converting types of values to a value used for Excel export.
	IFilteredRowSupport	Interface that supports style filters in the style model for filtering rows on a sheet.
	IFilterItem	Interface that supports the creation of custom row filters for filtering rows on a sheet.
	IFilterSupport	Interface that supports row filters for filtering rows on a sheet.
	IFocusIndicatorRenderer	Interface that supports painting the focus indicator using a specified control and dimensions.
	IFormulaEditingSupport	Indicates the cell editor can handle formula input.
	IIgnoreSupport	Interface that defines the methods and properties required by objects used for ignoring changes of the sheet.
	IInterfaceRenderer	Interface that defines the methods and properties required by objects used as painters of tab sheets.
	INoteIndicatorRenderer	Interface that defines the methods and properties required by objects used as painters of the note indicator.
	INoteIndicatorRenderer2	Interface that defines the methods and properties required by objects used as painters of the note indicator.
	INoteIndicatorRenderer3	Interface that defines the methods and properties required by objects used as painters of the note indicator.
	INotifyItemChanged	Interface that notifies Spread when the item is changed.
	IOptimizedFilterConditionalFormattingModel	Interface that supports additional optimization in the conditional formatting model beyond IOptimizedFilterConditionalFormattingModel.
	IOptimizedFilterStyleModel	Interface that supports additional optimization for retrieval of styles in the style model beyond IOptimizedFilterStyleModel.
	IPdfPrintableRule	Represents the conditional formatting rule that is used for painting to PDF before the text is painted.
	IPrePaintConditionalFormattingRule	Represents the conditional formatting rule that is used before starting to paint the background.
	IPrePaintTextConditionalFormattingRule	Represents the conditional formatting rule that is used for painting before the text is painted.
	IPropertyChangedNotification	Interface for notifying Spread when the property changes from the previous value.
	IRangeGroupModel2	Interface that supports creating a model that represents an outline (range group) of rows or columns.
	IRangeGroupModel3	Interface that supports creating a model that represents an outline (range group) of rows or columns.
	IRangeGroupSupport	Interface that supports the outline (range group) of rows or columns.
	IRowFilter	Interface that supports row filters for filtering rows on a sheet.
	IRowFilter2	Interface that supports row filters for filtering rows on a sheet.
	IRowFilterFrozenSupport	Interface for supporting optional filtering of frozen rows.
	IScrollBarRenderer	Interface that supports painting the scroll bar.
	ISelectionRenderer	Interface that supports painting the selection.
	ISheetCellRangeSupport	Interface that causes the SheetCellRange container to reevaluate the SheetCellRange when the formula changes.
	ISparkline	Interface that supports creating a sparkline.
	ISparklineContainer	Interface that supports creating a model that represents a sparkline.
	ISparklineGroup	Interface that supports creating a group of sparklines.
	ISparklineRenderer	Interface that supports creating a renderer for painting sparklines.
	ISparklineSetting	Interface that supports creating a setting for sparklines.
	IStopablePrePaintConditionalFormattingRule	Represents the conditional formatting rule that is used before starting to paint the background and can stop all following conditional formatting rules.

Structures

	Structure	Description
	Keystroke	Represents a key being typed on the keyboard. It contains both a character code for the key and a modifier (Alt, Ctrl, Shift, or a combination).
	ListBase.Enumerator<T>	Enumerates the elements of a ListBase<T>.

Delegates

	Delegate	Description
	ActiveSheetChangingEventHandler	Represents a defined method that handles the ActiveSheetChanging event for the Spread component.
	AdvanceEventHandler	Represents a defined method that handles the Advance event for the Spread component.
	AnnotationModeEndingEventHandler	Represents a defined method that handles the AnnotationModeEnding event for the Spread component.
	AnnotationModeStartingEventHandler	Represents a defined method that handles the AnnotationModeStarting event for the Spread component.
	AutoFilteredColumnEventHandler	Represents a defined method that handles the AutoFilteredColumn event for the Spread component.
	AutoFilteringColumnEventHandler	Represents a defined method that handles the AutoFilteringColumn event for the Spread component.
	AutoSortedColumnEventHandler	Represents a defined method that handles the AutoSortedColumn event for the Spread component.
	AutoSortingColumnEventHandler	Represents a defined method that handles the AutoSortingColumn event for the Spread component.
	BeforeSettingPropertyValueHandler	Represents a defined method that handles the BeforeSettingPropertyValue event.
	CalculateExceptionHandler	Represents a defined method that handles the CalculateException event.
	CellClickEventHandler	Represents a defined method that handles the CellClick and CellDoubleClick events for the Spread component.
	CellErrorTextEventHandler	Represents a defined method that handles the error text change event for the Spread component.
	ChangeEventHandler	Represents a defined method that handles the Change event for the Spread component.
	ChildControlEventHandler	Represents a defined method that handles the child control related events for the Spread component.
	ChildViewCreatedEventHandler	Represents a defined method that handles the ChildViewCreated event for the Spread component.
	ChildWorkbookCreatedEventHandler	Represents a defined method that handles the ChildWorkbookCreated event for the Spread component.
	ClearGroupEventHandler	Represents the method that handles an event after the group is cleared.
	ClipboardPastedEventHandler	Event handler for ClipboardPasted event.
	ClipboardPastingEventHandler	Represents a defined method that handles the ClipboardPasting event for the Spread component.
	ColumnViewportWidthChangedEventHandler	Represents a defined method that handles the ColumnViewportWidthChanged event for the Spread component.
	ColumnWidthChangedEventHandler	Represents a defined method that handles the ColumnWidthChanged event for the Spread component.
	ColumnWidthChangingEventHandler	Represents a defined method that handles the ColumnWidthChanging event for the Spread component.
	ConditionalFormattingChangedEventHandler	Represents a method that handles the conditional formatting Changed events.
	CustomNameEventHandle	Represents a method that handles the custom name events.
	DataColumnConfigureEventHandler	Represents a defined method that handles the DataColumnConfigure event for the Spread component.
	DialogCharEventHandler	Represents the method that handles the DialogChar event of a Spread component.
	DialogKeyEventHandler	Represents the method that handles the DialogKey event of a Spread component.
	DragDropBlockCompletedEventHandler	Represents a defined method that handles the DragDrop event for the Spread component.
	DragDropBlockEventHandler	Represents a defined method that handles the DragDropBlock event for the Spread component.
	DragFillBlockCompletedEventHandler	Represents a defined method that handles the DragFillBlockCompleted event for the Spread component.
	DragFillBlockEventHandler	Represents a defined method that handles the DragFillBlock event for the Spread component.
	DragMoveCompletedEventHandler	Represents a defined method that handles the ColumnDragMoveCompleted or RowDragMoveCompleted event for the Spread component.
	DragMoveEventHandler	Represents a defined method that handles the ColumnDragMove or RowDragMove event for the Spread component.
	EditErrorEventHandler	Represents a defined method that handles the EditError events for the Spread component.
	EditModeStartingEventHandler	Represents a defined method that handles the EditModeStarting event for the Spread component.
	EditorNotifyEventHandler	Represents a defined method that handles the ButtonClicked, ComboCloseUp, ComboDropDown, ComboSelChange, and EditChange events for the Spread component.
	EnterCellEventHandler	Represents a defined method that handles the EnterCell event for the Spread component.
	ErrorEventHandler	Represents a defined method that handles the Error events for the Spread component.
	ExpandEventHandler	Represents a defined method that handles the Expand event for the Spread component.
	FilterBarClickEventHandler	Represents a defined method that handles the CellClick and CellDoubleClick events for the Spread component.
	FpScrollBarButtonClickEventHandler	Represents a defined method that handles the FpScrollBarButtonClickEventArgs event for the Spread component.
	GetCustomIconHandler	The delegate for measuring size of an icon for the icon conditional formatting rule in a cell.
	GroupingEventHandler	Represents a defined method that handles the Grouping event in the Spread component.
	HyperLinkClickedEventHandler	Represents a defined method that handles the HyperLinkClicked event for the Spread component.
	ItemEventHandler	Represents the method that handles an event after the item is operated on.
	LeaveCellEventHandler	Represents a defined method that handles the LeaveCell event for the Spread component.
	LeftChangeEventHandler	Represents a defined method that handles the LeftChange event for the Spread component.
	ListBase.ListChangedEventHandler<T>	Represents the method that will handle the ListBase<T>.ListChanged event of the ListBase<T> class.
	NamedStyleCollectionEventHandler	Represents a defined method that handles the NamedStyleCollection object's Changed event.
	NoteEventHandler	Represents a method that handles the note events.
	PaintGrayAreaEventHandler	Represents a defined method that handles the PaintBackground event for the Spread component.
	PaintGroupBarBackgroundEventHandler	Represents a defined method that handles the PaintGroupBarBackground event in the Spread component.
	PaintTabStripButtonEventHandler	Represents a defined method that handles the PaintTabStrip event for the Spread component.
	PaintTabStripEventHandler	Represents a defined method that handles the PaintTabStrip event for the Spread component.
	PaintTabStripTabEventHandler	Represents a defined method that handles the PaintTabStripTab event for the Spread component.
	PreviewRowFetchEventHandler	Represents a defined method that handles the PreviewRowFetch event for the Spread component.
	PrintAbortEventHandler	Represents a defined method that handles the PrintAbort event for the Spread component.
	PrintBackgroundEventHandler	Represents a defined method that handles the PrintBackground event for the Spread component.
	PrintCancelledEventHandler	Represents a defined method that handles the PrintCancelled event for the Spread component.
	PrintDocumentEventHandler	Represents a defined method that handles the PrintDocument event for the Spread component.
	PrintHeaderFooterAreaEventHandler	Represents a defined method that handles the PrintHeaderFooterArea event for the Spread component.
	PrintMessageBoxEventHandler	Represents a defined method that handles the PrintMessageBox event for the Spread component.
	PrintPreviewShowingEventHandler	Represents a defined method that handles the PrintPreviewShowing event for the Spread component.
	PropertyTrackChangedEventHandler	Represents an event handler which is raised when the property has changed and has infomation about the current value and the previous value.
	QueryValueHandler	Represents a defined method that handles the QueryValue event.
	RangeGroupModelEventHandler	Handles the Changed event for the outline (range group) model for the sheet.
	RangeGroupStateChangedEventHandler	Represents a defined method that handles the RangeGroupStateChanged event for an outline (range group) of the Spread component.
	RangeGroupStateChangingEventHandler	Represents a defined method that handles the RangeGroupStateChanging event for an outline (range group) of the Spread component.
	ReloadSheetCellRangeEventHandler	Represents the event handler for the FormulaChanged event, which occurs when an object that contains the sheet cell ranges notifies that formulas have been changed and that the SheetCellRange needs to be updated.
	RowErrorTextEventHandler
	RowHeightChangedEventHandler	Represents a defined method that handles the RowHeightChanged event for the Spread component.
	RowHeightChangingEventHandler	Represents a defined method that handles the ColumnWidthChanging event for the Spread component.
	RowViewportHeightChangedEventHandler	Represents a defined method that handles the RowViewportHeightChanged event for the Spread component.
	ScrollTipFetchEventHandler	Represents a defined method that handles the ScrollTipFetch event for the Spread component.
	SelectionChangedEventHandler	Represents a defined method that handles the SelectionChanged events for the Spread component.
	SelectionChangingEventHandler	Represents a defined method that handles the SelectionChanging events for the Spread component.
	SheetTabClickEventHandler	Represents a defined method that handles the SheetTabClick event for the Spread component.
	SheetTabDoubleClickEventHandler	Represents a defined method that handles the SheetTabDoubleClick event for the Spread component. which occurs when the user double-clicks the mouse button with the pointer on the sheet name tab.
	SheetViewEventHandler	Represents a method that handles the sheet events.
	SheetViewPropertyChangeEventHandler	Represents a defined method that handles sheet property change events.
	SparklineModelEventHandler	Represents the event handler for the UpdatedCellRanges event, which occurs when an object that contains the sheet cell ranges notifies that formulas have been changed and that the SheetCellRange needs to be updated.
	StickyNoteEventHandler	Obsolete. Use NoteEventHandler instead. Represents a method that handles the sticky note events.
	StyleContainerEventHandler	Internal use only.
	SubEditorClosedEventHandler	Represents a defined method that handles the SubEditorClosed event for the Spread component.
	SubEditorOpeningEventHandler	Represents a defined method that handles the SubEditorOpening event for the Spread component.
	TextTipFetchEventHandler	Represents a defined method that handles the TextTipFetch event for the Spread component.
	TopChangeEventHandler	Represents a defined method that handles the TopChange event for the Spread component.
	UserFormulaEnteredEventHandler	Represents a defined method that handles the UserFormulaEntered event for the Spread component.
	UserZoomingEventHandler	Represents a defined method that handles the UserZooming event for the Spread component.

Enumerations

	Enumeration	Description
	AutoFilterMode	Specifies settings for the automatic filter.
	BorderCollapse	Specifies how the borders of adjacent cells are displayed in the view.
	BoundaryFeedbackMode	Specifies how FpSpread reacts when the manipulation has gone beyond certain boundaries.
	ButtonDrawModes	Specifies how to display buttons in cells for button and combo box cell types.
	CalculationPolicy	Indicates the policy of the calculation controller.
	CellHorizontalAlignment	Specifies the horizontal alignment of the cell contents.
	CellRangeType	Represents CellRange Type
	CellVerticalAlignment	Specifies the vertical alignment of the cell contents.
	Centering	Specifices the type of centering for the printed page.
	ChangeType	Specifies the type of change (of movement of) the scroll bar button.
	ClipboardCopyOptions	Specifies what data is copied to the Clipboard.
	ClipboardOptions	Specifies which headers are included when data is copied to or pasted from the Clipboard.
	ClipboardPasteOptions	Specifies what data is pasted from the Clipboard.
	CollectionEditorOptions	Specifies which UITypeEditor to invoke directly at runtime.
	ComparisonOperator	Specifies the operator for conditional formats.
	ConditionalFormattingChangedEventType	Specifies the type of Changed event that has occurred for conditional formatting.
	ConditionalFormattingIcon	The predefined icon for conditional formatting.
	ConditionalFormattingIconSetStyle	Represents the style of the icon set.
	ConditionalFormattingModelEventType	Specifies the type of Change event that has occurred for a conditional formatting model for the sheet.
	ConditionalFormattingValueType	Represents the value type of the conditional formatting.
	CursorType	Specifies the area of the component in which to display a specific pointer.
	CustomFilterOperatorType	Specifies the operator for custom filtering.
	CustomNameChangeAction	Specifies how to process the data when a custom name changes.
	DataBarAxisPosition	Represents the axis position for the data bar.
	DateTimeGroupingType	Specifies the part of the date time value used in a comparision.
	DragFillMode	Specifies the type of DragFill mode.
	DynamicFilterType	Specifies a value that indicates the type of dynamic filter.
	EditError	Specifies the possible editor messages based on the user action.
	EnhancedFilterSortingMode	Specifies settings for sorting item in enhanced filter.
	EnhancedInterfaceRenderer.ButtonStyles	Specifies the button style.
	EnhancedInterfaceRenderer.SheetTabShape	Specifies the shape of sheet tabs.
	FillDirection	Specifies the direction of the filling of cells.
	FilterListBehavior	Specifies how the row filter behaves.
	FilterState	Specifies the state of filtering for the current column so the column renderer knows which filtering image to draw.
	FlagArrowKeys	Defines the moving active cell while editing cell enumeration.
	GridLines	Specifies whether horizontal or vertical grid lines or both are displayed on the sheet.
	GridLineType	Specifies the type of grid lines.
	GroupState	Specifies the status of an outline (range group).
	HeaderAutoText	Specifies the default labels to display in headers.
	HitTestType	Specifies the locations in the component for the HitTest method.
	HorizontalPosition	Specifies the horizontal position of the cell or column in the component.
	InputDeviceType	Indicates the input device type.
	InputMapMode	Specifies the condition for which an input map applies.
	NamedStyleCollectionEventType	Specifies the type of change event that has occurred for the style in the collection.
	NonEmptyItemFlag	Specifies the type of contents of a cell.
	NoteIndicatorPosition	Specifies the position of the cell note indicator.
	NoteStyle	Specifies how the cell notes are displayed.
	OperationMode	Specifies how the sheet responds to user interaction and what selections are allowed.
	PdfWriteMode	Specifies the output mode for printing the sheet as PDF.
	PdfWriteTo	Specifies the output for printing the sheet as PDF.
	PrintDocumentEventType	Represents the type of PrintDocument event which occurs during the print process of the sheetview.
	PrintHeader	Specifies whether the header is printed.
	PrintNotes	Specifies how cell notes are printed.
	PrintOrientation	Specifies the page orientation used to print the sheet.
	PrintPageOrder	Specifies the order in which pages are printed.
	PrintTitle	Specifies whether the title is printed.
	PrintType	Specifies the type of print range used to print the sheet.
	RangeGroupButtonStyle	Specifies the button style for an outline (range group) of rows or columns.
	RangeGroupInfoEventType	Specifies the type of Change event that has occurred for the outline (range group) model for the sheet.
	RangeGroupModelEventType	Specifies the type of change that has occurred for an outline (range group) for the sheet.
	RegularBoldItalicFontStyle	Specifies whether regular, bold, or italic font styles are applied to the text.
	ResetOption	Specifies whether the rules or a particular rule should reset before testing the next rule.
	ResizeZeroIndicator
	RowSelectorState	Specifies the state of the row header selector for the current selected row, so the row renderer knows which row header selector image to draw.
	ScaleMode	Specifies the type of DPI scale support.
	ScrollBarButtons	Specifies the type of scroll bar buttons by specifying which elements of the scroll bar are displayed.
	ScrollBarPolicy	Specifies when the component displays the scroll bars.
	ScrollBarTrackPolicy	Specifies whether the component scrolls the sheet when the user moves the scroll box.
	ScrollingContentRowNumberPolicy	Specifies how to display the current row number in scrolling content.
	ScrollTipPolicy	Specifies whether the component displays the text tip when the user moves the scroll box.
	SearchFoundFlags	Specifies where the search string is found.
	SelectionBlockOptions	Specifies which part of the sheet can be selected by the user.
	SelectionStyles	Specifies the style for the display of selected cells.
	SheetView.ImageLayout	Specifies the position of the image on viewport.
	SortState	Specifies the state of sorting for the current column so the column renderer knows which sorting image to draw.
	SparklineAxisMinMax	An enumeration that specifies information about how the vertical axis minimum or maximum is computed for this sparkline group.
	SparklineType	Represents the type of sparkline.
	SplitBoxAlignment	Specifies the placement of split boxes in the component with respect to their alignment with the scroll bars.
	SplitBoxPolicy	Specifies when the component displays the split boxes.
	SpreadPanningMode	Specifies how FpSpread reacts to touch manipulation.
	StrikeoutFontStyle	Specifies whether the strikeout font style is applied to the text.
	StyleContainerEventType	Internal use only.
	TabStripButton	Specifies the sheet tab buttons.
	TabStripButtonPolicy	Specifies the display policy for the tab strip buttons.
	TabStripPlacement	Specifies the location of the tab strip in the component.
	TabStripPolicy	Specifies when the component displays the sheet name tabs.
	TextConditionOperator	Represents operators applied for text conditional formatting.
	TextFileFlags	Specifies how to process the data when saving to a text file.
	TextTipPolicy	Specifies how the the text tip of a cell in the view is displayed, and also how the cell note is displayed.
	TimePeriod	Represents a time period which is used in a date conditional formatting rule. These are dynamic time periods, which change based on the date the conditional formatting rule is refreshed or applied.
	TouchStripShowingArea	Specifies what area to display the SpreadTouchStrip.
	UnaryComparisonOperator	Represents the unary comparison operator.
	UnderlineFontStyle	Specifies whether the underline font style is applied to the text.
	VerticalPosition	Specifies the vertical position of the cell or row in the component.

Remarks

For a list of the namespaces of this assembly, refer to the FarPoint.Win.Spread assembly.

For the list of assemblies for this product, refer to the Assembly Reference.

For more information on using these classes, refer to the Developer's Guide.

Classes

Interfaces

Structures

Delegates

Enumerations

Remarks

See Also

Reference

User-Task Documentation

Spread Windows Forms 7.0 Product Documentation
FarPoint.Win.Spread Namespace
See Also Inheritance Hierarchy Support Options