GcSpread.Sheets Namespace

Main namespace for SpreadJS.

Types

type	Description
AreaCondition	Represents an area condition using the expected source or formula.
AreaSparkline	Represents the class for the area sparkline.
AutoFormatter	Represents an automatic format.
AverageCondition	Represents a new average condition of the specified type for the specified cell ranges.
AverageRule	Represents an average conditional rule.
BaseCellType	Represents the base class for the other cell type classes.
BoxPlotSparkline	Represents the class for the box plot sparkline.
BulletSparkline	Represents the class for the bullet sparkline.
ButtonCellType	Represents a button cell.
Calc
CascadeSparkline	Represents the class for the cascade sparkline.
Cell	Represents a cell in a sheet.
CellBindingSource	Represents a source for cell binding.
CellPosition	Represents the position of a cell.
CellsEnumerator	Represents a cells enumerator for any area of the sheet.
CellValueCondition	Represents a cell value condition with a specified compare type, expected value, and formula.
CellValueRule	Represents a cell value conditional rule.
CheckBoxCellType	Represents a check box cell.
ColorCondition	Represents a style condition with the specified comparison type and expected color.
Column	Represents a column in a sheet.
ColumnHeaderCellType	Represents the painter of the column header cells.
ComboBoxCellType	Represents an editable combo box cell.
Comment	Represents a comment.
ConditionalFormats	Represents a format condition class.
ConditionRuleBase	Represents a formatting base rule class as the specified style.
CornerCellType	Represents the painter of the corner cell.
CultureInfo	Represents the custom culture class. The member variable can be overwritten.
CustomCellType	Represents the custom cell.
CustomFloatingObject	Represents a custom floating object.
CustomFormatterBase	Represents a custom formatter with the specified format string.
DataBarRule	Represents a data bar conditional rule with the specified parameters.
DateCondition	Represents a date condition with the specified comparison type, expected date condition, and formula.
DateExCondition	Represents a date condition with the specified comparison type, expected date condition, and formula.
DateOccurringRule	Represents a DateOccurringRule with the specified type and style.
DefaultDataValidator	Represents a data validator.
DuplicateRule	Represents a duplicate conditional rule.
Events	Defines the events supported in SpreadJS.
FloatingObject	Represents a floating object.
FontFactory	Represents the font factory.
FormatConverter	Represents the converting of a value to a specified data type.
FormulaCondition	Represents a custom condition with a specified formula or expression.
FormulaInformation	Represents the formula information for a cell.
FormulaRule	Represents a formula rule with the specified formula and style.
FormulaTextBox	Represents a formula text box.
GcSpreadSheetsOptions	GcSpread.Sheets options.
GeneralFormatter	Represents a formatter with the specified format mode and format string.
GroupedItemIndexEnumerator	Represents an enumerator for all group items from beginning to end.
HBarSparkline	Represents the class for the Hbar sparkline.
HideRowFilter	Represents a default row filter.
HyperLinkCellType	Represents the hyperlink cell.
IconCriterion	Represents an icon criteria with the specified parameters.
IconSetRule	Represents an icon set rule with the specified parameters.
ItemSlicer	Represents an item slicer.
KeyMap	Represents a key map, which maps a key event to a Spread action.
LineBorder	Represents the line style for a border side.
NameInfo	Represents a custom named expression that can be used by formulas.
NumberCondition	Represents a number condition of the specified type with the specified expected value.
Padding	Represents the padding information.
PaperSize	Specifies the paper size. The constructor has 3 modes. If there are 2 parameters, the parameters are width and height with a type of number; If there is 1 parameter, the parameter is kind which is a GcSpread.Sheets.PaperKind type; If there is no parameter, the result is the same as the second mode and the kind option is GcSpread.Sheets.PaperKind.Letter.
ParetoSparkline	Represents the class for the pareto sparkline.
Picture	Represents a picture.
PieSparkline	Represents the class for the pie sparkline.
Point	Represents an x- and y-coordinate pair in two-dimensional space.
PrintInfo	Represents the information to use when printing a Sheet.
Range	Represents a range, which is described by the row index, column index, row count, and column count.
RangeGroup	Represents a range group for the worksheet.
RangeGroupInfo	Represents the range grouping information.
Rect	Represents a rectangle with a special location, and its width and height in two-dimensional space.
RelationCondition	Represents a relation condition with a specified relation type.
Row	Represents a row in a sheet.
RowFilterBase	Represents a row filter base that supports row filters for filtering rows in a sheet.
RowHeaderCellType	Represents the painter of the row header cells.
ScaleRule	Represents a scale conditional rule.
ScaleValue	Represents a scale value with the specified type and value.
ScatterSparkline	Represents the class for the scatter sparkline.
SearchCondition	Defines the search condition.
SearchResult	Defines the search result.
Sheet	Represents a sheet.
SheetTable	Represents a table that can be added in a sheet.
Slicer	Represents a slicer.
SlicerBorder	Represents the slicer border.
SlicerStyle	Represents the slicer style settings.
SlicerStyleInfo	Represents slicer style information.
SlicerStyles	Represents a built-in slicer style collection.
Sparkline	Represents a Sparkline class.
SparklineEx	Represents the base class for the other SparklineEx classes.
SparklineGroup	Represents a sparkline group.
SparklineSetting	Creates the sparkline settings.
SpecificTextRule	Represents a specific text rule based on the specified cell.
Spread	Represents a spreadsheet with the specified hosted DOM element and options setting.
SpreadActions	Represents all the SpreadJS undo and redo actions.
SpreadSparkline	Represents the class for the Spread sparkline.
SpreadTheme	Represents an expression with a named variable as the expression.
SpreadThemes	Represents all built-in themes.
StackedSparkline	Represents the class for the stacked sparkline.
Style	Represents the style for a cell, row, and column.
TableColumnInfo	Represents the table column information.
TableSlicerData	Represents table slicer data.
TableStyle	Represents the table style settings.
TableStyleInfo	Represents table style information.
TableStyles	Represents a built-in table style collection.
TextCellType	Represents a text cell type.
TextCondition	Represents a text condition with the specified text comparison type based on the specified cell.
TextLengthCondition	Represents a text length condition with the specified comparison type, expected number, and formula.
ThemeColor	Creates a ThemeColor instance.
ThemeColors	Represents the theme color of built-in themes.
ThreeScaleRule	Represents a three-color scale conditional rule with the specified parameters.
Top10Condition	Represents a top 10 condition with the specified type and rank, for the specified cell ranges.
Top10Rule	Represents a top 10 condition rule.
TouchToolStrip	Represents a toolbar.
TouchToolStripItem	Represents an item in the toolbar.
TouchToolStripSeparator	Represents a separator in the toolbar.
TwoScaleRule	Represents a two-color conditional scale rule with the specified parameters.
UniqueCondition	Represents a unique condition and sets whether to check for duplicate data.
UniqueRule	Represents a unique condition rule.
VariSparkline	Represents the class for the variance sparkline.
VBarSparkline	Represents the class for the Vbar sparkline.

