Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace
Inheritance Hierarchy
In This Topic
    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
     ClassDescription
    ClassRepresents an action in the component that is used for mapping to keys.
    Class Represents an action map, which provides mappings from objects to actions.
    Class Represents the event data for the ActiveSheetChanging event for the component, which occurs when the component changes to another active sheet.
    Class Represents an advanced search dialog.
    Class Represents the event data for the Advance event for the Spread component, which occurs when focus is advanced to another control.
    Class Represents a set of style information for alternating rows in the component.
    Class Represents a one-dimensional collection of AlternatingRow objects, which set the style information for alternating rows in the component.
    Class Represents the renderer of the default changing (or animated) focus indicator.
    Class 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.
    Class Represents the appearance settings for an object.
    Class Represents a special implementation that displays UI elements on the validating cell.
    ClassRepresents a collection of AppearanceStyleInfos.
    Class Represents the set of cell style settings for the validation.
    Class Represents the event data for the AutoFilteredColumn event for the Spread component, which occurs when the column has been automatically filtered.
    Class Represents the event data for the AutoFilteringColumn event for the Spread component, which occurs when columns are being automatically filtered.
    Class Represents the event data for the AutoSortedColumn event for the Spread component, which occurs when the column has been automatically sorted.
    Class Represents the event data for the AutoSortingColumn event for the Spread component, which occurs when columns are being automatically sorted.
    Class Represents an above or below average conditional formatting rule.
    Class Represents a data BaseDataValidator.
    Class Represents the basis for a custom filter.
    Class Base class that represents sparkline data infomation.
    ClassProvides data for the UIManager.BeforeRightClick events.
    Class Represents before setting property value event arguments.
    Class Represents the event data for the BeforeShowContextMenu event for the Spread component, which occurs when the user open the enhanced filter context menu.
    Class Represents the rules that determine how best to print the columns.
    Class Represents a conditional formatting rule that accepts or does not accept a value in a range.
    Class Represents a conditional formatting rule that accepts blank or nonblank values.
    Class Represents the event data for the CalculateException event, that contains the exception thrown when calculating the result of a formula.
    Class Represents a cell in the Spread component.
    Class 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.
    Class Provides data for the Cell event of a FpSpread control.
    Class Represents a footer cell.
    Class Represents padding information associated with a cell.
    Class Represents 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.
    Class Represents the event data for the Change event for the Spread component, which occurs when a cell changes.
    Class Represents settings used to check if the text is in a specified format.
    ClassRepresents a special SpreadTouchStrip which includes some common items.
    Class Represents the event data for the child control related events for the Spread component.
    Class Represents the event data for a ChildViewCreated event for the Spread component, which occurs when a child sheet is created in a hierarchical spreadsheet.
    Class Represents the event data for a ChildWorkbookCreated event for the Spread component, which occurs when a child sheet is created in a hierarchical spreadsheet.
    Class Specifies the event argument for the CircularCellChanged event.
    Class Specifies EventArgs for the CircularFormula event.
    Class Specifies the circular cell information.
    Class Represents the event data for the ClipboardPasted event for the Spread component, which occurs after the Clipboard paste action.
    Class Represents the event data for the ClipboardPastingEvent event for the Spread component, which occurs when the user invokes the Clipboard paste action.
    Class Provides a ColorFilter class to filter cells using the color specified in the filter criteria.
    Class Represents a column in the component.
    Class Represents the column footer portion of the control.
    Class Represents the column header portion of the control.
    Class Represents a one-dimensional collection of Column objects.
    Class Represents the default column in the component.
    Class Represents the renderer of the column sparklines.
    ClassRepresents a special SpreadTouchStrip that is displayed in the column area.
    Class Represents the event data for the ColumnViewportWidthChanged event for the Spread component, which occurs when the width of a viewport column has changed.
    Class Represents the event data for the ColumnWidthChanged event for the Spread component, which occurs when the width of a column has changed.
    Class Represents an object that contains first and last columns in a contiguous selection whose widths are changing.
    Class Represents 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.
    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.
    ClassRepresents a special CompareValueBaseValidator that validates whether the specified value and the ComparedValue meet the given comparison criteria.
    Class Represents information related to sorting columns, rows, or a range of cells.
    Class Represents a conditional format.
    Class Internal use only.
    Class Represents a conditional format.
    Class Represents the event data for the Changed event of conditional formatting.
    Class Represents a color conditional formatting value.
    Class Represents a collection of conditional formatting color values.
    Class Represents a set of icons which are used for an icon conditional formatting rule.
    Class Represents the structure that specifies an icon for conditional formatting.
    Class Represents a complex value of the conditional formatting icon rule.
    Class Represents the conditional formatting model for a sheet.
    Class Represents the event data for the Changed event of the conditional formatting model for the sheet.
    Class Represents the base class for conditional format rules.
    Class Provides data for the IConditionalFormatting.PropertyChanged event.
    Class Represents the collection function used for conditional formatting.
    Class Represents a complex value of a conditional formatting rule.
    Class Represents a collection of conditional formatting values.
    ClassRepresents a special AppearanceStyleInfo that can customize the style using the specified condition.
    Class

     

    ClassRepresents the ConditionalStyleItem collection.
    Class Present Custom list for drag fill in series mode
    Class Provides a CustomFilters class that groups custom filter elements together.
    Class Represents a custom renderer of the focus indicator.
    Class Provides an icon object container.
    Class Represents a complex identification for custom images.
    Class Represents the data for changes to the custom name.
    Class Represents an exception that is thrown when adding AutoAddNewRow.
    Class Represents the data bar conditional formatting rule.
    Class Represents the event data for the DataColumnConfigure event, which occurs when the column is being configured for data binding.
    Class Represent a data validation manager that supports data validation.
    Class Represents the default painter for the ErrorIcon in a cell.
    Class Represents the default filtering of rows based on specified criteria.
    Class Represents the renderer of the default focus indicator.
    Class Contains the default setting for the group footer.
    Class Contains default group footers for grouping
    Class Represents the default painter for the indicator of a note in a cell.
    Class Represents the relevant default information about an outline (range group) of rows and columns.
    Class Represents a default row filter that extends to implement the supported row filters.
    Class Represents the scroll bar renderer that uses the default skin.
    Class Represents the default selection renderer.
    Class Read-only collection of default (built-in) skins.
    Class Represents the full (concrete) implementation of the ISparklineContainer interface for a sparkline model for a sheet, which represents sparklines.
    Class Represents the read-only collection of default (built-in) Spread skins.
    Class Represents the read-only collection of default NamedStyle objects.
    Class Represents the event data for the DialogChar event of a Spread component.
    Class Represents the event data for the DialogKey event of a Spread component.
    Class 
    Class 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.
    Class Represents the event data for the DragDropBlock event for the Spread component, which occurs when a range of cells is being dragged and dropped.
    Class 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.
    Class Represents the event data for the DragFillBlock event for the Spread component, which occurs when the range of cells is being dragged and filled.
    Class Represents the event data for the ColumnDragMoveCompleted and RowDragMoveCompleted event for the Spread component.
    Class Represents the event data for the ColumnDragMove and RowDragMove events for the Spread component.
    Class Provides 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.
    Class Represents the event data for the EditError event for the Spread component, which occurs when errors are generated when using the editor.
    Class Represents the renderer for the editor focus.
    Class Represents the event data for the EditModeOn event for the Spread component, which occurs when edit mode is starting.
    Class Represents 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.
    Class Represents the renderer for drawing the border around the active cell (that has focus).
    Class Represents the painter of the visual elements with Excel2007 style.
    Class Represents the renderer that paints the the scroll bar with the enhanced skin.
    Class Represents the event data for the EnterCell event for the Spread component, which occurs when the focus enters a cell.
    Class Represents a conditional formatting rule that accepts error or nonerror values.
    Class Represents the event data for the Error event for the Spread component, which occurs when errors are generated by user interaction.
    Class Represents an event listener.
    Class Represents an event handler adapter.
    Class Converter for EventName
    Class Abstract class that represents the renderer of the Excel-like sparklines.
    Class Represents sparkline data based on the cell range.
    Class Represents a group of Excel-like sparklines.
    Class Represents 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.
    Class 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).
    Class Represents the extra setting for the renderer to paint.
    Class Provides a FilterBarInfo class that represents information about the filter bar in the Spread component.
    Class 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.
    Class Represents hit test information for the filter bar of the spreadsheet.
    Class Represents a filter column definition.
    Class Represents a collection of filter column definitions.
    Class Provides a CustomFilter class that specifies an operator and a value.
    Class Represents a collection of custom filters.
    Class Provides a ValueFilterItem class used as filter criteria.
    Class Provides a ValueFilterItemCollection object used as a collection of alternative ValueFilterItem elements.
    Class Represents the renderer for drawing the border around the active cell (that has focus).
    Class Represents the painter of the visual elements with Excel2013 style.
    Class Represents the renderer that paints the the scroll bar with the flat skin.
    Class Represents the default selection renderer.
    ClassRepresents a special ValidateActionBase that keeps the focus on the validating Cell when validation fails.
    Class Represents the format cell dialog.
    Class Represents the conditional formatting rule that uses a formula to determine which cells to format before starting to paint the background.
    Class Represents the floating formula editor.
    Class Represents the basis for all status bar elements.
    Class Represents the Spread horizontal scroll bar.
    Class Represents the Spread scroll bar.
    Class Represents the Spread scroll bar button.
    Class Represents a Spread scroll bar backward-to-home button.
    Class Represents a Spread scroll bar back-by-line button.
    Class Represents a Spread scroll bar page back button.
    Class Represents the event data for the FpScrollBarButtonClickEvent, for the Spread component, which occurs when the Spread scroll bar button is clicked.
    Class Represents the collection of elements for the Spread scroll bar.
    Class Represents a Spread scroll bar forward-to-end button.
    Class Represents a Spread scroll bar forward-by-line button.
    Class Represents a Spread scroll bar page forward button.
    Class Represents a combination of the backward track, forward track, and thumb of the scroll bar.
    Class Represents the Spread scroll bar grip.
    Class Represents a Spread scroll bar thumb.
    Class Represents a Spread scroll bar track.
    Class Represents the backward track of the Spread scroll bar.
    Class Represents the forward track of the Spread scroll bar.
    Class Represents the Spreadsheet component.
    Class Represents the status bar element that displays the average of the selected cells.
    Class Represents the status bar element that displays the number of selected cells that contain data.
    Class Represents the collection of status bar elements.
    Class Represents the status bar element that displays the maximum value of the selected cells.
    Class Represents the status bar element that displays the minimum value of the selected cells.
    Class Represents the status bar element that displays the number of numeric cells in the selection.
    Class Represents the element of status bar handling the change of selection ranges in activesheetview.
    Class Represents the element of status bar handling the change of selection ranges in activesheetview and formating the displayed text.
    Class Represents the status bar element that displays the sum of selected cells.
    Class Represents the text element of the status bar.
    Class Represents the Spread vertical scroll bar.
    Class Represents the event arguments for the CustomIcon event handler.
    Class Represents the painter of gradients in the interface.
    Class Represents a renderer for displaying a gradient for a selection in the spreadsheet.
    Class Represents the grid lines.
    Class Represents information about the grouping bar in the Spread component.
    Class Represents the grouping information.
    Class Represents the read-only collection of GroupInfo objects.
    Class Represents the event data for grouping events in the Spread component.
    Class Represents hit test information for the headers of the spreadsheet.
    Class Represents the filter that hides rows based on certain criteria.
    Class Represents the conditional formatting rule that is used before starting to paint the background.
    Class Represents the highlight style which applies the conditional formatting rule using highlighting.
    Class Represents hit test information for the data area of the spreadsheet.
    Class Represents the event data for the HyperLinkClicked event for the component, which occurs when the hyperlink cell is clicked.
    Class Provides 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.
    Class Represents the rule that paints an icon in the cell.
    Class Represents the renderer of the image focus indicator.
    ClassRepresents a special BaseDataValidator that validates whether the specified value exists in the given Candidates list.
    Class Represents the map between input by the user and the action that occurs.
    Class Exception is thrown when fail to load input map file.
    Class Provides data for an event in a collection.
    Class Represents 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.
    Class Represents the rules that determine whether to print in landscape format.
    Class Represents the event data for the LeaveCell event for the Spread component, which occurs when the focus leaves a cell.
    Class Represents 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.
    Class Represents the line sparkline renderer.
    ClassProvides data for the System.ComponentModel.IBindingList.ListChanged event.
    Class Represents the renderer of the marquee (or animated) focus indicator.
    ClassRepresents a special ValidateActionBase that can display a message when cell validating fails.
    Class ModelessTextBox
    Class Provides a Filters class to filter items using a criteria values list.
    Class Represents the custom name texbox.
    Class 
    Class Represents the strongly typed INamedObject object collection.
    Class Represents a custom style, an object that can be used to set style information for other objects.
    ClassRepresents a collection of NamedStyle objects.
    Class Represents the event data for the NamedStyleCollection object's Changed event.
    Class Represents the data for the note event.
    Class Represents the printing information for OwnerPrintDraw.
    Class Represents the event data for the PaintGrayArea event for the Spread component.
    Class Represents the event data for PaintGroupBarBackground events in the Spread component.
    Class Represents the event data for the PaintTabStripButton event for the Spread component.
    Class Represents the event data for the PaintTabStrip event for the Spread component.
    Class Represents the event data for the PaintTabStripTab event for the Spread component.
    Class Represents a character pair.
    ClassRepresents a special BaseDataValidator that validates whether the specifed value matches the given PairChars.
    Class Represents a conditional format rule that is executed before painting the cell.
    Class Represents the executed result of a conditional formatting rule.
    Class Represents the conditional formatting rule that is used for painting before the text is painted.
    Class Represents the painting result of a conditional formatting rule.
    Class Represents the event data for the PreviewRowFetch event for the Spread component, which occurs for formatting the preview row content.
    Class Represents information about preview row in the Spread component.
    Class 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.
    Class Represents the event data for the PrintBackground event for the Spread component, which occurs when the background is printing.
    Class Represents the event data for the PrintCancelled event for the Spread component, which occurs when the printing is discontinued by the user.
    Class Represents the event data for the PrintDocument event for the Spread component, which occurs during the print process of the sheetview.
    Class Represents the event data for the PrintHeaderFooterArea event for the Spread component, which occurs when the background is printing.
    Class Represents the information to use when printing a sheet of the control.
    Class Represents the margin for the printed page.
    Class Represents the event data for the PrintMessageBox event for the Spread component, which occurs when the print message box is to be displayed.
    Class Represents the event data for the PrintPreviewShowing event for the Spread component, which occurs before the print preview dialog appears.
    Class 
    Class Represents raising an event when the property has changed and has infomation about the current value and the previous value.
    Class This is event argument which is used to contain the result when querying value from client
    Class Represents the information about which cell ranges contain the elements.
    Class Represents hit test information for the outline (range group) of the spreadsheet.
    Class Represents the relevant information of an outline (range group) of rows or columns.
    Class Represents the event data for the Changed event of the outline (range group) model for the sheet.
    Class Represents the event data for the Changed event of the outline (range group) for the sheet.
    Class Represents the event data for the RangeGroupStateChanged event for an outline (range group) of rows and columns in the Spread component.
    Class Represents 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.
    Class 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.
    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.
    Class Represents a row in the component.
    Class /// Provides data for the Cell event of a FpSpread control.
    Class Represents the row header portion of the control.
    Class Represents the event data for the RowHeightChanged event for the Spread component, which occurs when the height of a row is changed.
    Class Represents an object that contains first and last rows in contiguous selection whose heights are changing.
    Class Represents the event data for the RowHeightChanging event for the Spread component, which occurs when the height of a row is changing.
    Class Represents a one-dimensional collection of Row objects.
    Class Represents the default row in the component.
    ClassRepresents a special SpreadTouchStrip that is displayed in the row area.
    Class Represents the event data for the RowViewportHeightChanged event for the Spread component, which occurs when the height of a viewport row has changed.
    Class Represents the rules that determine how to scale the printed sheet.
    Class Represents information about the scrolling grid content in the Spread component.
    Class Represents the event data for the ScrollTipFetch event for the Spread component, which occurs when the spread is scrolled.
    Class Represents a search dialog.
    Class 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.
    Class Represents 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.
    Class Represents the corner of the control.
    Class 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.
    Class 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.
    Class Represents a skin, which provides style settings for a sheet.
    ClassRepresents a style property in the StyleInfo object.
    Class Represents an individual sheet name tab.
    Class 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.
    Class Represents the event data for the SheetTabDoubleClick event for the Spread component, which occurs when the user double-clicks on a sheet name tab.
    Class 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.
    ClassRepresents the SheetView.DocumentModels object that contains the models that make up the sheet.
    Class Exception thrown when moving multiple columns.
    Class Exception thrown when moving multiple rows.
    ClassRepresents the SheetView.SaveAutoSortColumns object that contains the automatic sorting settings for the sheet.
    Class Represents a collection of sheets (SheetView objects).
    Class Represents the event data for the sheet.
    Class Represents the data for changes to the sheet properties.
    Class 
    Class 
    Class Represents the rules that determine the paper size.
    Class Represents the rules that determine how best to print.
    Class Represents the set of rules that determine how best to print.
    Class Represents the renderer of the solid focus indicator.
    Class Represents the event data for the Sorting event for the Spread component, which occurs when Spread is being sorted.
    Class Represents the event data for the Sorted event for the Spread component, which occurs when spread sorted.
    Class Represents the information related to sorting columns, rows, or a range of cells.
    Class Represents 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.
    Class Represents a sparkline in a cell.
    Class Represents sparkline information in a cell.
    Class Represents the event data for the UpdatedCellRanges event, which occurs when a list of cell ranges are updated.
    ClassRepresents navigation, selection, clipboard, and other actions.
    Class Specifies the font style information applied to the text.
    Class Represents the skin of the Spread component.
    Class Read-only collection of default (built-in) sparkline renderers.
    ClassRepresents the SpreadTouchStrip for FpSpread.
    Class Represents a view of the spreadsheet display.
    Class Read-only collection of default (built-in) skins.
    Class Represents the event data for element changes in the status bar.
    Class Skin of status bar
    Class Obsolete. Use NoteEventArgs class instead. Represents the data for the sticky note event.
    Class Internal use only.
    Class Represents the set of cell-level style settings for objects.
    Class Provides a drop-down list of style names for the StyleName property in the Cell, Column, Row, and AlternatingRow classes.
    Class Represents the filter that sets the styles of rows based on certain criteria.
    Class Represents the event data for the SubEditorClosed event for the Spread component, which occurs when the subeditor in a cell has closed.
    Class Represents 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.
    Class Represents Table border.
    Class Represents a style for each element of the table.
    Class Class represents table property changing event arguments.
    Class Represents a style for the table.
    Class Represents a table style manager.
    Class Represents table style collection changed event arguments.
    Class Represents a util class for spread table.
    Class Represents spread table.
    Class Represents a TableView's data structure in the clipboard.
    Class Represents a column in the table.
    Class Represents a one-dimensional collection of Column objects in a table.
    Class Represents the set of sheet tabs.
    Class Represents hit test information for the tab strip of the spreadsheet.
    Class Represents 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.
    Class Represents the event data for the TextTipFetch event for the Spread component, which occurs when the text tip is being fetched.
    Class Represents 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.
    Class Represents a conditional formatting rule that accepts periods of time.
    Class Represents 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.
    Class Represents hit test information for the title and subtitle.
    Class Represents information about the title bar in the Spread component.
    Class Provides a Top10Filter class to filter cells whose values are numeric.
    Class Represents the event data for the TopChange event in the Spread component, which occurs when the top row changes.
    Class Represents a top bottom conditional formatting rule.
    Class Represents a tool strip button for a touch device.
    ClassRepresents the event arguments for the FpSpread.TouchStripOpening event.
    Class Represents the painter that drawing the indicator shape for a triangle for the indicator of a note in a cell.
    Class Represents the two color scale conditional formatting rule.
    Class Represents the conditional formatting rule that is used before starting to paint the background.
    Class Represents a conditional formatting rule that accepts unique or duplicated values.
    Class Represents the event data for the UserFormulaEntered event for the Spread component, which occurs when the user has entered a formula in a cell.
    Class Represents a user specified filter item.
    Class Provides the capability to execute certain actions if a Cell value fails to validate.
    ClassRepresents a ValidateActionBase collection.
    Class Provides relative context information when the BaseValidationAction executes.
    ClassRepresents a special ValidateActionBase that processes the value when validation fails.
    Class Represents hit test information for the viewports of the spreadsheet.
    Class Represents the renderer of the win/loss sparklines.
    Class Represents the event data for the UserZooming event for the Spread component, which occurs when the user zooms.
    Class Represents the status bar element that displays the zoom slider with the zoom out and zoom in buttons.
    Class Represents the status bar element that displays the zoom level.
    Interfaces
     InterfaceDescription
    Interface Interface that defines the methods and properties required by objects used to allow the arrows to move the active cell.
    Interface Interface that supports painting a changing (or animated) focus indicator.
    Interface Interface that supports conditional formatting of cells on a sheet.
    Interface Interface that supports conditional formatting of cells on a sheet.
    Interface Represents an interface which provides supported requirements for a conditional formatting rule.
    Interface Represents the conditional formatting model for a sheet.
    Interface Represents a conditional formatting rule.
    Interface Interface that defines the methods and properties required by objects used as customization of the color of TabStrip.
    Interface Interface that defines the enhanced methods and properties required by objects used as painters of tab sheets.
    Interface Interface that supports printing to PDF, which supports extended features.
    Interface Interface that defines the methods and properties required by objects used as enhanced renderers which supports extended features. Renderers are responsible for painting cells.
    Interface Interface that defines the methods and properties required by objects used as painters of the error icon.
    Interface Provides a unified way of converting types of values to a value used for Excel export.
    InterfaceRepresents all customizable features of FpSpread.
    Interface Interface that supports style filters in the style model for filtering rows on a sheet.
    Interface Interface that supports style filters in the style model for filtering rows on a sheet.
    Interface Interface that supports style filters in the style model for filtering rows on a sheet.
    Interface Interface that supports the creation of custom row filters for filtering rows on a sheet.
    Interface Interface that supports row filters for filtering rows on a sheet.
    Interface Interface that supports painting the focus indicator using a specified control and dimensions.
    Interface Interface that supports painting the focus indicator using a specified control and dimensions for Touch gripper support.
    Interface Indicates whether the cell editor can handle formula input.
    Interface Indicates whether the cell editor can handle formula input. With runtime check
    Interface Interface for the status bar.
    Interface Interface for the status bar elements.
    Interface Interface that defines the methods and properties required by objects used for ignoring changes of the sheet.
    Interface Interface that defines the methods and properties required by objects used as painters of tab sheets.
    Interface Interface that supports to not filtering automatically when there is a cell change.
    Interface 
    Interface Interface that defines the methods and properties required by objects used as painters of the note indicator.
    Interface Interface that defines the methods and properties required by objects used as painters of the note indicator.
    Interface Interface that defines the methods and properties required by objects used as painters of the note indicator.
    Interface Interface that notifies Spread when the item is changed.
    Interface Interface that supports additional optimization in the conditional formatting model beyond IOptimizedFilterConditionalFormattingModel.
    Interface Interface that supports additional optimization in the conditional formatting model beyond IOptimizedFilterConditionalFormattingModel.
    Interface Interface that supports additional optimization for retrieval of styles in the style model beyond IOptimizedFilterStyleModel.
    Interface Represents the conditional formatting rule that is used for painting to PDF before the text is painted.
    Interface Represents the conditional formatting rule that is used before starting to paint the background.
    Interface Represents the conditional formatting rule that is used for painting before the text is painted.
    Interface Interface for notifying Spread when the property changes from the previous value.
    Interface Interface that supports creating a model that represents an outline (range group) of rows or columns.
    Interface Interface that supports creating a model that represents an outline (range group) of rows or columns.
    Interface Interface that supports the outline (range group) of rows or columns.
    Interface Interface that supports row filters for filtering rows on a sheet.
    Interface Interface that supports row filters for filtering rows on a sheet.
    Interface Interface for supporting optional filtering of frozen rows.
    Interface Interface that supports painting the scroll bar.
    Interface Interface that supports painting the selection.
    Interface Interface that causes the SheetCellRange container to reevaluate the SheetCellRange when the formula changes.
    Interface Interface that supports creating a sparkline.
    Interface Interface that supports creating a model that represents a sparkline.
    Interface Interface that supports creating a group of sparklines.
    Interface Interface that supports creating a renderer for painting sparklines.
    Interface Interface that supports creating a setting for sparklines.
    Interface Represents the conditional formatting rule that is used before starting to paint the background and can stop all following conditional formatting rules.
    Structures
     StructureDescription
    Structure 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).
    StructureEnumerates the elements of a ListBase<T>.
    Delegates
     DelegateDescription
    Delegate Represents a defined method that handles the ActiveSheetChanging event for the Spread component.
    Delegate Represents a defined method that handles the Advance event for the Spread component.
    Delegate Represents a defined method that handles the AnnotationModeEnding event for the Spread component.
    Delegate Represents a defined method that handles the AnnotationModeStarting event for the Spread component.
    Delegate Represents a defined method that handles the AutoFilteredColumn event for the Spread component.
    Delegate Represents a defined method that handles the AutoFilteringColumn event for the Spread component.
    Delegate Represents a defined method that handles the AutoSortedColumn event for the Spread component.
    Delegate Represents a defined method that handles the AutoSortingColumn event for the Spread component.
    Delegate Represents a defined method that handles the BeforeSettingPropertyValue event.
    Delegate Represents a defined method that handles the CalculateException event.
    Delegate Represents a defined method that handles the CellClick and CellDoubleClick events for the Spread component.
    Delegate Represents a defined method that handles the error text change event for a cell.
    Delegate Represents a defined method that handles the Change event for the Spread component.
    Delegate Represents a defined method that handles the child control related events for the Spread component.
    Delegate Represents a defined method that handles the ChildViewCreated event for the Spread component.
    Delegate Represents a defined method that handles the ChildWorkbookCreated event for the Spread component.
    Delegate The handler for the CircularCellChanged event.
    Delegate The handler for the Spread CirculaFormula event.
    Delegate Represents the method that handles an event after the group is cleared.
    Delegate Event handler for ClipboardPasted event.
    Delegate Represents a defined method that handles the ClipboardPasting event for the Spread component.
    Delegate Represents a defined method that handles the ColumnViewportWidthChanged event for the Spread component.
    Delegate Represents a defined method that handles the ColumnWidthChanged event for the Spread component.
    Delegate Represents a defined method that handles the ColumnWidthChanging event for the Spread component.
    Delegate Represents a method that handles the conditional formatting Changed events.
    Delegate Represents a method that handles the custom name events.
    Delegate Represents a defined method that handles the DataColumnConfigure event for the Spread component.
    Delegate Represents the method that handles the DialogChar event of a Spread component.
    Delegate Represents the method that handles the DialogKey event of a Spread component.
    Delegate Represents a defined method that handles the DragDrop event for the Spread component.
    Delegate Represents a defined method that handles the DragDropBlock event for the Spread component.
    Delegate Represents a defined method that handles the DragFillBlockCompleted event for the Spread component.
    Delegate Represents a defined method that handles the DragFillBlock event for the Spread component.
    Delegate Represents a defined method that handles the ColumnDragMoveCompleted or RowDragMoveCompleted event for the Spread component.
    Delegate Represents 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.
    Delegate Represents a defined method that handles the EditError events for the Spread component.
    Delegate Represents a defined method that handles the EditModeStarting event for the Spread component.
    Delegate Represents a defined method that handles the ButtonClicked, ComboCloseUp, ComboDropDown, ComboSelChange, and EditChange events for the Spread component.
    Delegate Represents a defined method that handles the element changing event for the status bar.
    Delegate Represents a defined method that handles the EnterCell event for the Spread component.
    Delegate Represents a defined method that handles the Error events for the Spread component.
    Delegate Represents a defined method that handles the Expand event for the Spread component.
    Delegate Represents a defined method that handles the CellClick and CellDoubleClick events for the Spread component.
    Delegate Represents a defined method that handles the FpScrollBarButtonClickEventArgs event for the Spread component.
    Delegate Represents the delegate for measuring size of an icon for the icon conditional formatting rule in a cell.
    Delegate Represents a defined method that handles the Grouping event in the Spread component.
    Delegate Represents a defined method that handles the HyperLinkClicked event for the Spread component.
    Delegate Represents the method that handles an event after the item is operated on.
    Delegate Represents a defined method that handles the LeaveCell event for the Spread component.
    Delegate Represents 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.
    Delegate Represents a defined method that handles the NamedStyleCollection object's Changed event.
    Delegate Represents a method that handles the note events.
    Delegate Represents a defined method that handles the PaintBackground event for the Spread component.
    Delegate Represents a defined method that handles the PaintGroupBarBackground event in the Spread component.
    Delegate Represents a defined method that handles the PaintTabStrip event for the Spread component.
    Delegate Represents a defined method that handles the PaintTabStrip event for the Spread component.
    Delegate Represents a defined method that handles the PaintTabStripTab event for the Spread component.
    Delegate Represents a defined method that handles the PreviewRowFetch event for the Spread component.
    Delegate Represents a defined method that handles the PrintAbort event for the Spread component.
    Delegate Represents a defined method that handles the PrintBackground event for the Spread component.
    Delegate Represents a defined method that handles the PrintCancelled event for the Spread component.
    Delegate Represents a defined method that handles the PrintDocument event for the Spread component.
    Delegate Represents a defined method that handles the PrintHeaderFooterArea event for the Spread component.
    Delegate Represents a defined method that handles the PrintMessageBox event for the Spread component.
    Delegate Represents a defined method that handles the PrintPreviewShowing event for the Spread component.
    Delegate Represents an event handler which is raised when the property has changed and has infomation about the current value and the previous value.
    Delegate Represents a defined method that handles the QueryValue event.
    Delegate Handles the Changed event for the outline (range group) model for the sheet.
    Delegate Represents a defined method that handles the RangeGroupStateChanged event for an outline (range group) of the Spread component.
    Delegate Represents a defined method that handles the RangeGroupStateChanging event for an outline (range group) of the Spread component.
    Delegate 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.
    Delegate Represents a defined method that handles the error text change event for a row.
    Delegate Represents a defined method that handles the RowHeightChanged event for the Spread component.
    Delegate Represents a defined method that handles the ColumnWidthChanging event for the Spread component.
    Delegate Represents a defined method that handles the RowViewportHeightChanged event for the Spread component.
    Delegate Represents a defined method that handles the ScrollTipFetch event for the Spread component.
    Delegate Represents a defined method that handles the SelectionChanged events for the Spread component.
    Delegate Represents a defined method that handles the SelectionChanging events for the Spread component.
    Delegate Represents a defined method that handles the SheetDragMoved event for the Spread component.
    Delegate Represents a defined method that handles the SheetDragMoving event for the Spread component.
    Delegate Represents a defined method that handles the SheetTabClick event for the Spread component.
    Delegate 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.
    Delegate Represents a method that handles the sheet events.
    Delegate Represents a defined method that handles sheet property change events.
    Delegate Represents a defined method that handles the Sorted event for the Spread component.
    Delegate Represents a defined method that handles the Sorting event for the Spread component.
    Delegate 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.
    Delegate Obsolete. Use NoteEventHandler instead. Represents a method that handles the sticky note events.
    Delegate Internal use only.
    Delegate Represents a defined method that handles the SubEditorClosed event for the Spread component.
    Delegate Represents a defined method that handles the SubEditorOpening event for the Spread component.
    Delegate Handles the table property changed event.
    Delegate The TableStyleCollectionChangedEventArgs handler.
    Delegate Represents a defined method that handles the TextTipFetch event for the Spread component.
    Delegate Represents a defined method that handles the TopChange event for the Spread component.
    Delegate Represents a defined method that handles the UserFormulaEntered event for the Spread component.
    Delegate Represents a defined method that handles the UserZooming event for the Spread component.
    Enumerations
     EnumerationDescription
    Enumeration Specifies settings for the automatic filter.
    Enumeration Specifies how the borders of adjacent cells are displayed in the view.
    EnumerationSpecifies how FpSpread reacts when the manipulation has gone beyond certain boundaries.
    Enumeration Specifies how to display buttons in cells for button and combo box cell types.
    Enumeration Indicates the policy of the calculation controller.
    Enumeration Specifies the horizontal alignment of the cell contents.
    Enumeration Represents the CellRange type.
    Enumeration Sets the type of selection model when working with spans.
    Enumeration Specifies the vertical alignment of the cell contents.
    Enumeration Specifices the type of centering for the printed page.
    Enumeration Specifies the type of change (movement) of the scroll bar button.
    Enumeration Represents the origin of the source of the Clipboard data.
    Enumeration Specifies what data is copied to the Clipboard.
    Enumeration Specifies which headers are included when data is copied to or pasted from the Clipboard.
    Enumeration Specifies what data is pasted from the Clipboard.
    Enumeration Represents the CodeDom strategies.
    Enumeration Specifies which UITypeEditor to invoke directly at runtime.
    Enumeration Defines the operators which are used to compare strings.
    Enumeration Specifies the operator for conditional formats.
    Enumeration Specifies the type of Changed event that has occurred for conditional formatting.
    Enumeration Represents the predefined icon for conditional formatting.
    Enumeration Represents the style of the icon set.
    Enumeration Specifies the type of Change event that has occurred for a conditional formatting model for the sheet.
    Enumeration Represents 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.
    Enumeration Specifies the operator for custom filtering.
    Enumeration Specifies how to process the data when a custom name changes.
    Enumeration Represents the axis position for the data bar.
    Enumeration Specifies the part of the date time value used in a comparision.
    Enumeration Specifies the type of DragFill mode.
    Enumeration Specifies a value that indicates the type of dynamic filter.
    Enumeration Specifies the possible editor messages based on the user action.
    Enumeration Specifies the element alignment for the status bar.
    Enumeration Specifies settings for sorting items in an enhanced filter.
    Enumeration Specifies the button style.
    Enumeration Specifies the shape of sheet tabs.
    Enumeration Represents optional behaviors of the enhanced shape engine.
    EnumerationSpecifies the direction of the filling of cells.
    Enumeration Specifies how the row filter behaves.
    Enumeration Specifies the state of filtering for the current column so the column renderer knows which filtering image to draw.
    Enumeration Defines the moving active cell while editing cell enumeration.
    Enumeration Represents the tabs of the format cell form.
    Enumeration Specifies whether horizontal or vertical grid lines or both are displayed on the sheet.
    Enumeration Specifies the type of grid lines.
    Enumeration Specifies the status of an outline (range group).
    Enumeration Specifies the default labels to display in headers.
    Enumeration Specifies the locations in the component for the HitTest method.
    EnumerationSpecifies the horizontal position of the cell or column in the component.
    Enumeration Indicates the input device type.
    Enumeration Specifies the condition for which an input map applies.
    Enumeration Represents options for backward compatibility.
    Enumeration Defines the units that are used to validate the text length.
    Enumeration Specifies the type of change event that has occurred for the style in the collection.
    Enumeration Specifies the type of contents of a cell.
    Enumeration Specifies the position of the cell note indicator.
    Enumeration Specifies how the cell notes are displayed.
    Enumeration Specifies how the sheet responds to user interaction and what selections are allowed.
    Enumeration Specifies the output mode for printing the sheet as PDF.
    Enumeration Specifies the output for printing the sheet as PDF.
    Enumeration Specifies the options when getting the preferred width for the column.
    Enumeration Specifies the options when getting the preferred height for the row.
    Enumeration Represents the type of PrintDocument event which occurs during the print process of the sheetview.
    Enumeration Specifies whether the header is printed.
    Enumeration Specifies how cell notes are printed.
    Enumeration Specifies the page orientation used to print the sheet.
    Enumeration Specifies the order in which pages are printed.
    Enumeration Specifies whether the title is printed.
    Enumeration Specifies the type of print range used to print the sheet.
    Enumeration Specifies the button style for an outline (range group) of rows or columns.
    Enumeration Specifies the type of Change event that has occurred for the outline (range group) model for the sheet.
    Enumeration Specifies the type of change that has occurred for an outline (range group) for the sheet.
    Enumeration Specifies whether regular, bold, or italic font styles are applied to the text.
    Enumeration Specifies whether the rules or a particular rule should reset before testing the next rule.
    Enumeration 
    Enumeration 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.
    Enumeration Specifies how to save spreadsheet data to an XML file.
    Enumeration Specifies the type of DPI scale support.
    Enumeration Specifies the type of scroll bar buttons by specifying which elements of the scroll bar are displayed.
    Enumeration Specifies when the component displays the scroll bars.
    Enumeration Specifies whether the component scrolls the sheet when the user moves the scroll box.
    Enumeration Specifies how to display the current row number in scrolling content.
    Enumeration Specifies whether the component displays the text tip when the user moves the scroll box.
    Enumeration Specifies where the search string is found.
    Enumeration Specifies which part of the sheet can be selected by the user.
    Enumeration Specifies the style for the display of selected cells.
    Enumeration Specifies the position of the image on viewport.
    Enumeration Specifies the type that is sorted.
    Enumeration The mode used to specify the sorting behavior.
    Enumeration Specifies the sorting state for the current column so the column renderer knows which sorting image to draw.
    Enumeration An enumeration that specifies information about how the vertical axis minimum or maximum is computed for this sparkline group.
    Enumeration Represents the type of sparkline.
    Enumeration Specifies the placement of split boxes in the component with respect to their alignment with the scroll bars.
    Enumeration Specifies when the component displays the split boxes.
    EnumerationSpecifies how FpSpread reacts to touch manipulation.
    Enumeration Specifies whether the strikeout font style is applied to the text.
    Enumeration Internal use only.
    EnumerationSpecifies a system sound type which relates to a System.Media.SystemSound.
    Enumeration The table style changed collection type.
    Enumeration Specifies the sheet tab buttons.
    Enumeration Specifies the display policy for the tab strip buttons.
    Enumeration Specifies the location of the tab strip in the component.
    Enumeration Specifies when the component displays the sheet name tabs.
    Enumeration Represents operators applied for text conditional formatting.
    Enumeration Specifies how to process the data when saving to a text file.
    Enumeration Specifies how the text tip of a cell in the view is displayed, and also how the cell note is displayed.
    Enumeration 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.
    EnumerationSpecifies what area to display the SpreadTouchStrip.
    Enumeration Represents the unary comparison operator.
    Enumeration Specifies whether the underline font style is applied to the text.
    Enumeration Specifies the binary operations between the target value and the compared value when validating a cell.
    Enumeration Specifies the reasons that cause an action to execute.
    Enumeration Defines 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