Spread.Sheets Documentation
Workbook API Changes
Spread.Sheets Documentation > Developer's Guide > Getting Started > API Changes > Workbook API Changes

This table lists API changes in the workbook:

V11 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: