[{"id":"528e7c85-ad74-4b92-9f07-1b35686aae11","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"b2467823-b20a-4944-8436-3f4a40c2c3a6","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"f9b599ec-cdc1-43e1-9642-54622ec0faf6","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"0c129b8a-7ec0-4a16-8d94-9d4c96121d6b","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"747081eb-5a06-4bac-8e9e-ce86732d168f","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"7d934b01-e977-477a-b989-d25201e93a61","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"62adecb9-3003-4dce-9fa0-33dcdebbd1ed","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"e2676e30-9712-47a0-ae38-733003d74c61","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"6ef06797-8c4c-4b4b-ab10-bb5049aedeff","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"48e7593f-03b2-454d-a45c-cfebca71f3aa","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"59bb5a92-94c0-471a-bbe7-422ee9c9671d","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"56744168-6aab-46c6-8144-702458dc0030","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"6e65ca69-e34b-47ac-a900-df6142d1173a","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"69a3b51b-bbd6-4bf9-b1bf-404bc1130679","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"7e9ac756-4b27-4ccd-87b4-d959dae40aac","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"f9f145be-535c-49f0-85e0-46b82e05ebb9","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"f21c39dc-8e0d-4974-8795-5568b46411b4","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"f1c5b466-1fd4-4130-88dd-9a624a6ea008","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"61aee7ec-5eae-4b92-b381-bc6236377b8b","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"8f3919c2-f0c9-4000-8008-be65026b6290","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"1ec6d1ad-90cc-4094-980f-43aa5fbf9540","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"78b0db4b-017c-4839-8c1e-60f6f5cc6d2b","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"cdf43116-31aa-4260-b33a-9a31c6845eb2","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"9e8044a9-aa63-4694-997d-13747cd3ee9d","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"ecd23122-8f53-4c60-837d-198fd699dfc0","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"7a9b6718-9f7b-4f86-a13f-1af00e6e1fd8","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"363dda9e-fe69-4e08-aae8-37d0147254e3","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"5c96fdcf-19a2-4aed-838a-8ed87a27a690","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"43ba9142-9a42-4717-866b-92a6acafcf6e","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"58f7dc81-7471-48e9-9020-1a2359e01121","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"0536592d-c039-4a1b-b482-aa0ba315a78d","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"2981cffc-37a3-4e64-b682-71d898259ddc","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"bdfcce31-4e7a-46f0-8571-d643d6ae5215","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"a1c74507-1bc8-4333-b919-337bcd7f421a","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"6bb55ad9-04e0-47f2-8343-5e9cb0f24fbc","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"f668bfbe-c4fa-4b5f-add5-f82db90b9710","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"6c4638bd-062c-4cc3-97c1-0daafc8624de","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"55aca15e-f3aa-46ab-95c6-9af4e0c779bc","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"000b26f4-c878-447f-acfc-d7e5571dbd01","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"2822ff18-ccc4-40ab-b205-760e5dc66a93","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"978e1414-788c-42b3-ab45-c91e172a80f8","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"2fced7df-d3ca-43a7-86d8-dfebd34541f7","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"f7b8e156-8572-43aa-aec7-fe176eacc758","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"2a1a5e3f-2bbe-4b96-8587-dbe13a089d4d","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"9a3f74e4-ebdf-4c28-ac95-6901cccf878c","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"9fd5b62f-8f1b-444e-9dcb-3d71965cfc6a","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"ab33528a-79c3-4b1c-82dd-15c99eb9419b","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"3a2e4995-96ce-4123-b7a9-d801c3135e5c","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"1480a066-6c2d-4d50-bf05-fcfb0ea27869","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"533dc174-547d-4419-8260-a62dc1e3a2b6","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"2756d249-e4ca-48db-9775-1b76fc3efc5a","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"c0e02434-b0d8-4b70-83ef-f6ad2ac07536","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]}]
DEMOS DOC DESIGNER API
DOWNLOAD
(Showing Draft Content)

Gc-spread-sheets Element

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

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

gc-worksheet

GC.Spread.Sheets.Worksheet

any