SpreadJS 文档
SpreadJS 文档 / 开发者指南 / JavaScript 框架 / 在React中使用SpreadJS / Spread-Sheets 标签
在本主题中
    Spread-Sheets 标签
    在本主题中

    下表列出了SpreadSheets元素的属性。

    属性 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 (host元素的样式与AngularJS中的样式绑定相同。 例如; {width:400px,height:600px} )
    hostClass string (宿主元素的类名称)

    下表列出了输出事件。

    属性 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
    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

    下表列出了子元素。

    子元素 API 参考 计数
    Worksheet GC.Spread.Sheets.Worksheet any