GrapeCity.Documents.Spread Namespace

Classes

	Class	Description
	CellColorSortField	Specifies the interior sort.
	FontColorSortField	Represents the color sort.
	IconSortField	Represents sorting by icon.
	InvalidFormulaException	Specifies the invalid formula exception.
	LicenseManager	A static class used to set license
	OpenOptions	Option class for opening
	RangeEventArgs	Specifies EventArgs that contain a IRange object.
	SaveOptions	Option class for saving
	SheetEventArgs	Represents EventArgs which contain a Worksheet object;
	SortFieldBase	Represents the sort base class.
	Themes	Represents the theme manager.
	ValueSortField	Represents the sort by value field.
	Workbook	Represents the workbook class. Represents a workbook.

Interfaces

	Interface	Description
	IAboveAverage	Represents an above average visual of a conditional formatting rule. Applies a color or fill to a range or selection to help you see the value of a cell relative to other cells.
	IAreas	Represents a collection of ranges, each of which represent a single contiguous range of one or more cells.
	IAutoFilter	Represents autofiltering for the specified worksheet.
	IBorder	Represents the border of an object.
	IBorders	Represents a collection of four IBorder objects that represent the four borders of an IRange or IStyle object.
	ICellCollection	Gets an individual cell by its reference string.
	ICellColorSortField	Represents the sort field by cell color.
	IColorFormatter	Defines the methods and properties required by objects used to format foreground values.
	IColorScale	Represents a color scale conditional formatting rule.
	IColorScaleCriteria	Represents a collection of ColorScaleCriterion objects that represent 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.
	IColorStop	Represents the color stop point for a gradient fill in a range or selection.
	IColorStops	Represents a collection of all the IColorStop objects for the specified series.
	IComment	Represents a cell comment.
	IComments	Represents a collection of cell comments. Each comment is represented by an IComment object.
	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. Applying a data bar to a range helps you see the value of a cell relative to other cells.
	IDataBarBorder	Represents the border of the data bars specified by a conditional formatting rule.
	IDisplayFormat	Represents the display settings for an associated Range object. Remark: Actions such as changing the conditional formatting or table style of a range can cause what is displayed in the current user interface to be inconsistent with the values in the corresponding properties of the Range object. Use the properties of the DisplayFormat object to return the values as they are displayed in the current user interface.
	IFilter	Represents a filter for a single column. The Filter object is a member of the Filters collection. The Filters collection contains all the filters in an autofiltered range.
	IFilters	Represents a collection of Filter objects that represents all the filters in an autofiltered range.
	IFont	Contains the font attributes (font name, font size, color, and so on) for an object.
	IFontColorSortField	Represents the sort field by font color.
	IFormatColor	Represents the fill color specified for a threshold of a color scale conditional format or the color of the bar in a data bar conditional format.
	IFormatCondition	Represents a conditional format.
	IFormatConditions	Represents the conditional formats associated with a range.
	IFormatter	Defines the methods and properties required by objects used as formatters.
	IGraphic	Represents the picture field included in the specified header or footer.
	IHeaderFooter	Represents a picture or text how to be aligned in the page header and footer.
	IHyperlink	Represents a hyperlink.
	IHyperlinks	Represents the collection of hyperlinks for a worksheet or range. Each hyperlink is represented by the IHyperlink object.
	IIcon	Represents a single icon in an icon set used in a conditional formatting rule.
	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.
	IIconSet	Represents a single set of icons that are used in an icon set conditional formatting rule.
	IIconSetCondition	Represents an icon set conditional formatting rule.
	IIconSets	Represents a collection of icon sets used in an icon set conditional formatting rule.
	IIconSortField	Represents the sort field by icon.
	IInterior	Represents the interior of an object.
	ILinearGradient	Represents the ILinearGradient object that transitions through a series of colors in a linear manner along a specific angle.
	IName	Represents a defined name for a range of cells.
	INames	Represents a collection of all the IName objects in the workbook. Each Name object represents a defined name for a range of cells. Names can be either built-in names — such as Database, Print_Area, and Auto_Open — or custom names.
	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.
	IPage	Represents the alignment of text on the page of a workbook or section.
	IPageSetup	Represents the page setup description.
	IPivotCache	Represents the memory cache for a PivotTable report.
	IPivotCaches	Represents the collection of memory caches from the PivotTable reports in a workbook.
	IPivotField	Represents a field in a PivotTable report. The PivotField object is a member of the PivotFields collection. The PivotFields collection contains all the fields in a PivotTable report, including hidden fields.
	IPivotFields	Represents a collection of all the PivotField objects in a PivotTable report.
	IPivotItem	Represents an item in a PivotTable field. The items are the individual data entries in a field category. The PivotItem object is a member of the PivotItems collection. The PivotItems collection contains all the items in a PivotField.
	IPivotItems	Represents a collection of all the PivotItem objects in a PivotTable field. The items are the individual data entries in a field category.
	IPivotTable	Represents a PivotTable report on a worksheet. The PivotTable object is a member of the PivotTables collection. The PivotTables collection contains all the PivotTable objects on a single worksheet.
	IPivotTables	Represents a collection of all the PivotTable objects on the specified worksheet.
	IProtectionSettings	Represents the various types of protection options available for a worksheet. The setting action will take effect only if the worksheet is under protection.
	IRange	Represents the IRange object.
	IRangeProvider	Provides access to the IRange object of cells in the worksheet.
	IRectangularGradient	The IRectangularGradient object transitions through a series of colors in a linear manner along a specific angle
	ISlicer	Represents a slicer in a IWorkbook.
	ISlicerCache	Represents the current filter state for a slicer and information about which IPivotCache.
	ISlicerCaches	Represents the collection of slicer caches associated with the specified workbook.
	ISlicerItem	Represents an item in a slicer.
	ISlicerItems	Represents the collection of ISlicerItem objects contained in a ISlicerCache object.
	ISlicerPivotTables	Represents information about the collection of IPivotTables associated with the specified ISlicerCache object.
	ISlicers	A collection of ISlicer objects.
	ISort	Represents the sort interface.
	ISortField	Represents the sort field.
	ISortFields	Represents the sort condition list.
	ISparkAxes	Represents the settings for the horizontal and vertical axes of a group of sparklines.
	ISparkColor	Represents the color of the markers for points in a sparkline.
	ISparkHorizontalAxis	Represents the settings for the horizontal axes of a group of sparklines.
	ISparkline	Represents a single sparkline.
	ISparklineGroup	Represents a group of sparklines.
	ISparklineGroups	Represents a collection of sparkline groups.
	ISparkPoints	Represents the settings of the markers for points of data on a sparkline.
	ISparkVerticalAxis	Represents the settings for the vertical axes of a group of sparklines.
	IStyle	Represents a style description for a range.
	IStyleCollection	Represents a collection of all the IStyle objects in the specified or active workbook.
	ITable	Represents a table object on a worksheet.
	ITableColumn	Represents a column in a table. The ITableColumn object is a member of the ITableColumns collection. The ITableColumns collection contains all the columns in a table (ITable object).
	ITableColumns	Represents a collection of all the ITableColumn objects in the specified ITable object. Each ITableColumn object represents a column in the table.
	ITableRow	Represents a row in the ITable object. The ITableRow object is a member of the ITableRows collection. The ITableRows collection contains all the rows in a list object.
	ITableRows	Represents a collection of all the ITableRow objects in the specified ITable object. Each ITableRow object represents a row in the table.
	ITables	Represents a collection of all the ITable objects on a worksheet. Each ITable object represents a list in the worksheet.
	ITableStyle	Represents a single style that can be applied to a table.
	ITableStyleCollection	Represents a collection of table styles contained in the workbook.
	ITableStyleElement	Represents a single table style element.
	ITableStyleElements	Represents table style elements.
	ITheme	Contains the theme information.
	IThemeColor	Represents the theme color information.
	IThemeColorScheme	Represents the theme color.
	IThemeFont	Represents the theme font.
	IThemeFonts	Contains the theme fonts in different language.
	IThemeFontScheme	Specifies the font theme to use.
	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 UniqueValues.DupeUnique property to return or set an enumeration that determines whether the rule should look for duplicate or unique values in the range.
	IValidation	Represents data validation for a worksheet range.
	IValueSortField	Represents the sort field by cell value (ascending or descending or custom value list).
	IWorkbook	Represents an IWorkbook object.
	IWorksheet	Represents a worksheet.
	IWorksheets	Represents a collection of all the sheets in the workbook.
	IWorksheetView	Represents worksheet view options.

