- GC.Data
- GC.Pivot
- GC.Spread.Pivot
- GC.Spread.Slicers
- GC.Spread.CalcEngine
- GC.Spread.Commands
- GC.Spread.Common
- GC.Spread.Formatter
- GC.Spread.Report
-
GC.Spread.Sheets
- Classes
-
Interfaces
- IImageSize
- FloatingObjectLoadedEventArgs
- FormattedData
- IActiveSheetChangedEventArgs
- IActiveSheetChangingEventArgs
- IBaseSpreadOption
- IBounds
- IButtonClickedEventArgs
- ICalendarOption
- ICellButton
- ICellChangedEventArgs
- ICellClickEventArgs
- ICellColorSortInfo
- ICellDoubleClickEventArgs
- ICellPosition
- ICellsInfo
- IClearChangeInfo
- IClipboardChangedEventArgs
- IClipboardChangingEventArgs
- IClipboardPastedEventArgs
- IClipboardPastingEventArgs
- IColorPickerGroup
- IColorPickerOption
- IColumn
- IColumnBindingInfo
- IColumnChangedEventArgs
- IColumnWidthChangedEventArgs
- IColumnWidthChangingEventArgs
- ICommentChangedEventArgs
- ICommentRemovedEventArgs
- ICommentRemovingEventArgs
- ICopyData
- ICustomSortInfo
- IDirtyCellInfo
- IDragDropBlockCompletedEventArgs
- IDragDropBlockEventArgs
- IDragFillBlockCompletedEventArgs
- IDragFillBlockEventArgs
- IDropdown
- IEditChangeEventArgs
- IEditEndedEventArgs
- IEditEndingEventArgs
- IEditorStatusChangedEventArgs
- IEditStartingEventArgs
- IEnterCellEventArgs
- IExternalReference
- IExternalReferenceDetail
- IFilterButtonHitInfo
- IFloatingObjectChangedEventArgs
- IFloatingObjectRemovedEventArgs
- IFloatingObjectRemovingEventArgs
- IFloatingObjectSelectionChangedEventArgs
- IFontColorSortInfo
- IFormulaInfo
- IFormulaRangeHitInfo
- IGradientFill
- IGradientPathFill
- IHitTestCellTypeHitInfo
- IHitTestCommentHitInfo
- IHitTestDragInfo
- IHitTestFloatingObjectHitInfo
- IHitTestFooterCornerInfo
- IHitTestInformation
- IHitTestOutlineHitInfo
- IHitTestResizeInfo
- IHitTestScrollBarInfo
- IHyperlink
- IIHitTestTabStripInfo
- IIcon
- IInvalidOperationEventArgs
- ILabelOptions
- ILeaveCellEventArgs
- ILeftColumnChangedEventArgs
- IListItem
- IListLayout
- IListOption
- IMaskType
- IMonthPickerOption
- IMultiColumnOption
- IOutlineColumnCheckStatusChanged
- IOutlineHitInfo
- IParamRange
- IPasteData
- IPatternFill
- IPictureChangedEventArgs
- IPictureSelectionChangedEventArgs
- IPivotTableChangedEventArgs
- IProtectionOptions
- IRange
- IRangeChangedEventArgs
- IRangeFilterClearedEventArgs
- IRangeFilterClearingEventArgs
- IRangeFilteredEventArgs
- IRangeFilteringEventArgs
- IRangeGroupStateChangedEventArgs
- IRangeGroupStateChangingEventArgs
- IRangeSortedEventArgs
- IRangeSortingEventArgs
- IRowChangedEventArgs
- IRowHeightChangedEventArgs
- IRowHeightChangingEventArgs
- ISelectionChangedEventArgs
- ISelectionChangingEventArgs
- ISetBorderOptions
- IShapeChangedEventArgs
- IShapeRemovedEventArgs
- IShapeRemovingEventArgs
- IShapeSelectionChangedEventArgs
- ISheetChangedEventArgs
- ISheetChangingEventArgs
- ISheetDefaultOption
- ISheetNameChangedEventArgs
- ISheetNameChangingEventArgs
- ISheetTabClickEventArgs
- ISheetTabDoubleClickEventArgs
- ISlicerChangedEventArgs
- ISliderOption
- ISortOptions
- ISparklineChangedEventArgs
- ITableFilterClearedEventArgs
- ITableFilterClearingEventArgs
- ITableFilteredEventArgs
- ITableFilteringEventArgs
- ITimePickerOption
- ITimePickerValue
- ITopRowChangedEventArgs
- ITouchToolStripOpeningEventArgs
- IUserFormulaEnteredEventArgs
- IUserZoomingEventArgs
- IValidationErrorEventArgs
- IValueChangedEventArgs
- IValueSortInfo
- IWorkBookDefaultOptions
- IWorkbookHitTestInformation
- IWorkbookOptions
- IWorkFlowItem
- IWorkFlowOption
- IWorkSheetGridlineOption
-
IWorksheetOptions
- IWorkSheetSheetAreaOffsetOption
- SheetTabInfo
- IDecoration
- ICornerFold
- IParameter
- ISheetTabStyle
- ISheetNameTabStyleMap
- ISortState
- IAddColumnButtonOption
- ICustomDocPropsManager
- IAddRowButtonOption
- IAppDocProps
- ICoreDocProps
- IBuiltInFileIcons
- ICustomDocumentProperty
- IDocProps
- Enumerations
- GC.Spread.Sheets.IO
- GC.Spread.Sheets.AutoMerge
- GC.Spread.Sheets.Barcode
- GC.Spread.Sheets.Bindings
- GC.Spread.Sheets.CalcEngine
- GC.Spread.Sheets.Search
- GC.Spread.Sheets.CellState
- GC.Spread.Sheets.CellTypes
- GC.Spread.Sheets.Charts
- GC.Spread.Sheets.Commands
- GC.Spread.Sheets.Comments
- GC.Spread.Sheets.ConditionalFormatting
- GC.Spread.Sheets.ContextMenu
- GC.Spread.Sheets.DataValidation
- GC.Spread.Sheets.Fill
- GC.Spread.Sheets.Filter
- GC.Spread.Sheets.FloatingObjects
- GC.Spread.Sheets.FormulaTextBox
- GC.Spread.Sheets.FormulaPanel
- GC.Spread.Sheets.Hyperlink
- GC.Spread.Sheets.InputMask
- GC.Spread.Sheets.NameBox
- GC.Spread.Sheets.OutlineColumn
- GC.Spread.Sheets.Outlines
- GC.Spread.Sheets.PDF
- GC.Spread.Sheets.Print
- GC.Spread.Sheets.Shapes
- GC.Spread.Sheets.Slicers
- GC.Spread.Sheets.Sparklines
- GC.Spread.Sheets.StatusBar
- GC.Spread.Sheets.Tables
- GC.Spread.Sheets.TableSheet
- GC.Spread.Sheets.GanttSheet
- GC.Spread.Sheets.Touch
- GC.Spread.Sheets.Designer
- GC.Spread.Excel
GC.Spread.Sheets.IWorksheetOptions
Interface: IWorksheetOptions
Spread.Sheets.IWorksheetOptions
Table of contents
Properties
- addColumnButtonOption
- addRowButtonOption
- allowCellOverflow
- clipBoardOptions
- colHeaderAutoText
- colHeaderAutoTextIndex
- colHeaderVisible
- frozenlineColor
- gridline
- isProtected
- keepUnknownFormulas
- protectionOptions
- rightToLeft
- rowHeaderAutoText
- rowHeaderAutoTextIndex
- rowHeaderVisible
- selectionBackColor
- selectionBorderColor
- sheetAreaOffset
- sheetTabColor
- showFormulas
- showZeros
Properties
addColumnButtonOption
• Optional addColumnButtonOption: IAddColumnButtonOption
The add column button's options.
addRowButtonOption
• Optional addRowButtonOption: IAddRowButtonOption
The add row button's options.
allowCellOverflow
• allowCellOverflow: boolean
indicates whether data can overflow into adjacent empty cells.
clipBoardOptions
• clipBoardOptions: ClipboardPasteOptions
The clipboard option.
colHeaderAutoText
• colHeaderAutoText: HeaderAutoText
Indicates whether the column header displays letters or numbers or is blank.
colHeaderAutoTextIndex
• colHeaderAutoTextIndex: HeaderAutoText
Specifies which column header row displays the automatic text when there are multiple column header rows.
colHeaderVisible
• colHeaderVisible: boolean
Indicates whether the column header is visible.
frozenlineColor
• frozenlineColor: string
A color string used to represent the frozen line color, such as "red", "#FFFF00", "rgb(255,0,0)", "Accent 5", and so on.
gridline
• gridline: IWorkSheetGridlineOption
The grid line's options.
isProtected
• isProtected: boolean
Indicates whether cells on this sheet that are marked as protected cannot be edited.
keepUnknownFormulas
• keepUnknownFormulas: boolean
Indicates whether the unknown formulas could be included in sheet json data.
protectionOptions
• protectionOptions: IProtectionOptions
A value that indicates the elements that you want users to be able to change.
rightToLeft
• rightToLeft: boolean
Indicates whether the sheet is rendered from right to left.
rowHeaderAutoText
• rowHeaderAutoText: HeaderAutoText
Indicates whether the row header displays letters or numbers or is blank.
rowHeaderAutoTextIndex
• rowHeaderAutoTextIndex: HeaderAutoText
Specifies which row header column displays the automatic text when there are multiple row header columns.
rowHeaderVisible
• rowHeaderVisible: boolean
Indicates whether the row header is visible.
selectionBackColor
• selectionBackColor: string
The selection's background color for the sheet.
selectionBorderColor
• selectionBorderColor: string
The selection's border color for the sheet.
sheetAreaOffset
• sheetAreaOffset: IWorkSheetSheetAreaOffsetOption
The sheetAreaOffset's options.
sheetTabColor
• sheetTabColor: string
A color string used to represent the sheet tab color, such as "red", "#FFFF00", "rgb(255,0,0)", "Accent 5", and so on.
showFormulas
• showFormulas: boolean
indicates whether display the formulas string not the formula result.
showZeros
• showZeros: boolean
indicates whether display the 0 in cells containing zero value. Default is true.