Enumerations

Enumeration	Description
AutoFillType	Represents the type of drag fill.
AutoFitType	Represents whether the component automatically resizes cells or headers.
AverageConditionType	Specifies the average condition type.
BarDirection	Specifies the data bar direction.
CheckBoxTextAlign	Specifies the text alignment for check box cells.
ClipboardPasteOptions	Specifies what data is pasted from the Clipboard.
ColorCompareType	Specifies the color compare type.
CommentState	Defines the comment state.
ComparisonOperator	Specifies the comparison operator.
CopyToOption	Specifies the copy to option.
CriteriaType	Indicates the data validator criteria type.
CustomValueType	Specifies the custom value type.
DataBarAxisPosition	Specifies the position of the data bar's axis.
DataOrientation	Represents the orientation of the range.
DataValidationResult	Indicates the data validation result.
DateCompareType	Specifies the date compare type.
DateOccurringType	Specifies the date occurring type.
DisplayMode	Defines when the comment is displayed.
EditorStatus	Specifies the editor status.
EditorValueType	Specifies what is written out to the data model for a selected item from certain cell types that offer a selection of multiple values.
EmptyValueStyle	Specifies how to show an empty value from a data series in the chart.
ErrorStyle	Indicates the data validation error style.
FillDateUnit	Represents the date fill unit.
FillDirection	Represents the type of drag fill direction.
FillSeries	Represents the fill series for drag fill.
FillType	Represents the type of fill data.
FilterActionType	Defines the type of filter action.
FormatMode	Represents the format mode.
GeneralCompareType	Specifies the general operator.
GroupState	Specifies the status of an outline (range group).
HeaderAutoText	Specifies which default labels are displayed in headers.
HorizontalAlign	Indicates the horizontal alignment.
HorizontalPosition	Specifies the horizontal position of the cell or column in the component.
HyperLinkTargetType	Specifies the hyperlink's target type.
IconSetType	Specifies the icon set.
IconValueType	Specifies the icon value type.
ImageLayout	Defines the background image layout.
ImeMode	Defines the IME mode to control the state of the Input Method Editor (IME).
InvalidOperationType	Identifies which operation was invalid.
Key	Represents the key code.
LineStyle	Specifies the line drawing style for the border.
NumberFormatType	Represents the number format type.
PaperKind	Specifies the paper kind for the printed page.
PrintCentering	Specifics the type of centering for the printed page.
PrintPageOrder	Specifies the order in which pages are printed.
PrintPageOrientation	Specifies the page orientation used for printing.
PrintVisibilityType	Specifies whether the area is visible.
QuarterType	Specifies the quarter type.
RangeChangedAction	Defines the type of action that raised the RangeChanged event.
RangeGroupDirection	Specifies the status of a range group summary row or column position.
ReferenceStyle	Specifies the formula reference style.
RelationCompareType	Specifies the relation operator.
ResizeZeroIndicator	Specifies the drawing policy of the row or column when it is resized to zero.
RuleType	Specifies the rule type.
ScaleValueType	Specifies the scale value type.
SearchFlags	Specifies the type of search flags.
SearchFoundFlags	Specifies where the search string is found.
SearchOrder	Specifies the type of search direction.
SelectionPolicy	Specifies how users can select items in the control.
SelectionUnit	Specifies the smallest unit users or the application can select.
SheetArea	Specifies the sheet area.
ShowResizeTip	Defines how the resize tip is displayed.
ShowScrollTip	Specifies how the scroll tip is displayed.
SlicerDataChangeReason	Defines the reason the slicer data changed.
SortState	Specifies the type of sorting to perform.
SparklineAxisMinMax	An enumeration that specifies information about how the vertical axis minimum or maximum is computed for this sparkline group.
SparklineType	Represents the sparkline type.
StorageType	Represents the storage data type.
TextCompareType	Specifies the text compare type.
TextComparisonOperator	Specifies the text comparison operator.
TextDecorationType	Defines the type of the text decoration.
TextFileOpenFlags	Specifies the import flags.
Top10ConditionType	Specifies the top 10 condition type.
VerticalAlign	Indicates the vertical alignment.
VerticalPosition	Specifies the vertical position of the cell or row in the component.
VisualState	Specifies the visual state.

Reference

Spread