SpreadJS 文档
SpreadJS 文档 / 开发者指南 / JavaScript框架 / 在 Angular 中使用 SpreadJS / Sheet 元素
在本主题中
    Sheet 元素
    在本主题中

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

    JavaScript
    复制代码
    @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:

    JavaScript
    复制代码
    @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 任意