Structures

	Structure	Description
	Color	Creates the color structure.

Enumerations

	Enumeration	Description
	AboveBelow	Specifies if the values are above or below average.
	AutoFilterOperator	Specifies the operator to use to associate two criteria applied by a filter.
	BorderLineStyle	Specifies the line style for the border.
	BordersIndex	Specifies the border to be retrieved.
	CalcError	Specifies the calculation error.
	ColorDataIndex	Specifies the color of a selected feature such as border, font, or fill.
	ColorScaleType	Specifies the type of color scale rule.
	ConditionValueTypes	Specifies the types of condition values that can be used.
	ConsolidationFunction	Specifies the subtotal function.
	ContainsOperator	Specifies the operator used in a function.
	DataBarAxisPosition	Specifies the axis position for a range of cells with conditional formatting as data bars.
	DataBarBorderType	Specifies the border of a data bar.
	DataBarDirection	Specifies the direction of a data bar.
	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.
	DeleteShiftDirection	Specifies how to shift cells to replace deleted cells.
	DisplayBlanksAs	Specifies how blank cells are plotted on a chart.
	DupeUnique	Specifies whether duplicate or unique values should be displayed.
	DynamicFilterType	Specifies the filter type.
	FontLanguageIndex	Specifies the font language type.
	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.
	FormatMode	Specifies the format string mode for a formatter.
	GradientFillType	Specifies the type of gradient fill being used, either linear or path.
	GraphicColorType	Represents type of color transformation applied to the specified picture or OLE object.
	HorizontalAlignment	Specifies the horizontal alignment of a cell or object.
	IconSetType	Specifies the type of icon set.
	IconType	Specifies the icon for a criterion in an icon set conditional formatting rule.
	IMEModeType	Specifies the description of the Japanese input rules.
	ImportFlags	Options for reading data
	InsertShiftDirection	Specifies the direction in which to shift cells during an insertion.
	NumberFormatType	Specifies the type of format for the data.
	Order	Represents the order that Spread.Services uses to number pages when printing a large worksheet.
	PaperSize	Represents the size of the paper.
	PasteType	Specifies the type of paste.
	Pattern	Specifies the interior pattern of a chart or interior object.
	PivotFieldOrientation	Specifies the location of the field in a PivotTable report.
	PrintErrors	Represents an PrintErrors contstant specifying the type of print error displayed.
	PrintLocation	Represents the way comments are printed with the sheet.
	PrintQuality	Represents print quality of this page. Default is 600 dpi.
	ReadingOrder	Specified the text reading order.
	ReferenceStyle	Specifies whether to use A1 style or R1C1 style for cell references.
	SlicerSortOrder	Specifies the slicer sort order.
	SortDataOption	Specifies how to sort text.
	SortOnType	Specifies the parameter on which the data should be sorted.
	SortOrder	Specifies the sort order.
	SortOrientation	Specifies the sort orientation.
	SparklineRowCol	Specifies how to plot the sparkline when the data on which it is based is in a square-shaped range.
	SparkScale	Specifies how the minimum or maximum value of the vertical axis of the sparkline is scaled relative to other sparklines in the group.
	SparkType	Specifies the type of sparkline.
	SubtotalLocationType	Specifies where the subtotal will be displayed on the worksheet.
	SubtotalType	Specifies the type of subtotal for the specified pivot field.
	SummaryColumn	Specifies the location of the summary columns in the outline.
	SummaryRow	Specifies the location of the summary rows in the outline.
	TableStyleElementType	Specifies the table style element used.
	ThemeColor	Specifies the theme color. This is the displayed order.
	ThemeFont	Specifies the theme font to use.
	TimePeriods	Specifies the time period.
	TopBottom	Specifies the top 10 values from the top or bottom of a series of values.
	TotalsCalculation	Specifies the type of calculation in the totals row of a table column.
	UnderlineType	Specifies the underline style of text.
	UsedRangeType	Specifies the type of all supported features.
	ValidationAlertStyle	Specifies the icon used in message boxes displayed during validation.
	ValidationOperator	Specifies the operator to use to compare a formula against the value in a cell or, for Between and NotBetween, to compare two formulas.
	ValidationType	Specifies the type of validation test to be performed in conjunction with values.
	VerticalAlignment	Specifies the vertical alignment of text.
	Visibility	Specifies whether the object is visible.

Reference

GrapeCity.Documents.Spread Assembly