Spread Windows Forms 17
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace
Inheritance Hierarchy
In This Topic
    GrapeCity.Spreadsheet Namespace
    In This Topic
    Classes
     ClassDescription
    ClassThe class intend not to be used directly in user code.
    ClassRepresents a list of authors.
    ClassRepresents autofiltering for the specified worksheet.
    ClassRepresents a built-in conditional formatting rule.
    Class 
    ClassRepresents all built-in number formats.
    ClassRepresents a class which store, evaluate or adjust expressions. Represents util functions for calculation.
    ClassRepresents an attributes that allow to specify the cell inline image data.
    ClassThis class implements the function to store values in the locations of a sparse matrix.
    ClassRepresents the data source which binds to the specified cell range via a reference or a defined name.
    ClassRepresents a class which stores cell calculated information.
    Class 
    ClassRepresents a classic conditional formatting rule.
    ClassRepresents a strongly typed list of objects that can be accessed by index.
    ClassThis element specifies the color to filter by and whether to use the cell's fill or font color in the filter criteria. If the cell's font or fill color does not match the color specified in the criteria, the rows corresponding to those cells are hidden from view.
    ClassRepresents the color manager of the IWorkbookSet object.
    Class 
    Class 
    ClassRepresents the color stop point for a gradient fill in a range or selection.
    Class 
    Class 
    Class 
    ClassRepresents a conditional formatting which apply a set of rules to a set of range references.
    ClassRepresents the event argument for confirming user's option.
    ClassWhen there is more than one custom filter criteria to apply (an 'and' or 'or' joining two criteria), then this element groups the customFilter elements together
    ClassRepresents the data bar conditional formatting rule.
    ClassRepresent for the data valiation information.
    ClassRepresents the data validations associated with the specified Worksheet.
    Class 
    Class 
    ClassRepresents a defined name.
    Class 
    ClassRepresents the display settings for an associated Range object.
    ClassRepresents all properties of the spreadsheet document.
    ClassThis collection specifies dynamic filter criteria. These criteria are considered dynamic because they can change, either with the data itself (e.g., "above average") or with the current system date (e.g., show values for "today"). For any cells whose values do not meet the specified criteria, the corresponding rows shall be hidden from view when the filter is applied.
    ClassRepresents a view of cell range in worksheet which all cell values are calculated by a specified formula.
    ClassRepresents a cell in the ExpressionView.
    ClassRepresents a external variable.
    ClassRepresents a spreadsheet factory for customizable types.
    ClassRepresents all customizable features of Spread.
    ClassRepresents the base class for filter.
    Class 
    ClassRepresents the conditional formats associated with the specified Worksheet.
    ClassRepresents a hyperlink.
    ClassThis element specifies the icon set and particular icon within that set to filter by. For any cells whose icon does not match the specified criteria, the corresponding rows shall be hidden from view when the filter is applied.
    ClassClass IconSetConditionalFormattingRule. This class cannot be inherited.
    ClassRepresents the roaring bitmap data structure.
    ClassRepresents an one dimension array data structure which is stored as intervals.
    ClassRepresents an one dimension array data structure which is stored as intervals.
    ClassRepresents the layout manager.
    ClassWhen multiple values are chosen to filter by, or when a group of date values are chosen to filter by, this element groups those criteria together.
    ClassRepresents a strongly typed list of objects that can be accessed by index or string key.
    Class 
    ClassRepresents page break information used for print layout view, page layout view, drawing print breaks in normal view, and for printing the worksheet.
    ClassRepresents the rich text.
    ClassRepresents a sort of a range of data.
    Class 
    ClassRepresents a sparkline.
    ClassRepresents the data source of a sparkline.
    ClassRepresents a group of sparklines.
    ClassRepresents settings for sparklines.
    ClassRepresents the sparkline storage
    ClassThe class intend not to be used directly in user code.
    ClassRepresents a collection of all styles in the workbook.
    Class 
    ClassRepresents a table of the worksheet.
    ClassRepresents a Tables which manages all Table tables in the specified Worksheet.
    ClassRepresents a single style that can be applied to a table.
    Class 
    ClassThis element specifies the top N (percent or number of items) to filter by.
    ClassInternal use only.
    ClassRepresents a workbook.
    ClassRepresents a workbook base.
    ClassRepresents a set of workbooks which may refer to each other by external cell references or external defined name references.
    ClassRepresents a worksheet.
    ClassRepresents a worksheet base.
    ClassRepresents the container for worksheet functions that can be called from application.
    ClassRepresents all options of the IWorksheet object.
    ClassRepresents a worksheet view.
    Interfaces
     InterfaceDescription
    InterfaceSupports cloning, which creates a new instance of a class with the same value as an existing instance.
    InterfaceRepresents an above average visual of a conditional formatting rule.
    InterfaceRepresents a collection of alternating styles.
    InterfaceRepresents a collection of the areas, or contiguous blocks of cells, within a selection.
    InterfaceRepresents an array of items which are declared as T type.
    InterfaceRepresents the author of the ICommentThreaded object.
    InterfaceRepresents the filter for the specified worksheet.
    InterfaceRepresents an object which contains an AutoFilter.
    InterfaceRepresents the border of an object.
    InterfaceA collection of Border objects that represent the four borders of a Range or Style object.
    InterfaceRepresents the cell type of a cell.
    InterfaceRepresents characters in an object that contains text.
    InterfaceRepresents the color palette that contains indexed colors.
    Interface 
    InterfaceA collection of ColorScaleCriterion objects that represents all of the criteria for a color scale conditional format. Each criterion specifies the minimum, midpoint, or maximum threshold for the color scale.
    InterfaceRepresents the criteria for the minimum, midpoint, or maximum thresholds for a color format conditional format.
    InterfaceA collection of all the ColorStop objects for the specified series.
    InterfaceRepresents the column footer of a worksheet.
    InterfaceRepresents the column header of a worksheet.
    InterfaceRepresents a cell comment.
    InterfaceRepresents a collection of cell comments.
    InterfaceRepresents a collection of top-level ICommentThreaded objects in a worksheet, or a collection of replies in a single threaded comment.
    InterfaceRepresents a cell's threaded comment. This object can represent both a top-level comment or its replies.
    InterfaceRepresents an interface for other products to extend composable data of Worksheet.
    InterfaceRepresents how the shortest bar or longest bar is evaluated for a data bar conditional formatting rule.
    InterfaceRepresents a data bar conditional formatting rule.
    InterfaceRepresents the border of the data bars specified by a conditional formatting rule.
    InterfaceRepresents the data manager of a worksheet.
    InterfaceRepresents the editor of a cell.
    InterfaceRepresents an interface for other products to extend data of Worksheet.
    InterfaceRepresents a filter for a single column.
    InterfaceRepresents a collection of IFilter objects that represents all the filters in an auto filtered range.
    InterfaceContains the font attributes (font name, font size, color, and so on) for an object.
    InterfaceRepresents a conditional format.
    InterfaceRepresents the collection of conditional formats for a single range.
    InterfaceRepresents the value formatter.
    InterfaceContains the font attributes (font name, font size, color, and so on) for an object.
    InterfaceContains properties that apply to header and footer picture objects.
    InterfaceRepresents a hyperlink.
    InterfaceRepresents the collection of hyperlinks for a worksheet or range.
    InterfaceRepresents the collection of IconCriterion objects. Each IconCriterion represents the values and threshold type for each icon in an icon set conditional formatting rule.
    InterfaceRepresents the criterion for an individual icon in an icon set. The criterion specifies the range of values and the threshold type associated with the icon in an icon set conditional formatting rule.
    InterfaceRepresents an icon set conditional formatting rule.
    InterfaceRepresents the interior of an object.
    InterfaceRepresents an embedded resource.
    InterfaceRepresents a defined name.
    InterfaceRepresents a collection of all the IName objects in the workbook.
    InterfaceRepresents the color settings of the data bars for negative values that are defined by a data bar conditional formatting rule.
    InterfaceRepresents extend data for NumberFormat.
    InterfaceRepresents the cell type of a cell which supports NumberFormat.
    InterfaceRepresents an outline on a worksheet.
    InterfaceRepresents the various types of protection options available for a worksheet.
    InterfaceInterface that represent a range of a worksheet.
    InterfaceRepresents a read-only array of items which are declared as T type.
    InterfaceRepresents the row header of a worksheet.
    InterfaceRepresents a sheet in the workbook.
    InterfaceRepresents a collection of all the sheets in the specified or active workbook.
    InterfaceRepresents a sheet view.
    InterfaceRepresents a sort of a range of data.
    InterfaceRepresents a custom sort comparer.
    InterfaceRepresent an object contains all the sort information for the IWorksheet, ITable, and IAutoFilter objects.
    InterfaceRepresents the collection of ISortField objects.
    InterfaceRepresents the settings for the horizontal and vertical axes of a group of sparklines.
    InterfaceRepresents the color of the horizontal axis and the markers for points in a sparkline.
    InterfaceRepresents the settings for the horizontal axes of a group of sparklines.
    InterfaceRepresents a single sparkline.
    InterfaceRepresents a group of sparklines.
    InterfaceRepresents a collection of sparkline groups.
    InterfaceRepresents the settings of the markers for points of data on a sparkline.
    InterfaceRepresents the settings for the vertical axes of a group of sparklines.
    InterfaceRepresent an abstract spreadsheet.
    InterfaceRepresents the appearance of the cells in the worksheet.
    InterfaceRepresents a collection of all styles in the workbook.
    InterfaceRepresents a table of the worksheet.
    InterfaceRepresents a column in a table.
    InterfaceRepresents a collection of all the ITableColumn objects in the specified ITable object.
    InterfaceRepresents a row in a table.
    InterfaceRepresents a collection of all the table rows in the specified table.
    InterfaceRepresents an ITables object which manages all ITable tables in the specified IWorksheet.
    InterfaceRepresents a single style that can be applied to a table.
    InterfaceRepresents a single table style element.
    InterfaceRepresents table style elements.
    InterfaceRepresents styles that can be applied to a table.
    InterfaceRepresents a top ten visual of a conditional formatting rule. Applying a color to a range helps you see the value of a cell relative to other cells.
    InterfaceThe UniqueValues object uses the DupeUnique property to Gets or sets an enum that determines whether the rule should look for duplicate or unique values in the range.
    InterfaceRepresents data validation for a worksheet range.
    InterfaceRepresents a workbook.
    InterfaceRepresents a set of workbooks in a workbook set.
    InterfaceRepresents a set of workbooks which may refer to each other by external cell references or external defined name references.
    InterfaceRepresents a worksheet.
    InterfaceRepresents a set of worksheets in a workbook.
    InterfaceRepresents a collection of all styles in the worksheet.
    InterfaceRepresents a worksheet view.
    InterfaceRepresents the container which contains this NamedObjectCollection<TItem,TContainer> collection.
    InterfaceRepresents the type of elements in this NamedObjectCollection<TItem,TContainer> collection.
    Structures
     StructureDescription
    StructureRepresents the executing result of an action.
    Structure 
    StructureThe FilterColumn collection identifies a particular column in the AutoFilter range and specifies filter information that has been applied to this column. If a column in the AutoFilter range has no criteria specified, then there is no corresponding filterColumn collection expressed for that column.
    StructureRepresents the border of an object.
    StructureRepresent the line settings of border.
    StructureRepresents a page break information.
    Structure 
    StructureRepresents a reference to a position of cell.
    StructureRepresents the matched conditional formatting result.
    StructureRepresents a single icon of an icon set.
    Structure 
    StructureStores an ordered pair of integers.
    StructureStruct ColorData
    StructureA custom AutoFilter specifies an operator and a value. There can be at most two customFilters specified, and in that case the parent element specifies whether the two conditions are joined by 'and' or 'or'. For any cells whose values do not meet the specified criteria, the corresponding rows shall be hidden from view when the fitler is applied.
    Structure 
    StructureRepresents a suggested data for the cell.
    StructureThis collection is used to express a group of dates or times which are used in an AutoFilter criteria
    StructureRepresent the fill formatting.
    StructureRepresents all filter data of a filter column.
    StructureRepresents a date time value and its corresponding IFormatter in the worksheet.
    StructureDefines a particular format for text, including font face, size, and style attributes.
    StructureRepresents the formatting value result.
    StructureRepresents the gradient fill effect.
    StructureRepresents the gradient stop.
    StructureRepresents number format properties which indicate how to format and render the numeric value of a cell
    StructureRepresents a reference to a range of cells.
    StructureRepresents all style settings of the cell.
    StructureRepresents a table column.
    StructureRepresents a single table style element.
    StructureRepresents a reference to a range of cells in the specified worksheet.
    Enumerations
     EnumerationDescription
    EnumerationSpecifies if the values are above or below average.
    EnumerationSpecifies all attributes of the Alignment value.
    EnumerationSpecifies how the target range is to be filled, based on the contents of the source range.
    EnumerationSpecifies the operator to use to associate two criteria applied by a filter.
    EnumerationProperties of axis
    EnumerationRepresents the behaviors of operations.
    EnumerationRepresents the line style of border.
    EnumerationRepresents the side of border.
    EnumerationSpecifies the border to be retrieved.
    EnumerationRepresents all built-in slicer styles.
    EnumerationRepresents all built-in styles.
    EnumerationRepresents all built-in table styles.
    EnumerationRepresents all available features of the calculation engine.
    EnumerationRepresents when calculation engine should calculate formulas in the spreadsheet.
    EnumerationSpecifies whether invidiual cells are re-calculated.
    Enumeration 
    EnumerationRepresents the data type of a cell in the ExpressionView.
    EnumerationRepresents the cell protection attributes.
    EnumerationRepresents options for rendering a cell.
    EnumerationSpecifies the types of condition values that can be used.
    EnumerationDefines the possible sets of character glyphs that are defined in fonts for graphics output.
    EnumerationRepresents protection options of a chart sheet.
    Enumeration 
    EnumerationSpecifies the color format type.
    EnumerationSpecifies how a column is to be parsed.
    EnumerationRepresents compatibility options for spreadsheet.
    EnumerationSpecifies the text operator used in a function.
    EnumerationSpecifies the comparison operation to be performed.
    EnumerationSpecifies whether status is Copy mode or Cut mode.
    EnumerationRepresents the axis position for the data bar.
    EnumerationSpecifies the border of a data bar.
    EnumerationSpecifies a value indicating whether the axis appears from right to left.
    EnumerationSpecifies how a data bar is filled with color.
    EnumerationSpecifies whether to use the same border and fill color as postive data bars.
    EnumerationSpecifies the reason for an unaccepted expression or value.
    EnumerationThe style of data validation error alert.
    EnumerationThe relational operator used in data validation.
    EnumerationSpecifies the type of data validation used to validate user input.
    EnumerationSpecifies the part of the date time value used in a comparision.
    EnumerationRepresents the choise to delete cells.
    EnumerationSpecifies the direction in which to move.
    EnumerationSpecifies how empty cells are plotted.
    EnumerationRepresents the display style of a value.
    EnumerationSpecifies whether duplicate or unique values shoud be displayed.
    EnumerationSpecifies the type of dynamic filter to be applied.
    EnumerationSpecifies what can be selected on the sheet.
    EnumerationRepresents the filter mode which UI should be displayed.
    EnumerationRepresents the filtering options for querying defined names.
    EnumerationRepresents the filtering scopes for querying defined names.
    EnumerationSpecifies the type of data to search.
    EnumerationRepresents all attributes of a font.
    EnumerationThe FamilyFont enumeration specifies the font family. Font families describe the look of a font in a general way. They are intended for specifying fonts when the exact typeface desired is not available.
    EnumerationRepresents the style of the typeface of a font.
    EnumerationRepresents all formatted color values.
    EnumerationSpecifies the operator to use to compare a formula against the value in a cell or, for Between and NotBetween , to compare two formulas.
    EnumerationSpecifies whether the conditional format is based on a cell value or an expression.
    EnumerationRepresents advanced options for formatting value to text.
    EnumerationType of gradient fill being used, either linear or path.
    EnumerationEnum the horizontal alignment of a cell or object.
    EnumerationSpecifies the type of hyperlink.
    Enumeration 
    EnumerationSpecifies a value that determines the Input Method Editor (IME) status.
    EnumerationSpecifies from where to copy the format for inserted cells.
    EnumerationRepresents the choice to insert cells.
    EnumerationSpecifies whether a match is made against the whole of the search text or any part of the search text.
    EnumerationIndicates which data type will be performed.
    EnumerationSpecifies how the control handles automatic merging of cells based on the values in the cells.
    EnumerationRepresents the position of the new row.
    EnumerationRepresents the comparison operator.
    EnumerationSpecifies page break location in the worksheet.
    EnumerationSpecifies how numeric data will be calculated with the destinations cells on the worksheet.
    EnumerationSpecifies the part of the range to be pasted.
    EnumerationRepresents the Fill pattern type.
    EnumerationRepresents predefined cell number formats.
    EnumerationRepresents the protection type of the workbook or worksheet.
    EnumerationSpecifies the reference style in formulas and custom names in the sheet.
    EnumerationSpecifies the search direction when searching a range.
    EnumerationSpecifies the order in which to search the range.
    EnumerationRepresents the view type of a IWorksheetView.
    EnumerationSpecifies whether the worksheet is visible.
    EnumerationSpecifies how to sort text.
    EnumerationSpecifies the sort method for Chinese languages.
    EnumerationRepresents which data will be sorted.
    EnumerationRepresents whether to sort in ascending order or descending order.
    EnumerationRepresents the sort orientation.
    EnumerationSpecifies how to plot the sparkline when the data on which it is based is in a square-shaped range.
    EnumerationSpecifies how the minimum or maximum value of the vertical axis of the sparkline is scaled relative to other sparklines in the group.
    EnumerationSpecifies the type of sparkline.
    EnumerationSpecifies cells with a particular type of value to include in the result.
    EnumerationSpecifies the type of cells.
    Enumeration 
    EnumerationSpecifies the location of the summary columns in the outline.
    EnumerationSpecifies the location of the summary rows in the outline.
    EnumerationRepresents the table style element's type.
    Enumeration 
    EnumerationSpecifies the type of a table.
    EnumerationSpecifies the column format for the data in the text file that you are importing into a query table.
    EnumerationSpecifies the delimiter to use to specify text.
    EnumerationSpecifies the reading order.
    EnumerationRepresents the theme font within the theme. The theme font consists of a pair of major and minor fonts for which to used in a document.
    EnumerationRepresents a time period which is used in date conditions.
    EnumerationSpecifies the top 10 values from the top or bottom of a series of values.
    EnumerationAn enumeration that specifies what function is used to aggregate the data in a column before it is displayed in the totals row.
    EnumerationSpecifies the underline style of text.
    EnumerationSpecifies a workbook's setting for updating embedded links.
    EnumerationSpecifies the vertical alignment of text.
    EnumerationSpecifies the vertical alignment of text line.
    EnumerationRepresent protected data of the workbook.
    EnumerationRepresents protection options of a worksheet.
    EnumerationSpecifies the type of worksheet headers and footers.
    EnumerationSpecifies the worksheet type.
    EnumerationRepresents the choice to perform an action.
    EnumerationSpecifies whether or not the first row contains headers.
    See Also