您好,因为您在函数里用了
var style = new GC.Spread.Sheets.Style();
导致原来的样式会被覆盖,建议您在此函数中注释上面的语句,
获取对应单元格字体的style后再设置背景色就不会影响到字体的样式了。- function setBackColor(row,col,sheetNumber) {
- row = parseInt(row) - 1;
- col = parseInt(col) -1;
- sheetNumber = parseInt(sheetNumber) - 1;
- // var style = new GC.Spread.Sheets.Style();
- var style = sheet.getStyle(0,0)
- style.backColor = '#E0E0E0';
- sheet.setStyle(row,col,style,GC.Spread.Sheets.SheetArea.viewport);
- }
复制代码
|