SpreadJS 14
Getting Started / API Changes / User Interface API Changes
In This Topic
    User Interface API Changes
    In This Topic

    The following table lists user interface changes:

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

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

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