| Class | Description | |
|---|---|---|
 | BuiltInNumberFormats | |
| CalculationEngine | Represents a class which store, evaluate or adjust expressions. This class cannot be inherited. |
| CfRule | |
| ColorManager | |
| ColorResolver | |
| ColorStop | Represents the color stop point for a gradient fill in a range or selection. This class cannot be inherited. |
| ConfirmationEventArgs | Represents the event argument for confirming user's option. |
| DataValidations | Represents the data validations associated with the specified Worksheet. |
| DifferentialFormat | |
| DisplayFormat | Represents the display settings for an associated Range object. This class cannot be inherited. |
| ExpressionView | Represents a view of cell range in worksheet which all cell values are calculated by a specified formula. |
| ExpressionViewCell | Represents a cell in the ExpressionView. This class cannot be inherited. |
| ExternalVariable | Represents a external variable. |
| Factory | Represents a spreadsheet factory for customizable types. |
| Features | |
| PageBreaks | Represents 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. |
GrapeCity.Spreadsheet Namespace (GrapeCity.Spreadsheet)
In This Topic
Provides the namespaces, classes and enumerations for the spreadsheet features.
Classes
Interfaces
| Interface | Description | |
|---|---|---|
 | IAboveAverage | Represents an above average visual of a conditional formatting rule. |
| IAlternatingStyles | |
| IAreas | Represents a collection of the areas, or contiguous blocks of cells, within a selection. |
| IArray<T> | |
| IAutoFilter | Represents the filter for the specified worksheet. |
| IBorder | Represents the border of an object. |
| IBorders | A collection of Border objects that represent the four borders of a Range or Style object. |
| ICellType | |
| IColorPalette | Represents the color palette that contains indexed colors. |
| IColorScale | |
| IColorScaleCriteria | A 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. |
| IColorScaleCriterion | Represents the criteria for the minimum, midpoint, or maximum thresholds for a color format conditional format. |
| IColorStops | A collection of all the ColorStop objects for the specified series. |
| IColumnFooter | Represents the column footer of a worksheet. |
| IColumnHeader | Represents the column header of a worksheet. |
| IConditionValue | Represents how the shortest bar or longest bar is evaluated for a data bar conditional formatting rule. |
| IDatabar | Represents a data bar conditional formating rule. |
| IDatabarBorder | Represents the border of the data bars specified by a conditional formatting rule. |
| IFilter | Represents a filter for a single column. |
| IFilters | Represents a collection of IFilter objects that represents all the filters in an auto filtered range. |
| IFont | Contains the font attributes (font name, font size, color, and so on) for an object. |
| IFormatCondition | Represents a conditional format. |
| IFormatConditions | Represents the collection of conditional formats for a single range. |
| IFormatter | Represents the value formater. |
| IGradient | Contains the font attributes (font name, font size, color, and so on) for an object. |
| IIconCriteria | Represents the collection of IconCriterion objects. Each IconCriterion represents the values and threshold type for each icon in an icon set conditional formatting rule. |
| IIconCriterion | Represents 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. |
| IIconSetCondition | Represents an icon set conditional formatting rule. |
| IInterior | Represents the interior of an object. |
| IName | Represents a defined name. |
| INames | Represents a collection of all the IName objects in the workbook. |
| INegativeBarFormat | Represents the color settings of the data bars for negative values that are defined by a data bar conditional formating rule. |
| IOutline | Represents an outline on a worksheet. |
| IRange | Interface that represent a range of a worksheet. |
| IReadonlyArray<T> | |
| IRowHeader | Represents the row header of a worksheet. |
| ISort | Represents a sort of a range of data. |
| ISortComparer | |
| ISortField | Represent an object contains all the sort information for the IWorksheet, ITable, and IAutoFilter objects. |
| ISortFields | |
| IStyle | Represents the appearance of the cells in the worksheet. |
| IStyles | Represents a collection of all styles in the workbook. |
| ITable | Represents a table of the worksheet. |
| ITableColumn | Represents a column in a table. |
| ITableColumns | Represents a collection of all the ITableColumn objects in the specified ITable object. |
| ITableRow | Represents a row in a table. |
| ITableRows | Represents a collection of all the table rows in the specified table. |
| ITables | Represents an ITables object which manages all ITable tables in the specified IWorksheet. |
| ITableStyle | Represents a single style that can be applied to a table. |
| ITableStyleElement | Represents a single table style element. |
| ITableStyleElements | Represents table style elements. |
| ITableStyles | Represents styles that can be applied to a table. |
| ITop10 | Represents 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. |
| IUniqueValues | The 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. |
| IValidation | Represents data validation for a worksheet range. |
| IWorkbook | Represents a workbook. |
| IWorkbooks | Represents a set of workbooks in a workbook set. |
| IWorkbookSet | Represents a set of workbooks which may refer to each other by external cell references or external defined name references. |
| IWorksheet | Represents a worksheet. |
| IWorksheets | Represents a set of worksheets in a workbook. |
| IWorksheetStyles | |
| IWorksheetView |
Structures
| Structure | Description | |
|---|---|---|
 | ActionResult<T> | Represents the executing result of an action. |
