Spread Windows Forms 12.0 Product Documentation
GrapeCity.Spreadsheet Namespace
Inheritance Hierarchy
GrapeCity.Spreadsheet Assembly : GrapeCity.Spreadsheet Namespace
Provides the namespaces, classes and enumerations for the spreadsheet features.
Classes
 ClassDescription
Class 
ClassRepresents a class which store, evaluate or adjust expressions. 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.
ClassRepresents the data validations associated with the specified Worksheet.
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 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 the filter for the specified worksheet.
InterfaceRepresents the border of an object.
InterfaceA collection of Border objects that represent the four borders of a Range or Style object.
InterfaceSupports cloning, which creates a new instance of a class with the same value as an existing instance.
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 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.
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 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 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.
Interface 
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 range of cells.
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.
Enumerations
 EnumerationDescription
EnumerationSpecifies if the values are above or below average.
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.
Enumeration 
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.
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.
Enumeration 
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.
Enumeration 
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.
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.
Enumeration 
EnumerationSpecifies a value that determines the Input Method Editor (IME) status.
EnumerationIndicates which data type will be performed.
EnumerationRepresents the comparison operator.
EnumerationSpecifies page break location in the worksheet.
EnumerationRepresent tie Fill pattern type.
EnumerationRepresents the protection type of the workbook or worksheet.
EnumerationSpecifies the reference style in formulas and custom names in the sheet.
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.
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 
Enumeration 
Enumeration 
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.
Enumeration 
EnumerationRepresent protected data of the workbook.
EnumerationRepresents protected data of the worksheet.
EnumerationSpecifies the worksheet type.
EnumerationRepresents the choice to perform an action.
EnumerationSpecifies whether or not the first row contains headers.
See Also

Reference

GrapeCity.Spreadsheet Assembly