# GC.Spread.Sheets

## Content

# Namespace: Sheets

[GC](GC).[Spread](GC.Spread).Sheets

## Table of contents

### Namespaces

- [AutoMerge](GC.Spread.Sheets.AutoMerge)
- [Barcode](GC.Spread.Sheets.Barcode)
- [Bindings](GC.Spread.Sheets.Bindings)
- [CalcEngine](GC.Spread.Sheets.CalcEngine)
- [CellState](GC.Spread.Sheets.CellState)
- [CellTypes](GC.Spread.Sheets.CellTypes)
- [Charts](GC.Spread.Sheets.Charts)
- [Commands](GC.Spread.Sheets.Commands)
- [Comments](GC.Spread.Sheets.Comments)
- [ConditionalFormatting](GC.Spread.Sheets.ConditionalFormatting)
- [ContextMenu](GC.Spread.Sheets.ContextMenu)
- [DataValidation](GC.Spread.Sheets.DataValidation)
- [Fill](GC.Spread.Sheets.Fill)
- [Filter](GC.Spread.Sheets.Filter)
- [FloatingObjects](GC.Spread.Sheets.FloatingObjects)
- [FormulaTextBox](GC.Spread.Sheets.FormulaTextBox)
- [Hyperlink](GC.Spread.Sheets.Hyperlink)
- [NameBox](GC.Spread.Sheets.NameBox)
- [OutlineColumn](GC.Spread.Sheets.OutlineColumn)
- [Outlines](GC.Spread.Sheets.Outlines)
- [PDF](GC.Spread.Sheets.PDF)
- [Print](GC.Spread.Sheets.Print)
- [Search](GC.Spread.Sheets.Search)
- [Shapes](GC.Spread.Sheets.Shapes)
- [Slicers](GC.Spread.Sheets.Slicers)
- [Sparklines](GC.Spread.Sheets.Sparklines)
- [StatusBar](GC.Spread.Sheets.StatusBar)
- [TableSheet](GC.Spread.Sheets.TableSheet)
- [Tables](GC.Spread.Sheets.Tables)
- [Touch](GC.Spread.Sheets.Touch)

### Enumerations

- [AllSheetsListVisibility](../enums/GC.Spread.Sheets.AllSheetsListVisibility)
- [AutoFitType](../enums/GC.Spread.Sheets.AutoFitType)
- [ButtonImageType](../enums/GC.Spread.Sheets.ButtonImageType)
- [ButtonPosition](../enums/GC.Spread.Sheets.ButtonPosition)
- [ButtonVisibility](../enums/GC.Spread.Sheets.ButtonVisibility)
- [CalendarPage](../enums/GC.Spread.Sheets.CalendarPage)
- [CalendarStartDay](../enums/GC.Spread.Sheets.CalendarStartDay)
- [CaptionAlignment](../enums/GC.Spread.Sheets.CaptionAlignment)
- [CellStatesType](../enums/GC.Spread.Sheets.CellStatesType)
- [ClearPendingChangeType](../enums/GC.Spread.Sheets.ClearPendingChangeType)
- [ClipboardPasteOptions](../enums/GC.Spread.Sheets.ClipboardPasteOptions)
- [CopyPasteHeaderOptions](../enums/GC.Spread.Sheets.CopyPasteHeaderOptions)
- [CopyToOptions](../enums/GC.Spread.Sheets.CopyToOptions)
- [DropDownType](../enums/GC.Spread.Sheets.DropDownType)
- [DropdownListValue](../enums/GC.Spread.Sheets.DropdownListValue)
- [EditorStatus](../enums/GC.Spread.Sheets.EditorStatus)
- [GroupSort](../enums/GC.Spread.Sheets.GroupSort)
- [HeaderAutoText](../enums/GC.Spread.Sheets.HeaderAutoText)
- [HeaderOptions](../enums/GC.Spread.Sheets.HeaderOptions)
- [HorizontalAlign](../enums/GC.Spread.Sheets.HorizontalAlign)
- [HorizontalPosition](../enums/GC.Spread.Sheets.HorizontalPosition)
- [HyperlinkTargetType](../enums/GC.Spread.Sheets.HyperlinkTargetType)
- [ImageLayout](../enums/GC.Spread.Sheets.ImageLayout)
- [ImeMode](../enums/GC.Spread.Sheets.ImeMode)
- [InsertShiftCell](../enums/GC.Spread.Sheets.InsertShiftCell)
- [InvalidOperationType](../enums/GC.Spread.Sheets.InvalidOperationType)
- [LabelAlignment](../enums/GC.Spread.Sheets.LabelAlignment)
- [LabelVisibility](../enums/GC.Spread.Sheets.LabelVisibility)
- [LayoutDirection](../enums/GC.Spread.Sheets.LayoutDirection)
- [LayoutDisplayAs](../enums/GC.Spread.Sheets.LayoutDisplayAs)
- [LineStyle](../enums/GC.Spread.Sheets.LineStyle)
- [NumbersFitMode](../enums/GC.Spread.Sheets.NumbersFitMode)
- [PatternType](../enums/GC.Spread.Sheets.PatternType)
- [RangeChangedAction](../enums/GC.Spread.Sheets.RangeChangedAction)
- [ReferenceStyle](../enums/GC.Spread.Sheets.ReferenceStyle)
- [ResizeMode](../enums/GC.Spread.Sheets.ResizeMode)
- [ResizeZeroIndicator](../enums/GC.Spread.Sheets.ResizeZeroIndicator)
- [RowColumnStates](../enums/GC.Spread.Sheets.RowColumnStates)
- [ScrollbarAppearance](../enums/GC.Spread.Sheets.ScrollbarAppearance)
- [SelectionPolicy](../enums/GC.Spread.Sheets.SelectionPolicy)
- [SelectionUnit](../enums/GC.Spread.Sheets.SelectionUnit)
- [SheetArea](../enums/GC.Spread.Sheets.SheetArea)
- [SheetTabVisible](../enums/GC.Spread.Sheets.SheetTabVisible)
- [SheetType](../enums/GC.Spread.Sheets.SheetType)
- [ShowResizeTip](../enums/GC.Spread.Sheets.ShowResizeTip)
- [ShowScrollTip](../enums/GC.Spread.Sheets.ShowScrollTip)
- [SortState](../enums/GC.Spread.Sheets.SortState)
- [StorageType](../enums/GC.Spread.Sheets.StorageType)
- [TabStripPosition](../enums/GC.Spread.Sheets.TabStripPosition)
- [TextDecorationType](../enums/GC.Spread.Sheets.TextDecorationType)
- [UsedRangeType](../enums/GC.Spread.Sheets.UsedRangeType)
- [ValueType](../enums/GC.Spread.Sheets.ValueType)
- [VertAlign](../enums/GC.Spread.Sheets.VertAlign)
- [VerticalAlign](../enums/GC.Spread.Sheets.VerticalAlign)
- [VerticalPosition](../enums/GC.Spread.Sheets.VerticalPosition)
- [VisualState](../enums/GC.Spread.Sheets.VisualState)

### Classes

- [CellRange](../classes/GC.Spread.Sheets.CellRange)
- [ColorScheme](../classes/GC.Spread.Sheets.ColorScheme)
- [Events](../classes/GC.Spread.Sheets.Events)
- [LineBorder](../classes/GC.Spread.Sheets.LineBorder)
- [NameInfo](../classes/GC.Spread.Sheets.NameInfo)
- [PivotTableManager](../classes/GC.Spread.Sheets.PivotTableManager)
- [Point](../classes/GC.Spread.Sheets.Point)
- [Range](../classes/GC.Spread.Sheets.Range)
- [Rect](../classes/GC.Spread.Sheets.Rect)
- [Style](../classes/GC.Spread.Sheets.Style)
- [Theme](../classes/GC.Spread.Sheets.Theme)
- [ThemeColors](../classes/GC.Spread.Sheets.ThemeColors)
- [Themes](../classes/GC.Spread.Sheets.Themes)
- [Workbook](../classes/GC.Spread.Sheets.Workbook)
- [Worksheet](../classes/GC.Spread.Sheets.Worksheet)

### Interfaces

