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

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)