Spread Windows Forms 12.0 Product Documentation
FarPoint.Win.Spread Namespace
Inheritance Hierarchy
FarPoint.Win.Spread Assembly : FarPoint.Win.Spread Namespace
Provides the base classes, interfaces, enumerations, and event handlers for the  Spread for Windows Forms spreadsheet component.
Classes
 ClassDescription
ClassRepresents an action in the component that is used for mapping to keys.
ClassRepresents an action map, which provides mappings from objects to actions.
ClassRepresents the event data for the ActiveSheetChanging event for the component, which occurs when the component changes to another active sheet.
ClassRepresents an advanced search dialog.
ClassRepresents the event data for the Advance event for the Spread component, which occurs when focus is advanced to another control.
ClassRepresents a set of style information for alternating rows in the component.
ClassRepresents a one-dimensional collection of AlternatingRow objects, which set the style information for alternating rows in the component.
ClassRepresents the renderer of the default changing (or animated) focus indicator.
ClassRepresents 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.
ClassRepresents the appearance settings for an object.
ClassRepresents a special implementation that displays UI elements on the validating cell. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
ClassRepresents a collection of AppearanceStyleInfos. This class cannot be inherited.
ClassRepresents the set of cell style settings for the validation.
ClassRepresents the event data for the AutoFilteredColumn event for the Spread component, which occurs when the column has been automatically filtered.
ClassRepresents the event data for the AutoFilteringColumn event for the Spread component, which occurs when columns are being automatically filtered.
ClassRepresents the event data for the AutoSortedColumn event for the Spread component, which occurs when the column has been automatically sorted.
ClassRepresents the event data for the AutoSortingColumn event for the Spread component, which occurs when columns are being automatically sorted.
ClassRepresents an above or below average conditional formatting rule.
ClassRepresents a data BaseDataValidator. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
ClassRepresents the basis for a custom filter. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
ClassBase class that represents sparkline data infomation. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
ClassRepresents before setting property value event arguments.
ClassRepresents the event data for the BeforeShowContextMenu event for the Spread component, which occurs when the user open the enhanced filter context menu.
ClassRepresents the rules that determine how best to print the columns.
ClassRepresents a conditional formatting rule that accepts or does not accept a value in a range.
ClassRepresents a conditional formatting rule that accepts blank or nonblank values.
ClassRepresents the event data for the CalculateException event, that contains the exception thrown when calculating the result of a formula.
ClassRepresents a cell in the Spread component.
ClassRepresents 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.
ClassProvides data for the Cell event of a FpSpread control.
ClassRepresents a footer cell.
ClassRepresents padding information associated with a cell.
ClassRepresents a two-dimensional collection of Cell objects.
ClassRepresents a special AppearanceActionBase that displays the InvalidCellStyle on the validating cell if the validation fails.
ClassRepresent a special SpreadTouchStrip that pops up in the cell area.
ClassProvides data for the FpSpread.CellValidateInfoNeeded event.
ClassRepresents the event data for the Change event for the Spread component, which occurs when a cell changes.
ClassRepresents settings used to check if the text is in a specified format.
ClassRepresents a special SpreadTouchStrip which includes some common items.
ClassRepresents the event data for the child control related events for the Spread component.
ClassRepresents the event data for a ChildViewCreated event for the Spread component, which occurs when a child sheet is created in a hierarchical spreadsheet.
ClassRepresents the event data for a ChildWorkbookCreated event for the Spread component, which occurs when a child sheet is created in a hierarchical spreadsheet.
ClassSpecifies EventArgs for the CircularFormula event.
ClassSpecifies the circular cell information.
ClassRepresents the event data for the ClipboardPasted event for the Spread component, which occurs after the Clipboard paste action.
ClassRepresents the event data for the ClipboardPastingEvent event for the Spread component, which occurs when the user invokes the Clipboard paste action.
ClassProvides a ColorFilter class to filter cells using the color specified in the filter criteria.
ClassRepresents a column in the component.
ClassRepresents the column footer portion of the control.
ClassRepresents the column header portion of the control.
ClassRepresents a one-dimensional collection of Column objects.
ClassRepresents the default column in the component.
ClassRepresents the renderer of the column sparklines.
ClassRepresents a special SpreadTouchStrip that is displayed in the column area.
ClassRepresents the event data for the ColumnViewportWidthChanged event for the Spread component, which occurs when the width of a viewport column has changed.
ClassRepresents the event data for the ColumnWidthChanged event for the Spread component, which occurs when the width of a column has changed.
ClassRepresents an object that contains first and last columns in a contiguous selection whose widths are changing.
ClassRepresents the event data for the ColumnWidthChanging event for the Spread component, which occurs when the width of a column is changing.
ClassRepresents a special AppearanceStyleInfo that combines several cell style effects to generate a new CellStyle object. This class cannot be inherited.
ClassRepresents a special CompareValueBaseValidator that validates whether the specified value and target Cell's value meet the given comparison criteria.
ClassRepresents a special CompareStringValidator that validates that the specified value matches the compared string using the CompareStringValidatorOperator.
ClassRepresents 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.
ClassRepresents a special CompareValueBaseValidator that validates whether the specified value and the ComparedValue meet the given comparison criteria.
ClassRepresents information related to sorting columns, rows, or a range of cells.
ClassRepresents a conditional format.
ClassInternal use only.
ClassRepresents a conditional format. This class cannot be inherited.
ClassRepresents the event data for the Changed event of conditional formatting.
ClassRepresents a color conditional formatting value. This class cannot be inherited.
ClassRepresents a collection of conditional formatting color values.
ClassRepresents a set of icons which are used for an icon conditional formatting rule.
ClassRepresents the structure that specifies an icon for conditional formatting.
ClassRepresents a complex value of the conditional formatting icon rule.
ClassRepresents the conditional formatting model for a sheet.
ClassRepresents the event data for the Changed event of the conditional formatting model for the sheet.
ClassRepresents the base class for conditional format rules. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
ClassProvides data for the IConditionalFormatting.PropertyChanged event.
ClassRepresents the collection function used for conditional formatting.
ClassRepresents a complex value of a conditional formatting rule.
ClassRepresents a collection of conditional formatting values.
ClassRepresents a special AppearanceStyleInfo that can customize the style using the specified condition. This class cannot be inherited.
ClassRepresents a condition that when matched by a Cell, applies the specified CellStyle to the Cell.
ClassRepresents the ConditionalStyleItem collection. This class cannot be inherited.
ClassPresent Custom list for drag fill in series mode
ClassProvides a CustomFilters class that groups custom filter elements together.
ClassRepresents a custom renderer of the focus indicator.
ClassProvides an icon object container. This class cannot be inherited.
ClassRepresents a complex identification for custom images. This class cannot be inherited.
ClassRepresents the data for changes to the custom name.
ClassRepresents an exception that is thrown when adding AutoAddNewRow.
ClassRepresents the data bar conditional formatting rule.
ClassRepresents the event data for the DataColumnConfigure event, which occurs when the column is being configured for data binding.
ClassRepresent a data validation manager that supports data validation. This class cannot be inherited.
ClassRepresents the default painter for the ErrorIcon in a cell.
ClassRepresents the default filtering of rows based on specified criteria.
ClassRepresents the renderer of the default focus indicator.
ClassContains the default setting for the group footer.
ClassContains default group footers for grouping
ClassRepresents the default painter for the indicator of a note in a cell.
ClassRepresents the relevant default information about an outline (range group) of rows and columns.
ClassRepresents 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.
ClassRepresents the scroll bar renderer that uses the default skin.
ClassRepresents the default selection renderer.
ClassRead-only collection of default (built-in) skins. This class cannot be inherited.
ClassRepresents the full (concrete) implementation of the ISparklineContainer interface for a sparkline model for a sheet, which represents sparklines.
ClassRepresents the read-only collection of default (built-in) Spread skins. This class cannot be inherited.
ClassRepresents the read-only collection of default NamedStyle objects. This class cannot be inherited.
ClassRepresents the event data for the DialogChar event of a Spread component.
ClassRepresents the event data for the DialogKey event of a Spread component.
Class 
ClassRepresents 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.
ClassRepresents the event data for the DragDropBlock event for the Spread component, which occurs when a range of cells is being dragged and dropped.
ClassRepresents 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.
ClassRepresents the event data for the DragFillBlock event for the Spread component, which occurs when the range of cells is being dragged and filled.
ClassRepresents the event data for the ColumnDragMoveCompleted and RowDragMoveCompleted event for the Spread component.
ClassRepresents the event data for the ColumnDragMove and RowDragMove events for the Spread component.
ClassProvides a DynamicFilter class to filter cells based on a set of built-in definitions due to DynamicFilterType.
ClassRepresents a special AppearanceStyleInfo that is used to customize a AppearanceStyleInfo under the DynamicStyleInfoContext class.
ClassProvides context information for customizing a DynamicStyleInfo object.
ClassRepresents the event data for the EditError event for the Spread component, which occurs when errors are generated when using the editor.
ClassRepresents the renderer for the editor focus.
ClassRepresents the event data for the EditModeOn event for the Spread component, which occurs when edit mode is starting.
ClassRepresents the event data for the EditorNotify event for the component, which occurs when the editor notifies the component of one of several changes.
ClassRepresents a special EncodingValidator that validates the text based on the specified encoding.
ClassRepresents the renderer for drawing the border around the active cell (that has focus).
ClassRepresents the painter of the visual elements with Excel2007 style.
ClassRepresents the renderer that paints the the scroll bar with the enhanced skin.
ClassRepresents the event data for the EnterCell event for the Spread component, which occurs when the focus enters a cell.
ClassRepresents a conditional formatting rule that accepts error or nonerror values.
ClassRepresents the event data for the Error event for the Spread component, which occurs when errors are generated by user interaction.
ClassRepresents an event listener.
ClassRepresents an event handler adapter. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
ClassConverter for EventName
ClassAbstract class that represents the renderer of the Excel-like sparklines. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
ClassRepresents sparkline data based on the cell range.
ClassRepresents a group of Excel-like sparklines.
ClassRepresents a setting of an Excel-like sparkline.
ClassRepresents a special BaseDataValidator that validates whether the specified value does not exist in the given Candidates list.
ClassRepresents the event data for the Expand event for the Spread component, which occurs when the hierarchy display is being expanded (showing child sheet views).
ClassRepresents the extra setting for the renderer to paint.
ClassProvides a FilterBarInfo class that represents information about the filter bar in the Spread component.
ClassRepresents 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.
ClassRepresents hit test information for the filter bar of the spreadsheet.
ClassRepresents a filter column definition.
ClassRepresents a collection of filter column definitions.
ClassProvides a CustomFilter class that specifies an operator and a value.
ClassRepresents a collection of custom filters.
ClassProvides a ValueFilterItem class used as filter criteria.
ClassProvides a ValueFilterItemCollection object used as a collection of alternative ValueFilterItem elements.
ClassRepresents the renderer for drawing the border around the active cell (that has focus).
ClassRepresents the painter of the visual elements with Excel2013 style.
ClassRepresents the renderer that paints the the scroll bar with the flat skin.
ClassRepresents the default selection renderer.
ClassRepresents a special ValidateActionBase that keeps the focus on the validating Cell when validation fails.
ClassRepresents the format cell dialog.
ClassRepresents the conditional formatting rule that uses a formula to determine which cells to format before starting to paint the background.
ClassRepresents the floating formula editor.
ClassRepresents the basis for all status bar elements. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
ClassRepresents the Spread horizontal scroll bar.
ClassRepresents the Spread scroll bar. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
ClassRepresents the Spread scroll bar button.
ClassRepresents a Spread scroll bar backward-to-home button.
ClassRepresents a Spread scroll bar back-by-line button.
ClassRepresents a Spread scroll bar page back button.
ClassRepresents the event data for the FpScrollBarButtonClickEvent, for the Spread component, which occurs when the Spread scroll bar button is clicked.
ClassRepresents the collection of elements for the Spread scroll bar. This class cannot be inherited.
ClassRepresents a Spread scroll bar forward-to-end button.
ClassRepresents a Spread scroll bar forward-by-line button.
ClassRepresents a Spread scroll bar page forward button.
ClassRepresents a combination of the backward track, forward track, and thumb of the scroll bar.
ClassRepresents the Spread scroll bar grip.
ClassRepresents a Spread scroll bar thumb.
ClassRepresents a Spread scroll bar track. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
ClassRepresents the backward track of the Spread scroll bar.
ClassRepresents the forward track of the Spread scroll bar.
ClassRepresents the Spreadsheet component.
ClassRepresents the status bar element that displays the average of the selected cells.
ClassRepresents the status bar element that displays the number of selected cells that contain data.
ClassRepresents the collection of status bar elements.
ClassRepresents the status bar element that displays the maximum value of the selected cells.
ClassRepresents the status bar element that displays the minimum value of the selected cells.
ClassRepresents the status bar element that displays the number of numeric cells in the selection.
ClassRepresents 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.
ClassRepresents 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.
ClassRepresents the status bar element that displays the sum of selected cells.
ClassRepresents the text element of the status bar.
ClassRepresents the Spread vertical scroll bar.
ClassRepresents the event arguments for the CustomIcon event handler.
ClassRepresents the painter of gradients in the interface.
ClassRepresents a renderer for displaying a gradient for a selection in the spreadsheet.
ClassRepresents the grid lines.
ClassRepresents information about the grouping bar in the Spread component.
ClassRepresents the grouping information.
ClassRepresents the read-only collection of GroupInfo objects.
ClassRepresents the event data for grouping events in the Spread component.
ClassRepresents hit test information for the headers of the spreadsheet.
ClassRepresents the filter that hides rows based on certain criteria.
ClassRepresents 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.
ClassRepresents the highlight style which applies the conditional formatting rule using highlighting.
ClassRepresents hit test information for the data area of the spreadsheet.
ClassRepresents the event data for the HyperLinkClicked event for the component, which occurs when the hyperlink cell is clicked.
ClassProvides an IconFilter class to filter cells using an icon specified in the filter criteria.
ClassRepresents a special AppearanceActionBase that displays an error icon for the validating cell when validation fails.
ClassRepresents the rule that paints an icon in the cell.
ClassRepresents the renderer of the image focus indicator.
ClassRepresents a special BaseDataValidator that validates whether the specified value exists in the given Candidates list.
ClassRepresents the map between input by the user and the action that occurs.
ClassException is thrown when fail to load input map file.
ClassProvides data for an event in a collection.
ClassRepresents the event data for the element in a collection that has been updated.
ClassRepresents a means of creating Keystroke objects in environments that do not support parameterized constructors.
ClassRepresents the rules that determine whether to print in landscape format.
ClassRepresents the event data for the LeaveCell event for the Spread component, which occurs when the focus leaves a cell.
ClassRepresents the event data for the LeftChange event for the Spread component, which occurs when the left column in the view changes.
ClassRepresents a special AppearanceActionBase that displays an underline in the validating cell when validation fails.
ClassRepresents the line sparkline renderer.
ClassProvides data for the System.ComponentModel.IBindingList.ListChanged event.
ClassRepresents the renderer of the marquee (or animated) focus indicator.
ClassRepresents a special ValidateActionBase that can display a message when cell validating fails.
ClassModelessTextBox
ClassProvides a Filters class to filter items using a criteria values list.
ClassRepresents the custom name texbox.
Class 
ClassRepresents the strongly typed INamedObject object collection.
ClassRepresents a custom style, an object that can be used to set style information for other objects.
ClassRepresents a collection of NamedStyle objects.
ClassRepresents the event data for the NamedStyleCollection object's Changed event.
ClassRepresents the data for the note event.
ClassRepresents the printing information for OwnerPrintDraw.
ClassRepresents the event data for the PaintGrayArea event for the Spread component.
ClassRepresents the event data for PaintGroupBarBackground events in the Spread component.
ClassRepresents the event data for the PaintTabStripButton event for the Spread component.
ClassRepresents the event data for the PaintTabStrip event for the Spread component.
ClassRepresents the event data for the PaintTabStripTab event for the Spread component.
ClassRepresents a character pair.
ClassRepresents a special BaseDataValidator that validates whether the specifed value matches the given PairChars.
ClassRepresents a conditional format rule that is executed before painting the cell.
ClassRepresents the executed result of a conditional formatting rule.
ClassRepresents the conditional formatting rule that is used for painting before the text is painted.
ClassRepresents the painting result of a conditional formatting rule.
ClassRepresents the event data for the PreviewRowFetch event for the Spread component, which occurs for formatting the preview row content.
ClassRepresents information about preview row in the Spread component.
ClassRepresents 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.
ClassRepresents the event data for the PrintBackground event for the Spread component, which occurs when the background is printing.
ClassRepresents the event data for the PrintCancelled event for the Spread component, which occurs when the printing is discontinued by the user.
ClassRepresents the event data for the PrintDocument event for the Spread component, which occurs during the print process of the sheetview.
ClassRepresents the event data for the PrintHeaderFooterArea event for the Spread component, which occurs when the background is printing.
ClassRepresents the information to use when printing a sheet of the control.
ClassRepresents the margin for the printed page.
ClassRepresents the event data for the PrintMessageBox event for the Spread component, which occurs when the print message box is to be displayed.
ClassRepresents the event data for the PrintPreviewShowing event for the Spread component, which occurs before the print preview dialog appears.
Class 
ClassRepresents raising an event when the property has changed and has infomation about the current value and the previous value.
ClassThis is event argument which is used to contain the result when querying value from client
ClassRepresents the information about which cell ranges contain the elements.
ClassRepresents hit test information for the outline (range group) of the spreadsheet.
ClassRepresents the relevant information of an outline (range group) of rows or columns.
ClassRepresents the event data for the Changed event of the outline (range group) model for the sheet.
ClassRepresents the event data for the Changed event of the outline (range group) for the sheet.
ClassRepresents the event data for the RangeGroupStateChanged event for an outline (range group) of rows and columns in the Spread component.
ClassRepresents the event data for the RangeGroupStateChanging event for an outline (range group) of rows and columns in the Spread component.
ClassRepresents a special BaseDataValidator that validates whether the specified value is between the range specified by MinValue and MaxValue.
ClassRepresents a special BaseDataValidator that validates whether the specifed value matches the given regular expression.
ClassRepresents 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.
ClassRepresents a special BaseDataValidator class that can validate whether the specified value is not a null reference (Nothing in Visual Basic).
ClassRepresents a special BaseDataValidator class that validates whether the specified value's System.Type is equal to the RequiredType.
ClassRepresents a row in the component.
Class/// Provides data for the Cell event of a FpSpread control.
ClassRepresents the row header portion of the control.
ClassRepresents the event data for the RowHeightChanged event for the Spread component, which occurs when the height of a row is changed.
ClassRepresents an object that contains first and last rows in contiguous selection whose heights are changing.
ClassRepresents the event data for the RowHeightChanging event for the Spread component, which occurs when the height of a row is changing.
ClassRepresents a one-dimensional collection of Row objects.
ClassRepresents the default row in the component.
ClassRepresents a special SpreadTouchStrip that is displayed in the row area.
ClassRepresents the event data for the RowViewportHeightChanged event for the Spread component, which occurs when the height of a viewport row has changed.
ClassRepresents the rules that determine how to scale the printed sheet.
ClassRepresents information about the scrolling grid content in the Spread component.
ClassRepresents the event data for the ScrollTipFetch event for the Spread component, which occurs when the spread is scrolled.
ClassRepresents a search dialog.
ClassRepresents 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.
ClassRepresents the event data for the SelectionChanging event for the Spread component, which occurs when the user is selecting another range of cells.
ClassRepresents a special SpreadTouchStrip which includes some common items.
ClassRepresents the corner of the control.
ClassRepresents the event data for the SheetDragMoved event for the Spread component, which occurs right after the user finishes moving the sheet to another index.
ClassRepresents 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.
ClassRepresents a skin, which provides style settings for a sheet.
ClassRepresents a style property in the StyleInfo object.
ClassRepresents an individual sheet name tab.
ClassRepresents 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.
ClassRepresents the event data for the SheetTabDoubleClick event for the Spread component, which occurs when the user double-clicks on a sheet name tab.
ClassRepresents an individual sheet in the Spread component.
ClassRepresents the SheetView.DocumentModels object that contains the models that make up the sheet.
ClassException thrown when moving multiple columns.
ClassException thrown when moving multiple rows.
ClassRepresents the SheetView.SaveAutoSortColumns object that contains the automatic sorting settings for the sheet.
ClassRepresents a collection of sheets (SheetView objects).
ClassRepresents the event data for the sheet.
ClassRepresents the data for changes to the sheet properties.
ClassRepresents the rules that determine the paper size.
ClassRepresents the rules that determine how best to print. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
ClassRepresents the set of rules that determine how best to print.
ClassRepresents the renderer of the solid focus indicator.
ClassRepresents the event data for the Sorting event for the Spread component, which occurs when Spread is being sorted.
ClassRepresents the event data for the Sorted event for the Spread component, which occurs when spread sorted.
ClassRepresents the information related to sorting columns, rows, or a range of cells.
ClassRepresents the event data for the Sorting event for the Spread component, which occurs when spread is sorting.
ClassRepresents a special ValidateActionBase that plays a specified system sound when validation fails.
ClassRepresents a sparkline in a cell.
ClassRepresents sparkline information in a cell.
ClassRepresents the event data for the UpdatedCellRanges event, which occurs when a list of cell ranges are updated.
ClassRepresents navigation, selection, clipboard, and other actions.
ClassSpecifies the font style information applied to the text. This class cannot be inherited.
ClassRepresents the skin of the Spread component.
ClassRead-only collection of default (built-in) sparkline renderers. This class cannot be inherited.
ClassRepresents the SpreadTouchStrip for FpSpread.
ClassRepresents a view of the spreadsheet display.
ClassRead-only collection of default (built-in) skins. This class cannot be inherited.
ClassRepresents the event data for element changes in the status bar.
ClassSkin of status bar
ClassObsolete. Use NoteEventArgs class instead. Represents the data for the sticky note event.
ClassInternal use only.
ClassRepresents the set of cell-level style settings for objects.
ClassProvides a drop-down list of style names for the StyleName property in the Cell, Column, Row, and AlternatingRow classes.
ClassRepresents the filter that sets the styles of rows based on certain criteria.
ClassRepresents the event data for the SubEditorClosed event for the Spread component, which occurs when the subeditor in a cell has closed.
ClassRepresents the event data for the SubEditorOpening event in the Spread component, which occurs when the subeditor in a cell is opening.
ClassRepresents a special BaseDataValidator that validates whether the specified value exists in surrogate characters.
ClassRepresents Table border. This class cannot be inherited.
ClassRepresents a style for each element of the table. This class cannot be inherited.
ClassClass represents table property changing event arguments.
ClassRepresents a style for the table.
ClassRepresents a table style manager.
ClassRepresents table style collection changed event arguments.
ClassRepresents a util class for spread table.
ClassRepresents spread table.
ClassRepresents a TableView's data structure in the clipboard.
ClassRepresents a column in the table.
ClassRepresents a one-dimensional collection of Column objects in a table.
ClassRepresents the set of sheet tabs.
ClassRepresents hit test information for the tab strip of the spreadsheet.
ClassRepresents the conditional formatting rule used for checking text values.
ClassRepresents a special TextLengthValidator that validates the length of the specified value using the LengthUnit setting.
ClassRepresents the event data for the TextTipFetch event for the Spread component, which occurs when the text tip is being fetched.
ClassRepresents the color scale conditional formatting rule with one middle value.
ClassRepresents a special ValidateActionBase that can display a valid icon or invalid icon when cell validating succeeds or fails.
ClassRepresents a conditional formatting rule that accepts periods of time.
ClassRepresents the appearance settings for various tips in the interface (text tips, scroll tips, and cell notes).
ClassRepresents a special ValidateActionBase that shows a tool tip for the validating Cell when validation fails.
ClassRepresents hit test information for the title and subtitle.
ClassRepresents information about the title bar in the Spread component.
ClassProvides a Top10Filter class to filter cells whose values are numeric.
ClassRepresents the event data for the TopChange event in the Spread component, which occurs when the top row changes.
ClassRepresents a top bottom conditional formatting rule.
ClassRepresents a tool strip button for a touch device.
ClassRepresents the event arguments for the FpSpread.TouchStripOpening event.
ClassRepresents the painter that drawing the indicator shape for a triangle for the indicator of a note in a cell.
ClassRepresents the two color scale conditional formatting rule.
ClassRepresents the conditional formatting rule that is used before starting to paint the background.
ClassRepresents a conditional formatting rule that accepts unique or duplicated values.
ClassRepresents the event data for the UserFormulaEntered event for the Spread component, which occurs when the user has entered a formula in a cell.
ClassRepresents a user specified filter item.
ClassProvides 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.
ClassRepresents a ValidateActionBase collection.
ClassProvides relative context information when the BaseValidationAction executes.
ClassRepresents a special ValidateActionBase that processes the value when validation fails.
ClassRepresents hit test information for the viewports of the spreadsheet.
ClassRepresents the renderer of the win/loss sparklines.
ClassRepresents the event data for the UserZooming event for the Spread component, which occurs when the user zooms.
ClassRepresents the status bar element that displays the zoom slider with the zoom out and zoom in buttons.
ClassRepresents the status bar element that displays the zoom level.
Interfaces
 InterfaceDescription
