SpreadJS 13
SpreadJS Documentation / Developer's Guide / Get Started / API Changes / User Interface API Changes
In This Topic
    User Interface API Changes
    In This Topic

    The following table lists user interface changes:

    V11 V9
    GC.Spread.Sheet.CellRange GcSpread.Sheets.Cell GcSpread.Sheets.Row GcSpread.Sheets.Column
    constructor(sheet, row, col, rowCount, colCount, sheetArea) constructor(sheet, row, col, sheetArea) constructor(sheet, index, sheetArea) constructor(sheet, index, sheetArea)
    sheet sheet sheet sheet
    row row index  
    rowCount row2, row2 - row + 1 index2, index2 - index + 1  
    col col   index
    colCount col2, col2 - col + 1   index2, index2 - index + 1
    sheetArea sheetArea sheetArea sheetArea
    value(value) value(value)    
    text(value) text(value)    
    formula(value) formula(value)    
    tag(value) tag(value) tag(value) tag(value)
    backColor(value) backColor(value) backColor(value) backColor(value)
    foreColor(value) foreColor(value) foreColor(value) foreColor(value)
    hAlign(value) hAlign(value) hAlign(value) hAlign(value)
    vAlign(value) vAlign(value) vAlign(value) vAlign(value)
    themeFont(value) themeFont(value) themeFont(value) themeFont(value)
    font(value) font(value) font(value) font(value)
    formatter(value) formatter(value) formatter(value) formatter(value)
    borderLeft(value) borderLeft(value) borderLeft(value) borderLeft(value)
    borderTop(value) borderTop(value) borderTop(value) borderTop(value)
    borderRight(value) borderRight(value) borderRight(value) borderRight(value)
    borderBottom(value) borderBottom(value) borderBottom(value) borderBottom(value)
    locked(value) locked(value) locked(value) locked(value)
    textIndent(value) textIndent(value) textIndent(value) textIndent(value)
    wordWrap(value) wordWrap(value) wordWrap(value) wordWrap(value)
    shrinkToFit(value) shrinkToFit(value) shrinkToFit(value) shrinkToFit(value)
    backgroundImage(value) backgroundImage(value) backgroundImage(value) backgroundImage(value)
    backgroundImageLayout(value) backgroundImageLayout(value) backgroundImageLayout(value) backgroundImageLayout(value)
    validator(value) dataValidator(value) dataValidator(value) dataValidator(value)
    cellType(value) cellType(value) cellType(value) cellType(value)
    tabStop(value) tabStop(value) tabStop(value) tabStop(value)
    textDecoration(value) textDecoration(value) textDecoration(value) textDecoration(value)
    imeMode(value) imeMode(value) imeMode(value) imeMode(value)
    watermark(value) watermark(value) watermark(value) watermark(value)
    width(value)     width(value)
    height(value)   height(value)  
    visible(value)   visible(value) visible(value)
    resizable(value)   resizable(value) resizable(value)
        clearStyleProperty(propertyName) clearStyleProperty(propertyName)

    The following table lists method changes:

    V10 V9
    GC.Spread.Sheets.Worksheet GcSpread.Sheets.Sheet
    getCell(row, col, sheetArea) getCell(row, col, sheetArea)
    getRange(row, col, rowCount ,colCount, sheetArea) getCells(row, col, row2, col2, sheetArea)
    getRow(index, sheetArea)
    getRows(index, index2, sheetArea)
    getColumn(index, sheetArea)
    getColumns(index, index2, sheetArea)

    The setBorder method has been changed as listed in the following table:

    V10 V9
    GC.Spread.Sheets.CellRange GcSpread.Sheets.Sheet
    setBorder(border, option) setBorder(cellRange, border, option, sheetArea)
    clear(type)