The following table lists the attributes of the gc-spread-sheets 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 |
| 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 |
| 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 |
| 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 |
| gc-worksheet | GC.Spread.Sheets.Worksheet | any |