InterfaceInterface that defines the methods and properties required by objects used to allow the arrows to move the active cell.
InterfaceInterface that supports painting a changing (or animated) focus indicator.
InterfaceInterface that supports conditional formatting of cells on a sheet.
InterfaceInterface that supports conditional formatting of cells on a sheet.
InterfaceRepresents an interface which provides supported requirements for a conditional formatting rule.
InterfaceRepresents the conditional formatting model for a sheet.
InterfaceRepresents a conditional formatting rule.
InterfaceInterface that defines the methods and properties required by objects used as customization of the color of TabStrip.
InterfaceInterface that defines the enhanced methods and properties required by objects used as painters of tab sheets.
InterfaceInterface that supports printing to PDF, which supports extended features.
InterfaceInterface that defines the methods and properties required by objects used as enhanced renderers which supports extended features. Renderers are responsible for painting cells.
InterfaceInterface that defines the methods and properties required by objects used as painters of the error icon.
InterfaceProvides a unified way of converting types of values to a value used for Excel export.
InterfaceInterface that supports style filters in the style model for filtering rows on a sheet.
InterfaceInterface that supports style filters in the style model for filtering rows on a sheet.
InterfaceInterface that supports style filters in the style model for filtering rows on a sheet.
InterfaceInterface that supports the creation of custom row filters for filtering rows on a sheet.
InterfaceInterface that supports row filters for filtering rows on a sheet.
InterfaceInterface that supports painting the focus indicator using a specified control and dimensions.
InterfaceInterface that supports painting the focus indicator using a specified control and dimensions for Touch gripper support.
InterfaceIndicates whether the cell editor can handle formula input.
InterfaceIndicates whether the cell editor can handle formula input. With runtime check
InterfaceInterface for the status bar.
InterfaceInterface for the status bar elements.
InterfaceInterface that defines the methods and properties required by objects used for ignoring changes of the sheet.
InterfaceInterface that defines the methods and properties required by objects used as painters of tab sheets.
InterfaceInterface that supports to not filtering automatically when there is a cell change.
Interface 
InterfaceInterface that defines the methods and properties required by objects used as painters of the note indicator.
InterfaceInterface that defines the methods and properties required by objects used as painters of the note indicator.
InterfaceInterface that defines the methods and properties required by objects used as painters of the note indicator.
InterfaceInterface that notifies Spread when the item is changed.
InterfaceInterface that supports additional optimization in the conditional formatting model beyond IOptimizedFilterConditionalFormattingModel.
InterfaceInterface that supports additional optimization in the conditional formatting model beyond IOptimizedFilterConditionalFormattingModel.
InterfaceInterface that supports additional optimization for retrieval of styles in the style model beyond IOptimizedFilterStyleModel.
InterfaceRepresents the conditional formatting rule that is used for painting to PDF before the text is painted.
InterfaceRepresents the conditional formatting rule that is used before starting to paint the background.
InterfaceRepresents the conditional formatting rule that is used for painting before the text is painted.
InterfaceInterface for notifying Spread when the property changes from the previous value.
InterfaceInterface that supports creating a model that represents an outline (range group) of rows or columns.
InterfaceInterface that supports creating a model that represents an outline (range group) of rows or columns.
InterfaceInterface that supports the outline (range group) of rows or columns.
InterfaceInterface that supports row filters for filtering rows on a sheet.
InterfaceInterface that supports row filters for filtering rows on a sheet.
InterfaceInterface for supporting optional filtering of frozen rows.
InterfaceInterface that supports painting the scroll bar.
InterfaceInterface that supports painting the selection.
InterfaceInterface that causes the SheetCellRange container to reevaluate the SheetCellRange when the formula changes.
InterfaceInterface that supports creating a sparkline.
InterfaceInterface that supports creating a model that represents a sparkline.
InterfaceInterface that supports creating a group of sparklines.
InterfaceInterface that supports creating a renderer for painting sparklines.
InterfaceInterface that supports creating a setting for sparklines.
InterfaceRepresents the conditional formatting rule that is used before starting to paint the background and can stop all following conditional formatting rules.
Structures
 StructureDescription
