FarPoint.Win.Spread Namespace

In This Topic

Classes

	Class	Description
	Action	Abstract class used to implemented actions. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
	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.
	AlignmentFormatComment
	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.
	AppearanceActionBase	Represents a special implementation that displays UI elements on the validating cell. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
	AppearanceStyleCollection	Represents a collection of AppearanceStyleInfos. This class cannot be inherited.
	AppearanceStyleInfo	Represents the set of cell style settings for the validation.
	ApplyEventArgs	Internal use only. Represents the event data for the apply event.
	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.
	BaseDataValidator	Represents a data BaseDataValidator. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
	BaseFilterItem	Represents the basis for a custom filter. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
	BaseSparkline	Base class that represents sparkline data infomation. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
	BeforeRightClickEventArgs	Provides data for the UIManager.BeforeRightClick events. This class cannot be inherited.
	BeforeSettingPropertyValueEventArgs	Represents before setting property value event arguments.
	BeforeShowContextMenuEventArgs	Represents the event data for the BeforeShowContextMenu event for the Spread component, which occurs when the user open the enhanced filter context menu.
	BestFitColumnRule	Represents the rules that determine how best to print the columns.
	BetweenValuesConditionalFormattingRule	Represents a conditional formatting rule that accepts 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.
	CellInfo	Represents the value and formatting for a cell.
	CellInfoRange	Represents a two-dimensional collection of cell information objects.
	CellPadding	Represents padding information associated with a cell.
	Cells	Represents a two-dimensional collection of Cell objects.
	CellsEditorForm	Represents a cells editor form.
	CellStyleNotify	Represents a special AppearanceActionBase that displays the InvalidCellStyle on the validating cell if the validation fails.
	CellTouchStrip	Represent a special SpreadTouchStrip that pops up in the cell area.
	CellValidateInfoNeededEventArgs	Provides data for the FpSpread.CellValidateInfoNeeded event.
	ChangeEventArgs	Represents the event data for the Change event for the Spread component, which occurs when a cell changes.
	CharFormatValidator	Represents settings used to check if the text is in a specified format.
	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.
	CircularCellChangedEventArgs	Specifies the event argument for the CircularCellChanged event. This class cannot be inherited.
	CircularFormulaEventArgs	Specifies EventArgs for the CircularFormula event.
	CircularFormulaEventInfo	Specifies the circular cell information.
	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.
	ColumnClipInfo	Represents the information for a column (not including the value or style information).
	ColumnClipInfoRange	Represents a one-dimensional collection of ColumnClipInfo objects.
	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 is displayed 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.
	CombinedStyleInfo	Represents a special AppearanceStyleInfo that combines several cell style effects to generate a new CellStyle object. This class cannot be inherited.
	CompareCellValidator	Represents a special CompareValueBaseValidator that validates whether the specified value and target Cell's value meet the given comparison criteria.
	CompareStringValidator	Represents a special CompareStringValidator that validates that the specified value matches the compared string using the CompareStringValidatorOperator.
	CompareValueBaseValidator	Represents a special BaseDataValidator implementation that validates whether the specified and compared values satisfy the given comparison relationship. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
	CompareValueValidator	Represents a special CompareValueBaseValidator that validates whether the specified value and the ComparedValue meet the given comparison criteria.
	ComplexSortInfo	Represents information related to sorting columns, rows, or a range of cells.
	ConditionalFormat	Represents a conditional format.
	ConditionalFormatCollection	Internal use only.
	ConditionalFormatInfo	Internal use only.
	ConditionalFormatting	Represents a conditional format. This class cannot be inherited.
	ConditionalFormattingChangedEventArgs	Represents the event data for the Changed event of conditional formatting.
	ConditionalFormattingColorValue	Represents a color conditional formatting value. This class cannot be inherited.
	ConditionalFormattingColorValueCollection	Represents a collection of conditional formatting color values.
	ConditionalFormattingIconRuleSet	Represents a set of icons which are used for an icon conditional formatting rule.
	ConditionalFormattingIconSetIndex	Represents the structure that specifies an icon for conditional formatting.
	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. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
	ConditionalFormattingRulePropertyChangedEventArgs	Provides data for the IConditionalFormatting.PropertyChanged event.
	ConditionalFormattingUtils	Represents the collection function used for conditional formatting.
	ConditionalFormattingValue	Represents a complex value of a conditional formatting rule.
	ConditionalFormattingValueCollection	Represents a collection of conditional formatting values.
	ConditionalStyleInfo	Represents a special AppearanceStyleInfo that can customize the style using the specified condition. This class cannot be inherited.
	ConditionalStyleItem	Represents a condition that when matched by a Cell, applies the specified CellStyle to the Cell.
	ConditionalStyleItemCollection	Represents the ConditionalStyleItem collection. This class cannot be inherited.
	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. This class cannot be inherited.
	CustomImageInfo	Represents a complex identification for custom images. This class cannot be inherited.
	CustomNameChangedEventArgs	Represents the data for changes to the custom name.
	DataAddNewException	Represents an exception that is 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.
	DataFieldConverter	Represents a type converter for the data field of a column.
	DataValidationManager	Represent a data validation manager that supports data validation. This class cannot be inherited.
	DataValidationNote	Class DataValidationNote
	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. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
	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. This class cannot be inherited.
	DefaultSparklineContainer	Represents the full (concrete) implementation of the ISparklineContainer interface for a sparkline model for a sheet, which represents sparklines.
	DefaultSpreadSkin	Contains default renderer, style setting that will be used in case spread doesn't define them This class cannot be inherited.
	DefaultSpreadSkins	Represents the read-only collection of default (built-in) Spread skins. This class cannot be inherited.
	DefaultStyleCollection	Represents the read-only collection of default NamedStyle objects. This class cannot be inherited.
	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.
	DocumentPropertiesForm
	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.
	DynamicStyleInfo	Represents a special AppearanceStyleInfo that is used to customize a AppearanceStyleInfo under the DynamicStyleInfoContext class.
	DynamicStyleInfoContext	Provides context information for customizing a DynamicStyleInfo object.
	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.
	EncodingValidator	Represents a special EncodingValidator that validates the text based on the specified encoding.
	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. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
	EventNameConverter	Converter for EventName
	ExcelBaseSparkLineRenderer	Abstract class that represents the renderer of the Excel-like sparklines. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
	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.
	ExcludeListValidator	Represents a special BaseDataValidator that validates whether the specified value does not exist in the given Candidates list.
	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).
	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.
	FilterBarCell	Represents a cell in the filter bar of the sheet view.
	FilterBarCellCollection	Represents all cells in the filter bar of the sheet view.
	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.
	FlatFocusIndicatorRenderer	Represents the renderer for drawing the border around the active cell (that has focus).
	FlatInterfaceRenderer	Represents the painter of the visual elements with Excel2013 style.
	FlatScrollBarRenderer	Represents the renderer that paints the the scroll bar with the flat skin.
	FlatSelectionRenderer	Represents the default selection renderer.
	FocusProcess	Represents a special ValidateActionBase that keeps the focus on the validating Cell when validation fails.
	FormatCells	Represents the format cell dialog.
	FormulaConditionalFormattingRule	Represents the conditional formatting rule that uses a formula to determine which cells to format before starting to paint the background.
	FormulaEditorUI	Internal use only. Represents the user interface for the Formula Editor.
	FormulaProvider	Represents a way to provide a formula property (and trigger event) to any control on the form.
	FormulaTextBox	Represents the floating formula editor.
	FpBaseStatusBarElement	Represents the basis for all status bar elements. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
	FpHorizontalScrollBar	Represents the Spread horizontal scroll bar.
	FpScrollBar	Represents the Spread scroll bar. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
	FpScrollBarButton	Represents the Spread scroll bar button.
	FpScrollBarButtonBackwardHome	Represents a Spread scroll bar backward-to-home button.
	FpScrollBarButtonBackwardLine	Represents a Spread scroll bar back-by-line button.
	FpScrollBarButtonBackwardPage	Represents a Spread 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 elements for the Spread scroll bar. This class cannot be inherited.
	FpScrollBarButtonForwardEnd	Represents a Spread scroll bar forward-to-end button.
	FpScrollBarButtonForwardLine	Represents a Spread scroll bar forward-by-line button.
	FpScrollBarButtonForwardPage	Represents a Spread scroll bar page forward button.
	FpScrollBarComboThumb	Represents a combination of the backward track, forward track, and thumb of the scroll bar.
	FpScrollBarGripper	Represents the Spread scroll bar grip.
	FpScrollBarThumb	Represents a Spread scroll bar thumb.
	FpScrollBarTrack	Represents a Spread scroll bar track. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
	FpScrollBarTrackBackward	Represents the backward track of the Spread scroll bar.
	FpScrollBarTrackForward	Represents the forward track of the Spread scroll bar.
	FpSpread	Represents the Spreadsheet component.
	FpStatusBar	Represents the status bar control.
	FpStatusBarAverageElement	Represents the status bar element that displays the average of the selected cells.
	FpStatusBarCountElement	Represents the status bar element that displays the number of selected cells that contain data.
	FpStatusBarElementCollection	Represents the collection of status bar elements.
	FpStatusBarMaxElement	Represents the status bar element that displays the maximum value of the selected cells.
	FpStatusBarMinElement	Represents the status bar element that displays the minimum value of the selected cells.
	FpStatusBarNumericalCountElement	Represents the status bar element that displays the number of numeric cells in the selection.
	FpStatusBarRangeStatusElement	Represents the element of status bar handling the change of selection ranges in activesheetview. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
	FpStatusBarRangeStatusFormatElement	Represents the element of status bar handling the change of selection ranges in activesheetview and formating the displayed text. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
	FpStatusBarSumElement	Represents the status bar element that displays the sum of selected cells.
	FpStatusBarTextElement	Represents the text element of the status bar.
	FpVerticalScrollBar	Represents the Spread vertical scroll bar.
	GetCustomIconEventArgs	Represents 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. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
	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 hyperlink cell is clicked.
	HyperlinkForm
	IconFilterItem	Provides an IconFilter class to filter cells using an icon specified in the filter criteria.
	IconNotify	Represents a special AppearanceActionBase that displays an error icon for the validating cell when validation fails.
	IconSetConditionalFormattingRule	Represents the rule that paints an icon in the cell.
	ImageFocusIndicatorRenderer	Represents the renderer of the image focus indicator.
	IncludeListValidator	Represents a special BaseDataValidator that validates whether the specified value exists in the given Candidates list.
	InputMap	Represents the map between input by the user and the action that occurs.
	InputScreenTipDialog
	InputTextDialog	Represents the text input dialog.
	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.
	LineNotify	Represents a special AppearanceActionBase that displays an underline in the validating cell when validation fails.
	LineSparklineRenderer	Represents the line sparkline renderer.
	ListBase<T>	Represents a strongly typed list of objects that can be accessed by index. Provides methods to search, sort, and manipulate lists.
	ListBase.ListChangedEventArgs<T>	Provides data for the System.ComponentModel.IBindingList.ListChanged event.
	MarqueeFocusIndicatorRenderer	Represents the renderer of the marquee (or animated) focus indicator.
	MessageBoxNotify	Represents a special ValidateActionBase that can display a message when cell validating fails.
	ModelessForm	Represents an abstract modeless form which allow user to select cell ranges from Spread.
	ModelessTextBox	ModelessTextBox
	MultiColorScaleConditionalFormattingRule	Represents the color scale conditional formatting rule with multiple middle values.
	MultiValuesFilterItem	Provides a Filters class to filter items using a criteria values list.
	NameBox	Represents the custom name texbox.
	NamedAppearanceStyleInfo	Represents a special AppearanceStyleInfo that can define a cell style with the name. This class cannot be inherited.
	NamedObjectCollection<T>	Represents the strongly typed INamedObject object collection.
	NamedStyle	Represents a custom style, an object that can be used to set style information for other objects.
	NamedStyleCollection	Represents a collection of custom styles (NamedStyle objects).
	NamedStyleCollectionEventArgs	Represents the event data for the NamedStyleCollection object's Changed event.
	NoPrinterPrintInfo
	NoteEventArgs	Represents the data for the note event.
	OwnerPrintInfo	Represents the printing information for OwnerPrintDraw.
	PageSetup	Internal use only. Represents the printing page setup dialog.
	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.
	PairChar	Represents a character pair.
	PairCharValidator	Represents a special BaseDataValidator that validates whether the specifed value matches the given PairChars.
	ParentStyleNameConverter	Provides a drop-down list of parent style names for the ParentStyleName property in the Cell, Column, Row, and AlternatingRow classes.
	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.
	PropertyComboBoxType
	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>	Represents 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.
	RangeValidator	Represents a special BaseDataValidator that validates whether the specified value is between the range specified by MinValue and MaxValue.
	RecentItemsEventArgs<T>	Provides data for querying recent items event.
	RegularExpressionValidator	Represents a special BaseDataValidator that validates whether the specifed value matches the given regular expression.
	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.
	RequiredFieldValidator	Represents a special BaseDataValidator class that can validate whether the specified value is not a null reference (Nothing in Visual Basic).
	RequiredTypeValidator	Represents a special BaseDataValidator class that validates whether the specified value's System.Type is equal to the RequiredType.
	ResolveActionEventArgs	Provides data for FpSpread.ResolveAction event. This class cannot be inherited.
	ResolveCustomControlEventArgs	Provides data for FpSpread.ResolveCustomControl event. This class cannot be inherited.
	Row	Represents a row in the component.
	RowClipInfo	Represents the information for a row (not including the value or style information).
	RowClipInfoRange	Represents a one-dimensional collection of RowClipInfo objects.
	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 is displayed 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.
	SaveNamedStyleCollection	Represents a saved named style collection object.
	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.
	ShapeClipboardObject	Internal use only.
	ShapeTouchStrip	Represents a special SpreadTouchStrip which includes some common items.
	SheetCorner	Represents the corner of the control.
	SheetDragMovedEventArgs	Represents the event data for the SheetDragMoved event for the Spread component, which occurs right after the user finishes moving the sheet to another index.
	SheetDragMovingEventArgs	Represents the event data for the SheetDragMoving event for the Spread component, which occurs when the user drags the sheet tab to the destination sheet tab.
	SheetSkin	Represents a skin, which provides style settings for a sheet.
	SheetSkinsForm	Represents a sheet skin form.
	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 a container of the models that make up the sheet document. This class cannot be inherited.
	SheetView.MultipleColumnMovingException	Exception thrown when moving multiple columns.
	SheetView.MultipleRowMovingException	Exception thrown when moving multiple rows.
	SheetView.SaveAutoSortColumns	Saves the sorting settings for all columns in a 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.
	SlicerInsertForm
	SlicerSettingsForm
	SmartPaperRule	Represents the rules that determine the paper size.
	SmartPrintRule	Represents the rules that determine how best to print. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
	SmartPrintRulesCollection	Represents the set of rules that determine how best to print.
	SolidFocusIndicatorRenderer	Represents the renderer of the solid focus indicator.
	SortArgs	Represents the event data for the Sorting event for the Spread component, which occurs when Spread is being sorted.
	SortedEventArgs	Represents the event data for the Sorted event for the Spread component, which occurs when spread sorted.
	SortInfo	Represents the information related to sorting columns, rows, or a range of cells.
	SortingEventArgs	Represents the event data for the Sorting event for the Spread component, which occurs when spread is sorting.
	SortingForm
	SoundNotify	Represents a special ValidateActionBase that plays a specified system sound when validation fails.
	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 cell ranges are updated.
	SpreadActions	Represents the actions available for input maps.
	SpreadDesigntimeLicense	Represents a designtime license.
	SpreadFontStyle	Specifies the font style information applied to the text. This class cannot be inherited.
	SpreadHScrollBar	Represents the horizontal scroll bar for the view.
	SpreadRuntimeLicense	Represents a GrapeCity Spread runtime license.
	SpreadSkin	Represents the skin of the Spread component.
	SpreadSkinsForm	Represents a Spread component skins form.
	SpreadSoftwareSecureLicenseProvider	Represents the license provider for Software Secure.
	SpreadSparklineRenderes	Read-only collection of default (built-in) sparkline renderers. This class cannot be inherited.
	SpreadTouchStrip	Represents the SpreadTouchStrip for FpSpread.
	SpreadView	Represents a view of the spreadsheet display.
	SpreadViewportInfo	Represents the information about a viewport.
	SpreadVScrollBar	Represents the vertical scroll bar for the view.
	SpreadWinUIManager	The SpreadWin UIManager.
	StatusBarDefaultSkin	Read-only collection of default (built-in) skins. This class cannot be inherited.
	StatusBarElementChangeArgs	Represents the event data for element changes in the status bar.
	StatusBarSkin	Skin of status bar
	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.
	SurrogateCharValidator	Represents a special BaseDataValidator that validates whether the specified value exists in surrogate characters.
	TableBorder	Represents Table border. This class cannot be inherited.
	TableElementStyle	Represents a style for each element of the table. This class cannot be inherited.
	TablePropertyChangedEventArgs	Represents table property changed event arguments.
	TablePropertyChangingEventArgs	Class represents table property changing event arguments.
	TableStyle	Represents a style for the table.
	TableStyleCollection	Represents a table style manager.
	TableStyleCollectionChangedEventArgs	Represents table style collection changed event arguments.
	TableUtils	Represents a util class for spread table.
	TableView	Represents spread table.
	TableViewClipboardInfo	Represents a TableView's data structure in the clipboard.
	TableViewColumn	Represents a column in the table.
	TableViewColumnCollection	Represents a one-dimensional collection of Column objects in a table.
	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.
	TextLengthValidator	Represents a special TextLengthValidator that validates the length of the specified value using the LengthUnit setting.
	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.
	ThreeStateIconNotify	Represents a special ValidateActionBase that can display a valid icon or invalid icon when cell validating succeeds or fails.
	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).
	TipNotify	Represents a special ValidateActionBase that shows a tool tip for the validating Cell when validation fails.
	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.
	ValidateActionBase	Provides the capability to execute certain actions if a Cell value fails to validate. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
	ValidateActionCollection	Represents a ValidateActionBase collection.
	ValidateActionContext	Provides relative context information when the BaseValidationAction executes.
	ValueProcess	Represents a special ValidateActionBase that processes the value when validation fails.
	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.
	ZoomSliderStatusBarElement	Represents the status bar element that displays the zoom slider with the zoom out and zoom in buttons.
	ZoomStatusBarElement	Represents the status bar element that displays the zoom level.

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.
	IApplyEvents	Internal use only. Interface that supports apply events in Spread Designer.
	IConditionalFormatSupport	Interface that supports conditional formatting of cells on a sheet.
	IConditionalFormatSupport2	Interface that supports conditional formatting of cells on a sheet.
	IConditionalFormattingModel	Represents the conditional formatting model for a sheet.
	IConditionalFormattingRule	Represents a conditional formatting rule.
	ICustomizeActiveTabColor	Interface that defines the methods and properties required by objects used as customization of the color of active sheet tab.
	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.
	IFeatures	Represents all customizable features of FpSpread.
	IFilteredRowSupport	Interface that supports style filters in the style model for filtering rows on a sheet.
	IFilteredRowSupport2	Interface that supports style filters in the style model for filtering rows on a sheet.
	IFilteredRowSupport3	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.
	IFocusIndicatorRenderer2	Interface that supports painting the focus indicator using a specified control and dimensions for Touch gripper support.
	IFormulaEditingSupport	Indicates whether the cell editor can handle formula input.
	IFormulaEditingSupport2	Indicates whether the cell editor can handle formula input. With runtime check
	IFpStatusBar	Interface for the status bar.
	IFpStatusBarElement	Interface for the status bar elements.
	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.
	IManualRowFilterSupport	Interface that supports to not filtering automatically when there is a cell change.
	INamedObject
	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.
	INoteIndicatorRenderer4
	INotifyDataChanged	Interface that supports the form noitify the data has changed.
	INotifyItemChanged	Interface that notifies Spread when the item is changed.
	IOptimizedFilterConditionalFormattingModel	Interface that supports additional optimization in the conditional formatting model beyond IOptimizedFilterConditionalFormattingModel.
	IOptimizedFilterConditionalFormattingModel1	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.
	IRangeGroupModel	Interface that supports creating a model that represents an outline (range group) of rows or columns.
	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.
	ISheetViewInitializer	The sheetview initializer interface. Internal use only.
	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).
	LinearRange	Represent a range in one-dimension which is defined by the start index and end index.
	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.
	ApplyEventHandler	Internal use only. Handles the apply event.
	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 a cell.
	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.
	CircularCellChangedEventHandler	The handler for the CircularCellChanged event.
	CircularFormulaEventHandler	The handler for the Spread CirculaFormula event.
	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.
	DynamicCellStyleConditionHandler	Represents a method that returns a AppearanceStyleInfo with the specified DynamicStyleInfoContext.
	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.
	ElementChangeHandler	Represents a defined method that handles the element changing event for the status bar.
	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	Represents 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.
	RecentItemsEventHandler<T>	Represents a method that handles the FpSpread.QueryRecentItems event of an FpSpread.
	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	Represents a defined method that handles the error text change event for a row.
	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.
	SheetDragMovedEventHandler	Represents a defined method that handles the SheetDragMoved event for the Spread component.
	SheetDragMovingEventHandler	Represents a defined method that handles the SheetDragMoving event 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.
	SortedEventHandler	Represents a defined method that handles the Sorted event for the Spread component.
	SortingEventHandler	Represents a defined method that handles the Sorting event for the Spread component.
	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.
	TablePropertyChangedEventHandler	Handles the Changed event in the table.
	TablePropertyChangingEventHandler	Handles the table property changed event.
	TableStyleCollectionChangedEventHandler	The TableStyleCollectionChangedEventArgs handler.
	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
	ActionType	Represents the type of an Action.
	AnnotationMode	Represents how anonation mode works.
	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 the CellRange type.
	CellSpanSelectionPolicy	Sets the type of selection model when working with spans.
	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 (movement) of the scroll bar button.
	ClipboardBehavior	Represents the origin of the source of the Clipboard data.
	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.
	CodeDomStrategies	Represents the CodeDom strategies.
	CollectionEditorOptions	Specifies which UITypeEditor to invoke directly at runtime.
	CompareStringValidatorOperator	Defines the operators which are used to compare strings.
	ComparisonOperator	Specifies the operator for conditional formats.
	ConditionalFormattingChangedEventType	Specifies the type of Changed event that has occurred for conditional formatting.
	ConditionalFormattingIcon	Represents 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.
	ConditionalStyleOperator	Defines operators that are used to customize a ConditionalStyleInfo.
	ContextMenuType	Represents type of the context menu.
	CursorType	Specifies the area in the view in which to display a different pointer.
	CustomControlType	Represents the custom control type.
	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.
	ElementAlign	Specifies the element alignment for the status bar.
	EnhancedFilterSortingMode	Specifies settings for sorting items in an enhanced filter.
	EnhancedInterfaceRenderer.ButtonStyles	Specifies the button style.
	EnhancedInterfaceRenderer.SheetTabShape	Specifies the shape of sheet tabs.
	EnhancedShapeBehaviors	Represents optional behaviors of the enhanced shape engine.
	FillDirection	Specifies the direction of the fill in the view.
	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.
	FormatCells.FormatCellsTab	Represents the tabs of the format cell form.
	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 object for placement in the displayed portion of the sheet.
	HyperLinkTab	Represents the tabs of the hyper link form.
	InputDeviceType	Indicates the input device type.
	InputMapMode	Specifies the condition for which an input map applies.
	LegacyBehaviors	Represents options for backward compatibility.
	LengthUnit	Defines the units that are used to validate the text length.
	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.
	PreferredSizeColumnOptions	Specifies the options when getting the preferred width for the column.
	PreferredSizeRowOptions	Specifies the options when getting the preferred height for the row.
	PrintArea	option to print.
	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.
	RecentItemType	Represents the type of recent item.
	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	Specifies the appearance and the behavior of zero width Columns and zero height Rows.
	RowCol	Specifies the dimension(s) will be affected by the action.
	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.
	SaveXMLOptions	Specifies how to save spreadsheet data to an XML file.
	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.
	SortBy	Specifies the type that is sorted.
	SortingMode	The mode used to specify the sorting behavior.
	SortState	Specifies the sorting state 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.
	SpreadView.SetInputMapOption	Option to set input maps for spread (internal use only).
	StrikeoutFontStyle	Specifies whether the strikeout font style is applied to the text.
	StyleContainerEventType	Internal use only.
	SystemSoundType	Specifies a system sound type which relates to a System.Media.SystemSound.
	TableStyleCollectionChangedType	The table style changed collection type.
	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 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 when 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.
	ValidateComparisonOperator	Specifies the binary operations between the target value and the compared value when validating a cell.
	ValidateReasons	Specifies the reasons that cause an action to execute.
	ValueProcessOption	Defines the options that are used by ValueProcess.
	VerticalPosition	Specifies the vertical position of the object for placement in the displayed portion of the sheet.
	Xlf	Excel Function (XLF) defines. These values are unique identifiers used when parsing Excel Formula buffers to determine the current function being referenced.

Reference

FarPoint.Win.Spread Assembly

Product Support Forum | Print this page