Represents a list of authors.

Represents all built-in number formats.

Represents a class which store, evaluate or adjust expressions.

Represents an attributes that allow to specify the cell inline image data.

Represents a class which stores cell calculated information.

Represents the color stop point for a gradient fill in a range or selection.

Represents the display settings for an associated Range object.

Represents a cell in the GrapeCity.Spreadsheet.ExpressionView.

Represents a external variable.

Represents all customizable features of Spread.

Represents the rich text.

Represents the data source of a sparkline.

Represents all options of the IWorksheet object.

Represents the executing result of an action.

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.

Represents the border of an object.

Represent the line settings of border.

Represents a page break information.

Represents a reference to a position of cell.

Represents the matched conditional formatting result.

Represents a single icon of an icon set.

Struct ColorData

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.

Represents a suggested data for the cell.

This collection is used to express a group of dates or times which are used in an AutoFilter criteria

Represent the fill formatting.

Represents the formatting value result.

Represents the gradient fill effect.

Represents the gradient stop.

Represents number format properties which indicate how to format and render the numeric value of a cell

Represents a reference to a range of cells.

Represents all style settings of the cell.

Represents a single table style element.

Represents a reference to a range of cells in the specified worksheet.

Represents an above average visual of a conditional formatting rule.

Represents a collection of alternating styles.

Represents a collection of the areas, or contiguous blocks of cells, within a selection.

Represents an array of items which are declared as T type.

Represents the author of the ICommentThreaded object.

Represents the filter for the specified worksheet.

Represents an object which contains an AutoFilter.

Represents the border of an object.

A collection of Border objects that represent the four borders of a Range or Style object.

Represents the editor of a cell.

Represents the renderer of a cell

Represents the cell type of a cell.

Represents characters in an object that contains text.

Represents the color palette that contains indexed colors.

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.

Represents the criteria for the minimum, midpoint, or maximum thresholds for a color format conditional format.

A collection of all the ColorStop objects for the specified series.

Represents the column footer of a worksheet.

Represents the column header of a worksheet.

Represents a cell comment.

Represents a cell's threaded comment. This object can represent both a top-level comment or its replies.

Represents a collection of cell comments.

Represents a collection of top-level ICommentThreaded objects in a worksheet, or a collection of replies in a single threaded comment.

Represents how the shortest bar or longest bar is evaluated for a data bar conditional formatting rule.

Represents the data manager of a worksheet.

Represents a data bar conditional formatting rule.

Represents the border of the data bars specified by a conditional formatting rule.

Represents a filter for a single column.

Represents a collection of IFilter objects that represents all the filters in an auto filtered range.

Contains the font attributes (font name, font size, color, and so on) for an object.

Represents a conditional format.

Represents the collection of conditional formats for a single range.

Represents the value formatter.

Contains the font attributes (font name, font size, color, and so on) for an object.

Contains properties that apply to header and footer picture objects.

Represents a hyperlink.

Represents the collection of hyperlinks for a worksheet or range.

Represents the collection of IconCriterion objects. Each IconCriterion represents the values and threshold type for each icon in an icon set conditional formatting rule.

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.

Represents an icon set conditional formatting rule.

Represents the interior of an object.

Represents an embedded resource.

Represents a defined name.

Represents a collection of all the IName objects in the workbook.

Represents the color settings of the data bars for negative values that are defined by a data bar conditional formatting rule.

Represents the cell type of a cell which supports NumberFormat.

Represents an outline on a worksheet.

Represents the various types of protection options available for a worksheet.

Interface that represent a range of a worksheet.

Represents a read-only array of items which are declared as T type.

Represents the row header of a worksheet.

Represents a sheet in the workbook.

Represents a sheet view.

Represents a collection of all the sheets in the specified or active workbook.

Represents a sort of a range of data.

Represents a custom sort comparer.

Represent an object contains all the sort information for the IWorksheet, ITable, and IAutoFilter objects.

Represents the collection of ISortField objects.

Represents the settings for the horizontal and vertical axes of a group of sparklines.

Represents the color of the horizontal axis and the markers for points in a sparkline.

Represents the settings for the horizontal axes of a group of sparklines.

Represents the settings of the markers for points of data on a sparkline.

Represents the settings for the vertical axes of a group of sparklines.

Represents a single sparkline.

Represents a group of sparklines.

Represents a collection of sparkline groups.

Represents the appearance of the cells in the worksheet.

Represents a collection of all styles in the workbook.

Represents a table of the worksheet.

Represents a column in a table.

Represents a collection of all the ITableColumn objects in the specified ITable object.

Represents a row in a table.

Represents a collection of all the table rows in the specified table.

Represents a single style that can be applied to a table.

Represents a single table style element.

Represents table style elements.

Represents styles that can be applied to a table.

Represents an ITables object which manages all ITable tables in the specified IWorksheet.

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.

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.