StructureRepresents 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).
StructureEnumerates the elements of a ListBase<T>.
Delegates
 DelegateDescription
DelegateRepresents a defined method that handles the ActiveSheetChanging event for the Spread component.
DelegateRepresents a defined method that handles the Advance event for the Spread component.
DelegateRepresents a defined method that handles the AnnotationModeEnding event for the Spread component.
DelegateRepresents a defined method that handles the AnnotationModeStarting event for the Spread component.
DelegateRepresents a defined method that handles the AutoFilteredColumn event for the Spread component.
DelegateRepresents a defined method that handles the AutoFilteringColumn event for the Spread component.
DelegateRepresents a defined method that handles the AutoSortedColumn event for the Spread component.
DelegateRepresents a defined method that handles the AutoSortingColumn event for the Spread component.
DelegateRepresents a defined method that handles the BeforeSettingPropertyValue event.
DelegateRepresents a defined method that handles the CalculateException event.
DelegateRepresents a defined method that handles the CellClick and CellDoubleClick events for the Spread component.
DelegateRepresents a defined method that handles the error text change event for a cell.
DelegateRepresents a defined method that handles the Change event for the Spread component.
DelegateRepresents a defined method that handles the child control related events for the Spread component.
DelegateRepresents a defined method that handles the ChildViewCreated event for the Spread component.
DelegateRepresents a defined method that handles the ChildWorkbookCreated event for the Spread component.
DelegateThe handler for the Spread CirculaFormula event.
DelegateRepresents the method that handles an event after the group is cleared.
DelegateEvent handler for ClipboardPasted event.
DelegateRepresents a defined method that handles the ClipboardPasting event for the Spread component.
DelegateRepresents a defined method that handles the ColumnViewportWidthChanged event for the Spread component.
DelegateRepresents a defined method that handles the ColumnWidthChanged event for the Spread component.
DelegateRepresents a defined method that handles the ColumnWidthChanging event for the Spread component.
DelegateRepresents a method that handles the conditional formatting Changed events.
DelegateRepresents a method that handles the custom name events.
DelegateRepresents a defined method that handles the DataColumnConfigure event for the Spread component.
DelegateRepresents the method that handles the DialogChar event of a Spread component.
DelegateRepresents the method that handles the DialogKey event of a Spread component.
DelegateRepresents a defined method that handles the DragDrop event for the Spread component.
DelegateRepresents a defined method that handles the DragDropBlock event for the Spread component.
DelegateRepresents a defined method that handles the DragFillBlockCompleted event for the Spread component.
DelegateRepresents a defined method that handles the DragFillBlock event for the Spread component.
DelegateRepresents a defined method that handles the ColumnDragMoveCompleted or RowDragMoveCompleted event for the Spread component.
DelegateRepresents a defined method that handles the ColumnDragMove or RowDragMove event for the Spread component.
DelegateRepresents a method that returns a AppearanceStyleInfo with the specified DynamicStyleInfoContext.
DelegateRepresents a defined method that handles the EditError events for the Spread component.
DelegateRepresents a defined method that handles the EditModeStarting event for the Spread component.
DelegateRepresents a defined method that handles the ButtonClicked, ComboCloseUp, ComboDropDown, ComboSelChange, and EditChange events for the Spread component.
DelegateRepresents a defined method that handles the element changing event for the status bar.
DelegateRepresents a defined method that handles the EnterCell event for the Spread component.
DelegateRepresents a defined method that handles the Error events for the Spread component.
DelegateRepresents a defined method that handles the Expand event for the Spread component.
DelegateRepresents a defined method that handles the CellClick and CellDoubleClick events for the Spread component.
DelegateRepresents a defined method that handles the FpScrollBarButtonClickEventArgs event for the Spread component.
DelegateRepresents the delegate for measuring size of an icon for the icon conditional formatting rule in a cell.
DelegateRepresents a defined method that handles the Grouping event in the Spread component.
DelegateRepresents a defined method that handles the HyperLinkClicked event for the Spread component.
DelegateRepresents the method that handles an event after the item is operated on.
DelegateRepresents a defined method that handles the LeaveCell event for the Spread component.
DelegateRepresents a defined method that handles the LeftChange event for the Spread component.
DelegateRepresents the method that will handle the ListBase<T>.ListChanged event of the ListBase<T> class.
DelegateRepresents a defined method that handles the NamedStyleCollection object's Changed event.
DelegateRepresents a method that handles the note events.
DelegateRepresents a defined method that handles the PaintBackground event for the Spread component.
DelegateRepresents a defined method that handles the PaintGroupBarBackground event in the Spread component.
DelegateRepresents a defined method that handles the PaintTabStrip event for the Spread component.
DelegateRepresents a defined method that handles the PaintTabStrip event for the Spread component.
DelegateRepresents a defined method that handles the PaintTabStripTab event for the Spread component.
DelegateRepresents a defined method that handles the PreviewRowFetch event for the Spread component.
DelegateRepresents a defined method that handles the PrintAbort event for the Spread component.
DelegateRepresents a defined method that handles the PrintBackground event for the Spread component.
DelegateRepresents a defined method that handles the PrintCancelled event for the Spread component.
DelegateRepresents a defined method that handles the PrintDocument event for the Spread component.
DelegateRepresents a defined method that handles the PrintHeaderFooterArea event for the Spread component.
DelegateRepresents a defined method that handles the PrintMessageBox event for the Spread component.
DelegateRepresents a defined method that handles the PrintPreviewShowing event for the Spread component.
DelegateRepresents an event handler which is raised when the property has changed and has infomation about the current value and the previous value.
DelegateRepresents a defined method that handles the QueryValue event.
DelegateHandles the Changed event for the outline (range group) model for the sheet.
DelegateRepresents a defined method that handles the RangeGroupStateChanged event for an outline (range group) of the Spread component.
DelegateRepresents a defined method that handles the RangeGroupStateChanging event for an outline (range group) of the Spread component.
DelegateRepresents 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.
DelegateRepresents a defined method that handles the error text change event for a row.
DelegateRepresents a defined method that handles the RowHeightChanged event for the Spread component.
DelegateRepresents a defined method that handles the ColumnWidthChanging event for the Spread component.
DelegateRepresents a defined method that handles the RowViewportHeightChanged event for the Spread component.
DelegateRepresents a defined method that handles the ScrollTipFetch event for the Spread component.
DelegateRepresents a defined method that handles the SelectionChanged events for the Spread component.
DelegateRepresents a defined method that handles the SelectionChanging events for the Spread component.
DelegateRepresents a defined method that handles the SheetDragMoved event for the Spread component.
DelegateRepresents a defined method that handles the SheetDragMoving event for the Spread component.
DelegateRepresents a defined method that handles the SheetTabClick event for the Spread component.
DelegateRepresents 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.
DelegateRepresents a method that handles the sheet events.
DelegateRepresents a defined method that handles sheet property change events.
DelegateRepresents a defined method that handles the Sorted event for the Spread component.
DelegateRepresents a defined method that handles the Sorting event for the Spread component.
DelegateRepresents 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.
DelegateObsolete. Use NoteEventHandler instead. Represents a method that handles the sticky note events.
DelegateInternal use only.
DelegateRepresents a defined method that handles the SubEditorClosed event for the Spread component.
DelegateRepresents a defined method that handles the SubEditorOpening event for the Spread component.
DelegateHandles the table property changed event.
DelegateThe TableStyleCollectionChangedEventArgs handler.
DelegateRepresents a defined method that handles the TextTipFetch event for the Spread component.
DelegateRepresents a defined method that handles the TopChange event for the Spread component.
DelegateRepresents a defined method that handles the UserFormulaEntered event for the Spread component.
DelegateRepresents a defined method that handles the UserZooming event for the Spread component.
Enumerations
 EnumerationDescription