- [FloatingObjectLoadedEventArgs](../interfaces/GC.Spread.Sheets.FloatingObjectLoadedEventArgs)
- [FormattedData](../interfaces/GC.Spread.Sheets.FormattedData)
- [IActiveSheetChangedEventArgs](../interfaces/GC.Spread.Sheets.IActiveSheetChangedEventArgs)
- [IActiveSheetChangingEventArgs](../interfaces/GC.Spread.Sheets.IActiveSheetChangingEventArgs)
- [IBaseSpreadOption](../interfaces/GC.Spread.Sheets.IBaseSpreadOption)
- [IBounds](../interfaces/GC.Spread.Sheets.IBounds)
- [IButtonClickedEventArgs](../interfaces/GC.Spread.Sheets.IButtonClickedEventArgs)
- [ICalendarOption](../interfaces/GC.Spread.Sheets.ICalendarOption)
- [ICellButton](../interfaces/GC.Spread.Sheets.ICellButton)
- [ICellChangedEventArgs](../interfaces/GC.Spread.Sheets.ICellChangedEventArgs)
- [ICellClickEventArgs](../interfaces/GC.Spread.Sheets.ICellClickEventArgs)
- [ICellColorSortInfo](../interfaces/GC.Spread.Sheets.ICellColorSortInfo)
- [ICellDoubleClickEventArgs](../interfaces/GC.Spread.Sheets.ICellDoubleClickEventArgs)
- [ICellPosition](../interfaces/GC.Spread.Sheets.ICellPosition)
- [ICellsInfo](../interfaces/GC.Spread.Sheets.ICellsInfo)
- [IClearChangeInfo](../interfaces/GC.Spread.Sheets.IClearChangeInfo)
- [IClipboardChangedEventArgs](../interfaces/GC.Spread.Sheets.IClipboardChangedEventArgs)
- [IClipboardChangingEventArgs](../interfaces/GC.Spread.Sheets.IClipboardChangingEventArgs)
- [IClipboardPastedEventArgs](../interfaces/GC.Spread.Sheets.IClipboardPastedEventArgs)
- [IClipboardPastingEventArgs](../interfaces/GC.Spread.Sheets.IClipboardPastingEventArgs)
- [IColorPickerGroup](../interfaces/GC.Spread.Sheets.IColorPickerGroup)
- [IColorPickerOption](../interfaces/GC.Spread.Sheets.IColorPickerOption)
- [IColumn](../interfaces/GC.Spread.Sheets.IColumn)
- [IColumnBindingInfo](../interfaces/GC.Spread.Sheets.IColumnBindingInfo)
- [IColumnChangedEventArgs](../interfaces/GC.Spread.Sheets.IColumnChangedEventArgs)
- [IColumnWidthChangedEventArgs](../interfaces/GC.Spread.Sheets.IColumnWidthChangedEventArgs)
- [IColumnWidthChangingEventArgs](../interfaces/GC.Spread.Sheets.IColumnWidthChangingEventArgs)
- [ICommentChangedEventArgs](../interfaces/GC.Spread.Sheets.ICommentChangedEventArgs)
- [ICommentRemovedEventArgs](../interfaces/GC.Spread.Sheets.ICommentRemovedEventArgs)
- [ICommentRemovingEventArgs](../interfaces/GC.Spread.Sheets.ICommentRemovingEventArgs)
- [ICopyData](../interfaces/GC.Spread.Sheets.ICopyData)
- [ICustomSortInfo](../interfaces/GC.Spread.Sheets.ICustomSortInfo)
- [IDirtyCellInfo](../interfaces/GC.Spread.Sheets.IDirtyCellInfo)
- [IDragDropBlockCompletedEventArgs](../interfaces/GC.Spread.Sheets.IDragDropBlockCompletedEventArgs)
- [IDragDropBlockEventArgs](../interfaces/GC.Spread.Sheets.IDragDropBlockEventArgs)
- [IDragFillBlockCompletedEventArgs](../interfaces/GC.Spread.Sheets.IDragFillBlockCompletedEventArgs)
- [IDragFillBlockEventArgs](../interfaces/GC.Spread.Sheets.IDragFillBlockEventArgs)
- [IDropdown](../interfaces/GC.Spread.Sheets.IDropdown)
- [IEditChangeEventArgs](../interfaces/GC.Spread.Sheets.IEditChangeEventArgs)
- [IEditEndedEventArgs](../interfaces/GC.Spread.Sheets.IEditEndedEventArgs)
- [IEditEndingEventArgs](../interfaces/GC.Spread.Sheets.IEditEndingEventArgs)
- [IEditStartingEventArgs](../interfaces/GC.Spread.Sheets.IEditStartingEventArgs)
- [IEditorStatusChangedEventArgs](../interfaces/GC.Spread.Sheets.IEditorStatusChangedEventArgs)
- [IEnterCellEventArgs](../interfaces/GC.Spread.Sheets.IEnterCellEventArgs)
- [IExternalReference](../interfaces/GC.Spread.Sheets.IExternalReference)
- [IExternalReferenceDetail](../interfaces/GC.Spread.Sheets.IExternalReferenceDetail)
- [IFilterButtonHitInfo](../interfaces/GC.Spread.Sheets.IFilterButtonHitInfo)
- [IFloatingObjectChangedEventArgs](../interfaces/GC.Spread.Sheets.IFloatingObjectChangedEventArgs)
- [IFloatingObjectRemovedEventArgs](../interfaces/GC.Spread.Sheets.IFloatingObjectRemovedEventArgs)
- [IFloatingObjectRemovingEventArgs](../interfaces/GC.Spread.Sheets.IFloatingObjectRemovingEventArgs)
- [IFloatingObjectSelectionChangedEventArgs](../interfaces/GC.Spread.Sheets.IFloatingObjectSelectionChangedEventArgs)
- [IFontColorSortInfo](../interfaces/GC.Spread.Sheets.IFontColorSortInfo)
- [IFormulaInfo](../interfaces/GC.Spread.Sheets.IFormulaInfo)
- [IFormulaRangeHitInfo](../interfaces/GC.Spread.Sheets.IFormulaRangeHitInfo)
- [IGradientFill](../interfaces/GC.Spread.Sheets.IGradientFill)
- [IGradientPathFill](../interfaces/GC.Spread.Sheets.IGradientPathFill)
- [IHitTestCellTypeHitInfo](../interfaces/GC.Spread.Sheets.IHitTestCellTypeHitInfo)
- [IHitTestCommentHitInfo](../interfaces/GC.Spread.Sheets.IHitTestCommentHitInfo)
- [IHitTestDragInfo](../interfaces/GC.Spread.Sheets.IHitTestDragInfo)
- [IHitTestFloatingObjectHitInfo](../interfaces/GC.Spread.Sheets.IHitTestFloatingObjectHitInfo)
- [IHitTestFooterCornerInfo](../interfaces/GC.Spread.Sheets.IHitTestFooterCornerInfo)
- [IHitTestInformation](../interfaces/GC.Spread.Sheets.IHitTestInformation)
- [IHitTestOutlineHitInfo](../interfaces/GC.Spread.Sheets.IHitTestOutlineHitInfo)
- [IHitTestResizeInfo](../interfaces/GC.Spread.Sheets.IHitTestResizeInfo)
- [IHitTestScrollBarInfo](../interfaces/GC.Spread.Sheets.IHitTestScrollBarInfo)
- [IHyperlink](../interfaces/GC.Spread.Sheets.IHyperlink)
- [IIHitTestTabStripInfo](../interfaces/GC.Spread.Sheets.IIHitTestTabStripInfo)
- [IInvalidOperationEventArgs](../interfaces/GC.Spread.Sheets.IInvalidOperationEventArgs)
- [ILabelOptions](../interfaces/GC.Spread.Sheets.ILabelOptions)
- [ILeaveCellEventArgs](../interfaces/GC.Spread.Sheets.ILeaveCellEventArgs)
- [ILeftColumnChangedEventArgs](../interfaces/GC.Spread.Sheets.ILeftColumnChangedEventArgs)
- [IListItem](../interfaces/GC.Spread.Sheets.IListItem)
- [IListLayout](../interfaces/GC.Spread.Sheets.IListLayout)
- [IListOption](../interfaces/GC.Spread.Sheets.IListOption)
- [IMonthPickerOption](../interfaces/GC.Spread.Sheets.IMonthPickerOption)
- [IMultiColumnOption](../interfaces/GC.Spread.Sheets.IMultiColumnOption)
- [IOutlineColumnCheckStatusChanged](../interfaces/GC.Spread.Sheets.IOutlineColumnCheckStatusChanged)
- [IOutlineHitInfo](../interfaces/GC.Spread.Sheets.IOutlineHitInfo)
- [IParamRange](../interfaces/GC.Spread.Sheets.IParamRange)
- [IPasteData](../interfaces/GC.Spread.Sheets.IPasteData)
- [IPatternFill](../interfaces/GC.Spread.Sheets.IPatternFill)
- [IPictureChangedEventArgs](../interfaces/GC.Spread.Sheets.IPictureChangedEventArgs)
- [IPictureSelectionChangedEventArgs](../interfaces/GC.Spread.Sheets.IPictureSelectionChangedEventArgs)
- [IPivotTableChangedEventArgs](../interfaces/GC.Spread.Sheets.IPivotTableChangedEventArgs)
- [IProtectionOptions](../interfaces/GC.Spread.Sheets.IProtectionOptions)
- [IRangeChangedEventArgs](../interfaces/GC.Spread.Sheets.IRangeChangedEventArgs)
- [IRangeFilterClearedEventArgs](../interfaces/GC.Spread.Sheets.IRangeFilterClearedEventArgs)
- [IRangeFilterClearingEventArgs](../interfaces/GC.Spread.Sheets.IRangeFilterClearingEventArgs)
- [IRangeFilteredEventArgs](../interfaces/GC.Spread.Sheets.IRangeFilteredEventArgs)
- [IRangeFilteringEventArgs](../interfaces/GC.Spread.Sheets.IRangeFilteringEventArgs)
- [IRangeGroupStateChangedEventArgs](../interfaces/GC.Spread.Sheets.IRangeGroupStateChangedEventArgs)
- [IRangeGroupStateChangingEventArgs](../interfaces/GC.Spread.Sheets.IRangeGroupStateChangingEventArgs)
- [IRangeSortedEventArgs](../interfaces/GC.Spread.Sheets.IRangeSortedEventArgs)
- [IRangeSortingEventArgs](../interfaces/GC.Spread.Sheets.IRangeSortingEventArgs)
- [IRowChangedEventArgs](../interfaces/GC.Spread.Sheets.IRowChangedEventArgs)
- [IRowHeightChangedEventArgs](../interfaces/GC.Spread.Sheets.IRowHeightChangedEventArgs)
- [IRowHeightChangingEventArgs](../interfaces/GC.Spread.Sheets.IRowHeightChangingEventArgs)
- [ISelectionChangedEventArgs](../interfaces/GC.Spread.Sheets.ISelectionChangedEventArgs)
- [ISelectionChangingEventArgs](../interfaces/GC.Spread.Sheets.ISelectionChangingEventArgs)
- [ISetBorderOptions](../interfaces/GC.Spread.Sheets.ISetBorderOptions)
- [IShapeChangedEventArgs](../interfaces/GC.Spread.Sheets.IShapeChangedEventArgs)
- [IShapeRemovedEventArgs](../interfaces/GC.Spread.Sheets.IShapeRemovedEventArgs)
- [IShapeRemovingEventArgs](../interfaces/GC.Spread.Sheets.IShapeRemovingEventArgs)
- [IShapeSelectionChangedEventArgs](../interfaces/GC.Spread.Sheets.IShapeSelectionChangedEventArgs)
- [ISheetChangedEventArgs](../interfaces/GC.Spread.Sheets.ISheetChangedEventArgs)
- [ISheetChangingEventArgs](../interfaces/GC.Spread.Sheets.ISheetChangingEventArgs)
- [ISheetDefaultOption](../interfaces/GC.Spread.Sheets.ISheetDefaultOption)
- [ISheetNameChangedEventArgs](../interfaces/GC.Spread.Sheets.ISheetNameChangedEventArgs)
- [ISheetNameChangingEventArgs](../interfaces/GC.Spread.Sheets.ISheetNameChangingEventArgs)
- [ISheetTabClickEventArgs](../interfaces/GC.Spread.Sheets.ISheetTabClickEventArgs)
- [ISheetTabDoubleClickEventArgs](../interfaces/GC.Spread.Sheets.ISheetTabDoubleClickEventArgs)
- [ISlicerChangedEventArgs](../interfaces/GC.Spread.Sheets.ISlicerChangedEventArgs)
- [ISliderOption](../interfaces/GC.Spread.Sheets.ISliderOption)
- [ISortOptions](../interfaces/GC.Spread.Sheets.ISortOptions)
- [ISparklineChangedEventArgs](../interfaces/GC.Spread.Sheets.ISparklineChangedEventArgs)
- [ITableFilterClearedEventArgs](../interfaces/GC.Spread.Sheets.ITableFilterClearedEventArgs)
- [ITableFilterClearingEventArgs](../interfaces/GC.Spread.Sheets.ITableFilterClearingEventArgs)
- [ITableFilteredEventArgs](../interfaces/GC.Spread.Sheets.ITableFilteredEventArgs)
- [ITableFilteringEventArgs](../interfaces/GC.Spread.Sheets.ITableFilteringEventArgs)
- [ITimePickerOption](../interfaces/GC.Spread.Sheets.ITimePickerOption)
- [ITimePickerValue](../interfaces/GC.Spread.Sheets.ITimePickerValue)
- [ITopRowChangedEventArgs](../interfaces/GC.Spread.Sheets.ITopRowChangedEventArgs)
- [ITouchToolStripOpeningEventArgs](../interfaces/GC.Spread.Sheets.ITouchToolStripOpeningEventArgs)
- [IUserFormulaEnteredEventArgs](../interfaces/GC.Spread.Sheets.IUserFormulaEnteredEventArgs)
- [IUserZoomingEventArgs](../interfaces/GC.Spread.Sheets.IUserZoomingEventArgs)
- [IValidationErrorEventArgs](../interfaces/GC.Spread.Sheets.IValidationErrorEventArgs)
- [IValueChangedEventArgs](../interfaces/GC.Spread.Sheets.IValueChangedEventArgs)
- [IValueSortInfo](../interfaces/GC.Spread.Sheets.IValueSortInfo)
- [IWorkBookDefaultOptions](../interfaces/GC.Spread.Sheets.IWorkBookDefaultOptions)
- [IWorkFlowItem](../interfaces/GC.Spread.Sheets.IWorkFlowItem)
- [IWorkFlowOption](../interfaces/GC.Spread.Sheets.IWorkFlowOption)
- [IWorkSheetGridlineOption](../interfaces/GC.Spread.Sheets.IWorkSheetGridlineOption)
- [IWorkSheetSheetAreaOffsetOption](../interfaces/GC.Spread.Sheets.IWorkSheetSheetAreaOffsetOption)
- [IWorkbookHitTestInformation](../interfaces/GC.Spread.Sheets.IWorkbookHitTestInformation)
- [IWorkbookOptions](../interfaces/GC.Spread.Sheets.IWorkbookOptions)
- [IWorksheetOptions](../interfaces/GC.Spread.Sheets.IWorksheetOptions)
- [SheetTabInfo](../interfaces/GC.Spread.Sheets.SheetTabInfo)

### Variables

- [LicenseKey](GC.Spread.Sheets#licensekey)

### Functions

- [findControl](GC.Spread.Sheets#findcontrol)
- [getTypeFromString](GC.Spread.Sheets#gettypefromstring)

## Variables

### <a id="licensekey" name="licensekey"></a> LicenseKey

• **LicenseKey**: `string`

Represents the license key for evaluation version and production version.

## Functions

### <a id="findcontrol" name="findcontrol"></a> findControl

▸ **findControl**(`host`): [`Workbook`](../classes/GC.Spread.Sheets.Workbook)

Gets the Workbook instance by the host element.

#### Parameters

| Name | Type | Description |
| :------ | :------ | :------ |
| `host` | `string` \| `HTMLElement` | The host element or the host element id. |

#### Returns

[`Workbook`](../classes/GC.Spread.Sheets.Workbook)

The Workbook instance.

___

### <a id="gettypefromstring" name="gettypefromstring"></a> getTypeFromString

▸ **getTypeFromString**(`typeString`): `any`

Gets the type from the type string. This method is used for supporting the serialization of the custom object.

#### Parameters

| Name | Type | Description |
| :------ | :------ | :------ |
| `typeString` | `string` | The type string. |

#### Returns

`any`

The type.