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) |