EnumerationSpecifies settings for the automatic filter.
EnumerationSpecifies how the borders of adjacent cells are displayed in the view.
EnumerationSpecifies how FpSpread reacts when the manipulation has gone beyond certain boundaries.
EnumerationSpecifies how to display buttons in cells for button and combo box cell types.
EnumerationIndicates the policy of the calculation controller.
EnumerationSpecifies the horizontal alignment of the cell contents.
EnumerationRepresents the CellRange type.
EnumerationSets the type of selection model when working with spans.
EnumerationSpecifies the vertical alignment of the cell contents.
EnumerationSpecifices the type of centering for the printed page.
EnumerationSpecifies the type of change (movement) of the scroll bar button.
EnumerationRepresents the origin of the source of the Clipboard data.
EnumerationSpecifies what data is copied to the Clipboard.
EnumerationSpecifies which headers are included when data is copied to or pasted from the Clipboard.
EnumerationSpecifies what data is pasted from the Clipboard.
EnumerationRepresents the CodeDom strategies.
EnumerationSpecifies which UITypeEditor to invoke directly at runtime.
EnumerationDefines the operators which are used to compare strings.
EnumerationSpecifies the operator for conditional formats.
EnumerationSpecifies the type of Changed event that has occurred for conditional formatting.
EnumerationRepresents the predefined icon for conditional formatting.
EnumerationRepresents the style of the icon set.
EnumerationSpecifies the type of Change event that has occurred for a conditional formatting model for the sheet.
EnumerationRepresents the value type of the conditional formatting.
EnumerationDefines operators that are used to customize a ConditionalStyleInfo.
EnumerationSpecifies the area of the component in which to display a specific pointer.
EnumerationSpecifies the operator for custom filtering.
EnumerationSpecifies how to process the data when a custom name changes.
EnumerationRepresents the axis position for the data bar.
EnumerationSpecifies the part of the date time value used in a comparision.
EnumerationSpecifies the type of DragFill mode.
EnumerationSpecifies a value that indicates the type of dynamic filter.
EnumerationSpecifies the possible editor messages based on the user action.
EnumerationSpecifies the element alignment for the status bar.
EnumerationSpecifies settings for sorting items in an enhanced filter.
EnumerationSpecifies the button style.
EnumerationSpecifies the shape of sheet tabs.
EnumerationSpecifies the direction of the filling of cells.
EnumerationSpecifies how the row filter behaves.
EnumerationSpecifies the state of filtering for the current column so the column renderer knows which filtering image to draw.
EnumerationDefines the moving active cell while editing cell enumeration.
EnumerationRepresents the tabs of the format cell form.
EnumerationSpecifies whether horizontal or vertical grid lines or both are displayed on the sheet.
EnumerationSpecifies the type of grid lines.
EnumerationSpecifies the status of an outline (range group).
EnumerationSpecifies the default labels to display in headers.
EnumerationSpecifies the locations in the component for the HitTest method.
EnumerationSpecifies the horizontal position of the cell or column in the component.
EnumerationIndicates the input device type.
EnumerationSpecifies the condition for which an input map applies.
EnumerationRepresents options for backward compatibility.
EnumerationDefines the units that are used to validate the text length.
EnumerationSpecifies the type of change event that has occurred for the style in the collection.
EnumerationSpecifies the type of contents of a cell.
EnumerationSpecifies the position of the cell note indicator.
EnumerationSpecifies how the cell notes are displayed.
EnumerationSpecifies how the sheet responds to user interaction and what selections are allowed.
EnumerationSpecifies the output mode for printing the sheet as PDF.
EnumerationSpecifies the output for printing the sheet as PDF.
EnumerationSpecifies the options when getting the preferred width for the column.
EnumerationSpecifies the options when getting the preferred height for the row.
EnumerationRepresents the type of PrintDocument event which occurs during the print process of the sheetview.
EnumerationSpecifies whether the header is printed.
EnumerationSpecifies how cell notes are printed.
EnumerationSpecifies the page orientation used to print the sheet.
EnumerationSpecifies the order in which pages are printed.
EnumerationSpecifies whether the title is printed.
EnumerationSpecifies the type of print range used to print the sheet.
EnumerationSpecifies the button style for an outline (range group) of rows or columns.
EnumerationSpecifies the type of Change event that has occurred for the outline (range group) model for the sheet.
EnumerationSpecifies the type of change that has occurred for an outline (range group) for the sheet.
EnumerationSpecifies whether regular, bold, or italic font styles are applied to the text.
EnumerationSpecifies whether the rules or a particular rule should reset before testing the next rule.
Enumeration 
EnumerationSpecifies the state of the row header selector for the current selected row, so the row renderer knows which row header selector image to draw.
EnumerationSpecifies how to save spreadsheet data to an XML file.
EnumerationSpecifies the type of DPI scale support.
EnumerationSpecifies the type of scroll bar buttons by specifying which elements of the scroll bar are displayed.
EnumerationSpecifies when the component displays the scroll bars.
EnumerationSpecifies whether the component scrolls the sheet when the user moves the scroll box.
EnumerationSpecifies how to display the current row number in scrolling content.
EnumerationSpecifies whether the component displays the text tip when the user moves the scroll box.
EnumerationSpecifies where the search string is found.
EnumerationSpecifies which part of the sheet can be selected by the user.
EnumerationSpecifies the style for the display of selected cells.
EnumerationSpecifies the position of the image on viewport.
EnumerationSpecifies the type that is sorted.
EnumerationThe mode used to specify the sorting behavior.
EnumerationSpecifies the sorting state for the current column so the column renderer knows which sorting image to draw.
EnumerationAn enumeration that specifies information about how the vertical axis minimum or maximum is computed for this sparkline group.
EnumerationRepresents the type of sparkline.
EnumerationSpecifies the placement of split boxes in the component with respect to their alignment with the scroll bars.
EnumerationSpecifies when the component displays the split boxes.
EnumerationSpecifies how FpSpread reacts to touch manipulation.
EnumerationSpecifies whether the strikeout font style is applied to the text.
EnumerationInternal use only.
EnumerationSpecifies a system sound type which relates to a System.Media.SystemSound.
EnumerationThe table style changed collection type.
EnumerationSpecifies the sheet tab buttons.
EnumerationSpecifies the display policy for the tab strip buttons.
EnumerationSpecifies the location of the tab strip in the component.
EnumerationSpecifies when the component displays the sheet name tabs.
EnumerationRepresents operators applied for text conditional formatting.
EnumerationSpecifies how to process the data when saving to a text file.
EnumerationSpecifies how the text tip of a cell in the view is displayed, and also how the cell note is displayed.
EnumerationRepresents 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.
EnumerationSpecifies what area to display the SpreadTouchStrip.
EnumerationRepresents the unary comparison operator.
EnumerationSpecifies whether the underline font style is applied to the text.
EnumerationSpecifies the binary operations between the target value and the compared value when validating a cell.
EnumerationSpecifies the reasons that cause an action to execute.
EnumerationDefines the options that are used by ValueProcess.
EnumerationSpecifies 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

Reference

FarPoint.Win.Spread Assembly

User-Task Documentation

Developer's Guide