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