SpreadJS 14
Getting Started / API Changes / Workbook API Changes
In This Topic
    Workbook API Changes
    In This Topic

    This table lists API changes in the workbook:

    V13 V9
    param options in constructor is anonymous object
    sheetCount;
    font
    ;
    allowUserDragDrop
    ;
    allowUserDragFill
    ;
    allowUserZoom
    ;
    allowUserResize
    ;
    allowUndo
    ;
    allowSheetReorder
    ;
    defaultDragFillType
    ;
    showDragFillSmartTag
    ;
    showHorizontalScrollbar
    ;
    showVerticalScrollbar
    ;
    scrollbarShowMax
    ;
    scrollbarMaxAlign
    ;
    tabStripVisible
    ;
    tabStripRatio
    ;
    tabEditable
    ;
    newTabVisible
    ;
    tabNavigationVisible
    ;
    cutCopyIndicatorVisible
    ;
    cutCopyIndicatorBorderColor
    ;
    backColor
    ;
    backgroundImage
    ;
    backgroundImageLayout
    ;
    grayAreaBackColor
    ;
    showResizeTip
    ;
    showDragDropTip
    ;
    showDragFillTip
    ;
    showScrollTip
    ;
    scrollIgnoreHidden
    ;
    highlightInvalidData
    ;
    useTouchLayout
    ;
    hideSelection
    ;
    resizeZeroIndicator
    ;
    allowUserEditFormula
    ;
    enableFormulaTextbox
    ;
    autoFitType
    ;

    param options in constructor is GcSpread.Sheets.GcSpreadSheetsOptions

    sheetCount;
    name
    ;
    activeSheetIndex
    ;
    sheets
    ;
    font
    ;
    allowUserZoom
    ;
    allowUserResize
    ;
    tabStripVisible
    ;
    tabStripRatio
    ;
    tabEditable
    ;
    newTabVisible
    ;

    options.allowUserDragDrop canUserDragDrop(value)
    options.allowUserDragFill canUserDragFill(value)
    options.allowUserZoom allowUserZoom(value)
    options.allowUserResize allowUserResize(value)
    options.allowUndo allowUndo(value)
    options.allowSheetReorder allowSheetReorder(value)
    options.defaultDragFillType defaultDragFillType(value)
    options.showDragFillSmartTag showDragFillSmartTag(value)
    options.showHorizontalScrollbar showHorizontalScrollbar(value)
    options.showVerticalScrollbar showVerticalScrollbar(value)
    options.scrollbarShowMax scrollbarShowMax(value)

    options.scrollbarMaxAlign

    scrollbarMaxAlign(value)

    options.tabStripVisible tabStripVisible(value)
    options.tabStripRatio

    setTabStripRatio(tabStripRatio, skipRefreshScrollbar)

    getTabStripRatio()

    options.tabEditable tabEditable(value)
    options.newTabVisible newTabVisible(value)
    options.tabNavigationVisible tabNavigationVisible(value)
    options.cutCopyIndicatorVisible cutCopyIndicatorVisible(value)
    options.cutCopyIndicatorBorderColor cutCopyIndicatorBorderColor(value)
    options.backColor backColor(value)
    options.backgroundImage backgroundImage(value)
    options.backgroundImageLayout backgroundImageLayout(value)

    options.grayAreaBackColor

    grayAreaBackColor(value)
    options.showResizeTip showResizeTip(value)
    options.showDragDropTip showDragDropTip(value)
    options.showDragFillTip showDragFillTip(value)
    options.showScrollTip showScrollTip(value)
    options.scrollIgnoreHidden scrollIgnoreHidden(value)
    options.highlightInvalidData highlightInvalidData(value)
    options.useTouchLayout useTouchLayout(value)
    options.hideSelection hideSelection(value)
    options.resizeZeroIndicator resizeZeroIndicator(value)
    options.canUserEditFormula canUserEditFormula(value)
    options.enableFormulaTextbox enableFormulaTextbox(value)
    options.autoFitType autoFitType(value)
      showCell(row, col, verticalPosition, horizontalPosition)
      showColumn(col, horizontalPosition)
      showActiveCell(verticalPosition, horizontalPosition)
      showRow(row, verticalPosition)
    options.referenceStyle  
    commandManager()  
    undoManager()  
      doCommand(action)
      addCustomFunctionDescription(fnd)
      getCustomFunctionDescription(name)
      removeCustomFunctionDescription(name)
      clearCustomFunctionDescriptions()
    suspendPaint()/resumePaint() isPaintSuspended(value)

    The following items have been removed: