The following table lists the attributes of the SpreadSheets element.
| Attribute | API Reference | Type |
| name | Workbook.name | string |
| allowUserZoom | Workbook.options.allowUserZoom = value | boolean |
| allowUserResize | Workbook.options.allowUserResize = value | boolean |
| tabStripVisible | Workbook.options.tabStripVisible = value | boolean |
| tabEditable | Workbook.options.tabEditable = value | boolean |
| newTabVisible | Workbook.options.newTabVisible = value | boolean |
| allowUserEditFormula | Workbook.options.allowUserEditFormula = value | boolean |
| autoFitType | Workbook.options.autofittype = value | GC.Spread.Sheets.AutoFitType |
| allowUserDragFill | Workbook.options.allowUserDragFill = value | boolean |
| allowUserDragDrop | Workbook.options.allowUserDragDrop = value | boolean |
| allowUserDragMerge | Workbook.options.allowUserDragMerge = value | boolean |
| allowUndo | Workbook.options.allowUndo = value | boolean |
| allowUserDeselect | Workbook.options.allowUserDeselect = value | boolean |
| allowSheetReorder | Workbook.options.allowSheetReorder = value | boolean |
| allowContextMenu | Workbook.options.allowContextMenu = value | boolean |
| allowCopyPasteExcelStyle | Workbook.options.allowCopyPasteExcelStyle = value | boolean |
| allowExtendPasteRange | Workbook.options.allowExtendPasteRange = value | boolean |
| cutCopyIndicatorVisible | Workbook.options.cutCopyIndicatorVisible = value | boolean |
| cutCopyIndicatorBorderColor | Workbook.options.cutCopyIndicatorBorderColor = value | string |
| copyPasteHeaderOptions | Workbook.options.copyPasteHeaderOptions = value | GC.Spread.Sheets.CopyPasteHeaderOptions |
| defaultDragFillType | Workbook.options.defaultDragFillType = value | GC.Spread.Sheets.Fill.AutoFillType |
| enableFormulaTextbox | Workbook.options.enableFormulaTextbox = value | boolean |
| hideSelection | Workbook.options.hideSelection = value | boolean |
| highlightInvalidData | Workbook.options.highlightInvalidData = value | boolean |
| referenceStyle | Workbook.options.referenceStyle = value | GC.Spread.Sheets.ReferenceStyle |
| backColor | Workbook.options.backColor = value | string |
| grayAreaBackColor | Workbook.options.grayAreaBackColor = value | string |
| backgroundImage | Workbook.options.backgroundImage = value | string |
| backgroundImageLayout | Workbook.options.backgroundImageLayout = value | GC.Spread.Sheets.ImageLayout |
| resizeZeroIndicator | Workbook.options.resizeZeroIndicator = value | GC.Spread.Sheets.ResizeZeroIndicator |
| showVerticalScrollbar | Workbook.options.showVerticalScrollbar = value | boolean |
| showHorizontalScrollbar | Workbook.options.showHorizontalScrollbar = value | boolean |
| showScrollTip | Workbook.options.showScrollTip = value | GC.Spread.Sheets.ShowScrollTip |
| showResizeTip | Workbook.options.showResizeTip = value | GC.Spread.Sheets.ShowResizeTip |
| showDragDropTip | Workbook.options.showDragDropTip = value | boolean |
| showDragFillTip | Workbook.options.showDragFillTip = value | boolean |
| showDragFillSmartTag | Workbook.options.showDragFillSmartTag = value | boolean |
| scrollbarShowMax | Workbook.options.scrollbarShowMax = value | boolean |
| scrollbarMaxAlign | Workbook.options.scrollbarMaxAlign = value | boolean |
| scrollIgnoreHidden | Workbook.options.scrollIgnoreHidden = value | boolean |
| tabStripRatio | Workbook.options.tabStripRatio = value | number |
| tabNavigationVisible | Workbook.options.tabNavigationVisible = value | boolean |
| useTouchLayout | Workbook.options.useTouchLayout = value | boolean |
| hostStyle | any (The style of host element is the same as the style binding in AngularJS. For example; {width:400px, height:600px } ) | |
| hostClass | string (The class name of host element) |
The following table lists the output events.
| Attribute | API Reference | Comment |
| workbookInitialized | return the workbook instance, args (spread: workbook) | |
| validationError | GC.Spread.Sheets.Events.ValidationError | |
| cellClick | GC.Spread.Sheets.Events.CellClick | |
| cellDoubleClick | GC.Spread.Sheets.Events.CellDoubleClick | |
| enterCell | GC.Spread.Sheets.Events.EnterCell | |
| leaveCell | GC.Spread.Sheets.Events.LeaveCell | |
| valueChanged | GC.Spread.Sheets.Events.ValueChanged | |
| topRowChanged | GC.Spread.Sheets.Events.TopRowChanged | |
| leftColumnChanged | GC.Spread.Sheets.Events.LeftColumnChanged | |
| invalidOperation | GC.Spread.Sheets.Events.InvalidOperation | |
| rangeFiltering | GC.Spread.Sheets.Events.RangeFiltering | |
| rangeFiltered | GC.Spread.Sheets.Events.RangeFiltered | |
| tableFiltering | GC.Spread.Sheets.Events.TableFiltering | |
| tableFiltered | GC.Spread.Sheets.Events.TableFiltered | |
| rangeSorting | GC.Spread.Sheets.Events.RangeSorting | |
| rangeSorted | GC.Spread.Sheets.Events.RangeSorted | |
| clipboardChanging | GC.Spread.Sheets.Events.ClipboardChanging | |
| clipboardChanged | GC.Spread.Sheets.Events.ClipboardChanged | |
| clipboardPasting | GC.Spread.Sheets.Events.ClipboardPasting | |
| clipboardPasted | GC.Spread.Sheets.Events.ClipboardPasted | |
| columnWidthChanging | GC.Spread.Sheets.Events.ColumnWidthChanging | |
| columnWidthChanged | GC.Spread.Sheets.Events.ColumnWidthChanged | |
| rowHeightChanging | GC.Spread.Sheets.Events.RowHeightChanging | |
| rowHeightChanged | GC.Spread.Sheets.Events.RowHeightChanged | |
| dragDropBlock | GC.Spread.Sheets.Events.DragDropBlock | |
| dragDropBlockCompleted | GC.Spread.Sheets.Events.DragDropBlockCompleted | |
| dragFillBlock | GC.Spread.Sheets.Events.DragFillBlock | |
| dragFillBlockCompleted | GC.Spread.Sheets.Events.DragFillBlockCompleted | |
| editStarting | GC.Spread.Sheets.Events.EditStarting | |
| editChange | GC.Spread.Sheets.Events.EditChange | |
| editEnding | GC.Spread.Sheets.Events.EditEnding | |
| editEnd | GC.Spread.Sheets.Events.EditEnd | |
| editEnded | GC.Spread.Sheets.Events.EditEnded | |
| rangeGroupStateChanging | GC.Spread.Sheets.Events.RangeGroupStateChanging | |
| rangeGroupStateChanged | GC.Spread.Sheets.Events.RangeGroupStateChanged | |
| selectionChanging | GC.Spread.Sheets.Events.SelectionChanging | |
| selectionChanged | GC.Spread.Sheets.Events.SelectionChanged | |
| sheetTabClick | GC.Spread.Sheets.Events.SheetTabClick | |
| sheetTabDoubleClick | GC.Spread.Sheets.Events.SheetTabDoubleClick | |
| sheetNameChanging | GC.Spread.Sheets.Events.SheetNameChanging | |
| sheetNameChanged | GC.Spread.Sheets.Events.SheetNameChanged | |
| userZooming | GC.Spread.Sheets.Events.UserZooming | |
| userFormulaEntered | GC.Spread.Sheets.Events.UserFormulaEntered | |
| cellChanged | GC.Spread.Sheets.Events.CellChanged | |
| columnChanged | GC.Spread.Sheets.Events.ColumnChanged | |
| rowChanged | GC.Spread.Sheets.Events.RowChanged | |
| activeSheetChanging | GC.Spread.Sheets.Events.ActiveSheetChanging | |
| activeSheetChanged | GC.Spread.Sheets.Events.ActiveSheetChanged | |
| sparklineChanged | GC.Spread.Sheets.Events.SparklineChanged | |
| rangeChanged | GC.Spread.Sheets.Events.RangeChanged | |
| buttonClicked | GC.Spread.Sheets.Events.ButtonClicked | |
| editorStatusChanged | GC.Spread.Sheets.Events.EditorStatusChanged | |
| floatingObjectChanged | GC.Spread.Sheets.Events.FloatingObjectChanged | |
| floatingObjectSelectionChanged | GC.Spread.Sheets.Events.FloatingObjectSelectionChanged | |
| floatingObjectRemoved | GC.Spread.Sheets.Events.FloatingObjectRemoved | |
| pictureSelectionChanged | GC.Spread.Sheets.Events.PictureSelectionChanged | |
| floatingObjectLoaded | GC.Spread.Sheets.Events.FloatingObjectLoaded | |
| touchToolStripOpening | GC.Spread.Sheets.Events.TouchToolStripOpening | |
| commentChanged | GC.Spread.Sheets.Events.CommentChanged | |
| commentRemoving | GC.Spread.Sheets.Events.CommentRemoving | |
| commentRemoved | GC.Spread.Sheets.Events.CommentRemoved | |
| slicerChanged | GC.Spread.Sheets.Events.SlicerChanged |
The following table lists the child elements.
| Child Element | API Reference | Count |
| Worksheet | GC.Spread.Sheets.Worksheet | any |