Spread Windows Forms 14.0
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace
Inheritance Hierarchy
In This Topic
    GrapeCity.Spreadsheet Namespace (GrapeCity.Spreadsheet)
    In This Topic
    Classes
     ClassDescription
    Class 
    ClassRepresents all built-in number formats.
    ClassRepresents util functions for calculation. This class cannot be inherited.
    ClassRepresents a class which stores cell calculated information. This class cannot be inherited.
    Class 
    Class 
    Class 
    ClassRepresents the color stop point for a gradient fill in a range or selection. This class cannot be inherited.
    ClassRepresents the event argument for confirming user's option.
    Class 
    ClassRepresents the display settings for an associated Range object. This class cannot be inherited.
    ClassRepresents a view of cell range in worksheet which all cell values are calculated by a specified formula.
    ClassRepresents a cell in the ExpressionView. This class cannot be inherited.
    ClassRepresents a external variable.
    ClassRepresents a spreadsheet factory for customizable types.
    ClassRepresents all customizable features of Spread. This class cannot be inherited.
    ClassRepresents page break information used for print layout view, page layout view, drawing print breaks in normal view, and for printing the worksheet. This class cannot be inherited.
    Interfaces
     InterfaceDescription
    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 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 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 how the shortest bar or longest bar is evaluated for a data bar conditional formatting rule.
    InterfaceRepresents a data bar conditional formating 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 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 formating rule.
    InterfaceRepresents an outline on 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 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 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.
    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.
    Structure 
    Structure 
    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 
    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 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 the operator to use to associate two criteria applied by a filter.
    EnumerationRepresents the behaviors of operations.
    EnumerationEnum the line style for 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.
    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.
    Enumeration 
    EnumerationSpecifies the color format type.
    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.
    EnumerationSpecifies the direction in which to move.
    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.
    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 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.
    EnumerationRepresents the Fill pattern type.
    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.
    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 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 protected data of the 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