[{"id":"1b88a165-2563-437e-99bb-ae30bd4b56db","tags":[{"name":"更新","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf"}]},{"id":"a244ead7-a2c6-47a3-ac17-c5dbfa337362","tags":[{"name":"更新","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf"}]},{"id":"33638a1c-7196-42c1-a96d-38b2d9ba8ac4","tags":[{"name":"更新","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf"}]},{"id":"8e72e33e-b4ab-4fb3-98fc-a0b148134aed","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"86662220-9b9e-4940-9ced-d22642ea49a8","tags":[{"name":"更新","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf"}]},{"id":"55fd3bb8-18d4-4edb-9640-ca3a365b798f","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"760b37c7-c713-4b24-b9ba-4bfe7d8437a6","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"3a083583-1d5f-492b-b450-34b2b5c775b8","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"04e73782-aa78-4dfe-a4f9-e72ed4c78a11","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"57c94653-8893-403b-a5b1-0d1e33a0bd0f","tags":[{"name":"更新","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf"}]},{"id":"09a66339-64c0-415c-b142-0691587a8e4a","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"5b7aeac5-c755-426a-95c7-1ae8e547179a","tags":[{"name":"更新","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf"}]},{"id":"790bc77a-9216-48fd-b8f9-fbc374ebb155","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"900e6cab-065d-4f1c-844d-efa3c074e270","tags":[{"name":"更新","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf"}]},{"id":"0baaf91d-84f6-404c-a487-735226b6d5b6","tags":[{"name":"更新","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf"}]},{"id":"5d37413b-3600-4da9-9700-feea54355f59","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"7ded3a22-15eb-49b8-a488-e83c2cd872eb","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"89c707ed-9841-4e53-96fb-940cc3214804","tags":[{"name":"更新","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf"}]},{"id":"a570c8e7-07a2-47da-965b-da44fd1fa5cf","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"a5a73576-16ea-4cbc-925c-ef547389eaa5","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"69e79655-e015-4f9a-a230-2a25c988c926","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"adf3817f-7667-4a4c-8a5f-767b0b7e1e3e","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"1126cfab-6210-4e28-bee0-02c113fb7a0c","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"63c577e6-6cf9-497e-94e1-2307f7d3f498","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"24769ecd-2b08-4a85-b318-4f533bbf8393","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"2605431b-dc80-491d-886e-28981595d277","tags":[{"name":"更新","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf"}]},{"id":"4f41e22e-eb51-49e5-aeae-a42dd6bf352c","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"aa71a884-c5bc-4842-8d6a-873dfd645167","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"b0576ca2-cb84-4390-9f95-9354ec20eda5","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"dacc7931-6785-4675-be31-80930403cf7b","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"c90d5fdf-420f-4978-8bf5-c9a2bb4334b3","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"6e6ac5b1-1501-4e28-89cc-525139488537","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"ff052704-1389-4029-bcdd-73c6cbe9f807","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"21c6131f-0f2d-41d1-9284-6ad9ee803c1f","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"64e2f4a3-2303-4bfa-8a93-6c23ef01de58","tags":[{"name":"新增","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60"}]},{"id":"4a0842a3-20b1-40c3-8e00-cd5941ffdf53","tags":[{"name":"更新","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97","links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf"}]}]
下表列出了gc-spread-sheets元素中的所有属性。
属性 | SpreadJS API | 类型 | 注释 |
---|---|---|---|
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 | 宿主元素的样式,与angular的样式绑定相同(例如,宽度:400px,高度:600px}。 | |
hostClass | string | 宿主元素的类名。 |
以下示例显示如何使用sheet元素:
@Component({
selector: 'my-app',
template: `<gc-spread-sheets [backColor]="spreadBackColor" [hostStyle]="hostStyle">
</gc-spread-sheets>`,
})
export class AppComponent {
spreadBackColor = 'aliceblue';
hostStyle = {
width: '800px',
height: '600px'
};
}
下表列出了表单事件:
属性 | SpreadJS API | 注释 |
---|---|---|
workbookInitialized | 返回表单实例,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 | |
pictureChanged | GC.Spread.Sheets.Events.PictureChanged | |
floatingObjectRemoving | GC.Spread.Sheets.Events.FloatingObjectRemoving | |
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 example uses an event:
@Component({
selector: 'my-app',
template: `<gc-spread-sheets (workbookInitialized)="workbookInit($event)"
(validationError)="validationError($event)">
</gc-spread-sheets>`,
})
export class AppComponent {
workbookInit (args) {
//do something
}
validationError (args) {
//do something
}
}
下表列出了子元素:
子元素 | SpreadJS API | 数量 |
---|---|---|
gc-worksheet | GC.Spread.Sheets.Worksheet | 任意 |