| 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. |
| AppearanceActionBase | Represents a special implementation that displays UI elements on the validating cell. |
| AppearanceStyleCollection | Represents a collection of AppearanceStyleInfos. |
| AppearanceStyleInfo | Represents the set of cell style settings for the validation. |
| 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. |
| BaseFilterItem | Represents the basis for a custom filter. |
| BaseSparkline | Base class that represents sparkline data infomation. |
| BeforeRightClickEventArgs | Provides data for the UIManager.BeforeRightClick events. |
| 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. |
| CellPadding | Represents padding information associated with a cell. |
| Cells | Represents a two-dimensional collection of Cell objects. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| ConditionalStyleItem |
|
| ConditionalStyleItemCollection | Represents the ConditionalStyleItem collection. |
| 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 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. |
| DataValidationManager | Represent a data validation manager that supports data validation. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| FormulaTextBox | Represents the floating formula editor. |
| FpBaseStatusBarElement | Represents the basis for all status bar elements. |
| FpHorizontalScrollBar | Represents the Spread horizontal scroll bar. |
| FpScrollBar | Represents the Spread scroll bar. |
| 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. |
| 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. |
| 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. |
| 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. |
| FpStatusBarRangeStatusFormatElement | Represents the element of status bar handling the change of selection ranges in activesheetview and formating the displayed text. |
| 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. |
| 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. |
| 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. |
| 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.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. |
| ModelessTextBox | ModelessTextBox |
| MultiValuesFilterItem | Provides a Filters class to filter items using a criteria values list. |
| NameBox | Represents the custom name texbox. |
| NamedAppearanceStyleInfo | |
| 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 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. |
| PairChar | Represents a character pair. |
| PairCharValidator | Represents a special BaseDataValidator that validates whether the specifed value matches the given PairChars. |
| 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. |
| 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. |
| 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 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. |
| 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. |
| 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. |
| 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. Represents an individual sheet in the Spread component. Represents an individual sheet in the Spread component. Represents an individual sheet in the Spread component. 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. |
| SlicerInsertForm | |
| SlicerSettingsForm | |
| 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. |
| 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. |
| 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 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. |
| StatusBarDefaultSkin | Read-only collection of default (built-in) skins. |
| 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. |
| TableElementStyle | Represents a style for each element of the table. |
| 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. |
| 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. |
FarPoint.Win.Spread Namespace
In This Topic
Provides the base classes, interfaces, enumerations, and event handlers for the Spread for Windows Forms spreadsheet component.
Classes
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. |
| 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. |
| 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. |
| 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 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. |
| 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. |
| 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. |
| 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 | |
|---|---|---|
 | 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. |
| 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. |
| 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 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. |
| 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 cell or column in the component. |
| 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. |
| 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. |
| 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. |
| 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 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.
See Also