[{"id":"b66f8b1e-cc14-4e89-9679-abd5687d283d","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"569bb90a-ea68-46c6-96f1-ab151c120714","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"5eb52f08-2d1a-4362-9ffc-4871bdc10f3f","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"341dd607-b97d-4d70-bde2-53acda6b6c95","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"05349273-414f-4208-9ea2-c4fc8f4ea2cb","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"86089f76-b778-4d52-821e-6f27de3df613","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"b81e4fd6-1fc5-43a0-a258-b6e16a5cbec6","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"8aa8ce31-43e4-438e-951f-241608435260","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"37343f41-6ec2-4c7e-b21d-2cc18d5ce1e0","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"5915e52f-64f8-4146-b8bd-81bead6324a3","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"836ba889-af9e-460d-a4cc-c24d922795f2","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"4ae14b06-bb68-4394-a210-a46b8f028346","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"d8f42066-e9dc-4411-bdcf-43b1a203370c","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"7ef86f16-b1a0-49f7-9592-612b9be02b25","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"b29c7775-a9a4-451e-a1b5-01d19ed5ca5e","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"e56f3989-8f81-46af-90fa-a4813eeb976f","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"2526c963-f170-45a8-923e-91b0712a9810","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"24575cf0-501a-44f9-8426-c40f8f4b5552","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"1a6f8d7f-acd6-42be-8c4f-f464c6218381","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"82b176fd-5cab-498c-909e-8fa7d29c38d8","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"1708b3a9-4f37-44a8-8f0e-f9a2d2e5d940","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"c9ac246e-29fb-4bc4-8231-8439795bb590","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"94f2a5c3-2539-436a-af75-23fbbd1a3957","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"d99594f4-2d40-4df4-9419-ba2ca6aa3f7f","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"fd66e72d-0f10-4f57-9807-6db26290ab2e","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"8f344863-503d-4bc3-a594-3815e7d55f5c","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"9be82601-de9d-4c18-948a-23ab6f4dd431","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"6495f3c0-b463-47e0-b08a-ca949672211e","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"b4bede08-3f08-4839-ba4a-abc7ac195bde","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"4afcdfc0-3ff5-4f2b-a223-f8fc042a5bbe","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"422062c4-fa40-4771-a86f-008efe6d86e5","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"d87e8013-86a7-4840-8d25-6f62e14eb4ac","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"a6acedfd-4043-4c64-a5d1-aec3326df9e7","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"dbdc0b24-06c4-48b9-8d6c-7455119dc773","tags":[{"product":null,"links":null,"id":"9e117e35-984a-4c14-95ca-ef0ec7b9fb60","name":"\u65B0\u589E","color":"DarkGreen","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"a3856849-954a-4cfc-96a6-382e530d3638","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]},{"id":"4a39306b-ffa5-433d-80a3-28e41f929b72","tags":[{"product":null,"links":null,"id":"a2f84374-4a3f-4d22-96fd-765e9de495bf","name":"\u66F4\u65B0","color":"Coral","productId":"098be112-50ec-44e4-b746-6bc8bf76af97"}]}]
        
(Showing Draft Content)

Workbook 元素

下表列出了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

任意