Represents data validation for a worksheet range.

Represents a workbook.

Represents a set of workbooks which may refer to each other by external cell references or external defined name references.

Represents a set of workbooks in a workbook set.

Represents a worksheet.

Represents a collection of all styles in the worksheet.

Represents a worksheet view.

Represents a set of worksheets in a workbook.

Specifies if the values are above or below average.

Specifies all attributes of the Alignment value.

Specifies how the target range is to be filled, based on the contents of the source range.

Specifies the operator to use to associate two criteria applied by a filter.

Represents the behaviors of operations.

Represents the line style of border.

Specifies the border to be retrieved.

Represents all built-in slicer styles.

Represents all built-in styles.

Represents all built-in table styles.

Represents all available features of the calculation engine.

Represents when calculation engine should calculate formulas in the spreadsheet.

Specifies whether invidiual cells are re-calculated.

Represents the data type of a cell in the GrapeCity.Spreadsheet.ExpressionView.

Specifies the types of condition values that can be used.

Defines the possible sets of character glyphs that are defined in fonts for graphics output.

Represents protection options of a chart sheet.

Specifies the color format type.

Specifies how a column is to be parsed.

Represents compatibility options for spreadsheet.

Specifies the text operator used in a function.

Specifies the comparison operation to be performed.

Specifies whether status is Copy mode or Cut mode.

Specifies the reason for an unaccepted expression or value.

The style of data validation error alert.

The relational operator used in data validation.

Specifies the type of data validation used to validate user input.

Represents the axis position for the data bar.

Specifies the border of a data bar.

Specifies a value indicating whether the axis appears from right to left.

Specifies how a data bar is filled with color.

Specifies whether to use the same border and fill color as postive data bars.

Specifies the part of the date time value used in a comparision.

Represents the choise to delete cells.

Specifies the direction in which to move.

Specifies how empty cells are plotted.

Represents the display style of a value.

Specifies whether duplicate or unique values shoud be displayed.

Specifies the type of dynamic filter to be applied.

Specifies what can be selected on the sheet.

Represents the filter mode which UI should be displayed.

Represents the filtering options for querying defined names.

Represents the filtering scopes for querying defined names.

Specifies the type of data to search.

Represents all attributes of a font.

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.

Represents the style of the typeface of a font.

Represents all formatted color values.

Specifies the operator to use to compare a formula against the value in a cell or, for Between and NotBetween , to compare two formulas.

Specifies whether the conditional format is based on a cell value or an expression.

Represents advanced options for formatting value to text.

Type of gradient fill being used, either linear or path.

Enum the horizontal alignment of a cell or object.

Specifies the type of hyperlink.

Specifies a value that determines the Input Method Editor (IME) status.

Specifies from where to copy the format for inserted cells.

Represents the choice to insert cells.

Specifies whether a match is made against the whole of the search text or any part of the search text.

Indicates which data type will be performed.

Specifies how the control handles automatic merging of cells based on the values in the cells.

Represents the position of the new row.

Represents how localized number format is parsed.

Represents the comparison operator.

Specifies page break location in the worksheet.

Specifies how numeric data will be calculated with the destinations cells on the worksheet.

Specifies the part of the range to be pasted.

Represents the Fill pattern type.

Represents predefined cell number formats.

Represents the protection type of the workbook or worksheet.

Specifies the reference style in formulas and custom names in the sheet.

Specifies the search direction when searching a range.

Specifies the order in which to search the range.

Represents the view type of a IWorksheetView.

Specifies whether the worksheet is visible.

Specifies how to sort text.

Specifies the sort method for Chinese languages.

Represents which data will be sorted.

Represents whether to sort in ascending order or descending order.

Represents the sort orientation.

Specifies how the minimum or maximum value of the vertical axis of the sparkline is scaled relative to other sparklines in the group.

Specifies the type of sparkline.

Specifies how to plot the sparkline when the data on which it is based is in a square-shaped range.

Specifies the type of cells.

Specifies cells with a particular type of value to include in the result.

Specifies the location of the summary columns in the outline.

Specifies the location of the summary rows in the outline.

Represents the table style element's type.

Specifies the type of a table.

Specifies the column format for the data in the text file that you are importing into a query table.

Specifies the delimiter to use to specify text.

Specifies the reading order.

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.

Represents a time period which is used in date conditions.

Specifies the top 10 values from the top or bottom of a series of values.

An enumeration that specifies what function is used to aggregate the data in a column before it is displayed in the totals row.

Specifies the underline style of text.

Specifies a workbook's setting for updating embedded links.

Specifies the vertical alignment of text.

Specifies the vertical alignment of text line.

Represent protected data of the workbook.

Represents protection options of a worksheet.

Specifies the type of worksheet headers and footers.

Specifies the worksheet type.

Represents the choice to perform an action.

Specifies whether or not the first row contains headers.