| Alignment | |
| AutoFilterColumn | The 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. |
| Border | |
| BorderLine | |
| Break | Represents a page break information. |
| CellProtection | |
| CellReference | Represents a reference to a range of cells. |
| CfExecutedResult | Represents the matched conditional formatting result. |
| CfIcon | Represents a single icon of an icon set. |
| CfValue | |
| Color | Struct ColorData |
| CustomFilterCriteria | A 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. |
| DataValidationExecutedResult | |
| DataValidationSuggestionItem | Represents a suggested data for the cell. |
| DateGroupItem | This collection is used to express a group of dates or times which are used in an AutoFilter criteria |
| Fill | Represent the fill formatting. |
| FilterData | Represents all filter data of a filter column. |
| FilterData.DateTimeItem | Represents a date time value and its corresponding IFormatter in the worksheet. |
| Font | Defines a particular format for text, including font face, size, and style attributes. |
| FormatResult | Represents the formatting value result. |
| GradientFillEffect | Represents the gradient fill effect. |
| GradientStop | Represents the gradient stop. |
| NumberFormat | Represents number format properties which indicate how to format and render the numeric value of a cell |
| Reference | Represents a reference to a range of cells. |
| TableStyleElement | Represents a single table style element. |
Enumerations
| Enumeration | Description | |
|---|---|---|
 | AboveBelow | Specifies if the values are above or below average. |
| AlignmentAttributes | |
| AutoFilterOperator | Specifies the operator to use to associate two criteria applied by a filter. |
| Behaviors | Represents the behaviors of operations. |
| BorderLineStyle | Enum the line style for border. |
| BordersIndex | Specifies the border to be retrieved. |
| BreakAttributes | |
| BuiltInSlicerStyles | |
| BuiltInStyle | Represents all built-in styles. |
| BuiltInTableStyles | Represents all built-in table styles. |
| CalcFeatures | |
| Calculation | Represents when calculation engine should calculate formulas in the spreadsheet. |
| CalendarType | |
| CellDataType | Represents the data type of a cell in the ExpressionView. |
| CfValueType | Specifies the types of condition values that can be used. |
| CharacterSet | Defines the possible sets of character glyphs that are defined in fonts for graphics output. |
| ClassicCfRuleType | |
| ColorType | Specifies the color format type. |
| Compatibility | Represents compatibility options for spreadsheet. |
| ContainsOperator | Specifies the text operator used in a function. |
| CustomFilterOperator | |
| DatabarAxisPosition | Represents the axis position for the data bar. |
| DatabarBorderType | Specifies the border of a data bar. |
| DatabarDirection | Specifies a value indicating whether the axis appears from right to left. |
| DatabarFillType | Specifies how a data bar is filled with color. |
| DatabarNegativeColorType | Specifies whether to use the same border and fill color as postive data bars. |
| DataRestrictions | Specifies the reason for an unaccepted expression or value. |
| DataValidationErrorStyle | The style of data validation error alert. |
| DataValidationOperator | The relational operator used in data validation. |
| DataValidationType | Specifies the type of data validation used to validate user input. |
| DateTimeGrouping | Specifies the part of the date time value used in a comparision. |
| Direction | Specifies the direction in which to move. |
| DisplayValueStyle | Represents the display style of a value. |
| DupeUnique | Specifies whether duplicate or unique values shoud be displayed. |
| DynamicFilterType | |
| FilterDataType | Represents the filter mode which UI should be displayed. |
| FilterOptions | Represents the filtering options for querying defined names. |
| FilterScopes | Represents the filtering scopes for querying defined names. |
| FontAttributes | Represents all attributes of a font. |
| FontFamily | The 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. |
| FontStyle | Represents the style of the typeface of a font. |
| FormatColorEnum | Represents all formatted color values. |
| FormatConditionOperator | Specifies the operator to use to compare a formula against the value in a cell or, for Between and NotBetween , to compare two formulas. |
| FormatConditionType | Specifies whether the conditional format is based on a cell value or an expression. |
| FormatOptions | Represents advanced options for formatting value to text. |
| GradientType | Type of gradient fill being used, either linear or path. |
| HorizontalAlignment | Enum the horizontal alignment of a cell or object. |
| IconSetType | |
| ImeMode | Specifies a value that determines the Input Method Editor (IME) status. |
| ManipulationOptions | Indicates which data type will be performed. |
| Operator | Represents the comparison operator. |
| PageBreak | Specifies page break location in the worksheet. |
| PatternType | Represent tie Fill pattern type. |
| ProtectionMode | Represents the protection type of the workbook or worksheet. |
| ReferenceStyle | Specifies the reference style in formulas and custom names in the sheet. |
| SheetViewType | Represents the view type of a GrapeCity.Spreadsheet.ISheetView. |
| SheetVisibility | Specifies whether the worksheet is visible. |
| SortDataOption | Specifies how to sort text. |
| SortMethod | Specifies the sort method for Chinese languages. |
| SortOn | Represents which data will be sorted. |
| SortOrder | Represents whether to sort in ascending order or descending order. |
| SummaryColumn | Specifies the location of the summary columns in the outline. |
| SummaryRow | Specifies the location of the summary rows in the outline. |
| TableStyleElementType | Represents the table style element's type. |
| TableStyleSettings | |
| TableType | |
| TextReadingOrder | |
| ThemeFont | Represents 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. |
| TimePeriods | Represents a time period which is used in date conditions. |
| TopBottom | Specifies the top 10 values from the top or bottom of a series of values. |
| TotalsCalculation | An enumeration that specifies what function is used to aggregate the data in a column before it is displayed in the totals row. |
| UnderlineStyle | Specifies the underline style of text. |
| UpdateLinks | Specifies a workbook's setting for updating embedded links. |
| VerticalAlignment | Specifies the vertical alignment of text. |
| VerticalTextAlignment | |
| WorkbookLocks | Represent protected data of the workbook. |
| WorksheetLocks | Represents protected data of the worksheet. |
| WorksheetType | Specifies the worksheet type. |
| YesNoCancel | Represents the choice to perform an action. |
| YesNoGuess | Specifies whether or not the first row contains headers. |
See Also