spreadjs 设置单元格样式失效

收藏

let sheet = this.spread.getActiveSheet();
sheet.setStyle(r, c, this.formatStyle);
使用sheet.setStyle( r , c , style); 给指定单元格设置样式

formatStyle ：
this.formatStyle = new GC.Spread.Sheets.Style();
this.formatStyle.hAlign = GC.Spread.Sheets.HorizontalAlign.center;
this.formatStyle.vAlign = GC.Spread.Sheets.VerticalAlign.center;
this.formatStyle.backColor = "#4323ff";
现在想将所有样式还原，各位大神怎么破，一个一个单元格做的话耗时太长了，希望可以直接全部单元格背景色是白色。我使用that.spread.options.backColor = 'red';这个方法去设置背景颜色不能覆盖上面所设样式

Fiooona · Fiooona

可以使用setDefaultStyle来设置样式：

var defaultStyle = new GC.Spread.Sheets.Style();
defaultStyle.backColor = "LemonChiffon";
defaultStyle.foreColor = "Red";
defaultStyle.formatter = "0.00";
defaultStyle.hAlign = GC.Spread.Sheets.HorizontalAlign.center;
defaultStyle.borderLeft = new GC.Spread.Sheets.LineBorder("Green",GC.Spread.Sheets.LineStyle.medium);
defaultStyle.borderTop = new GC.Spread.Sheets.LineBorder("Green",GC.Spread.Sheets.LineStyle.medium);
defaultStyle.borderRight = new GC.Spread.Sheets.LineBorder("Green",GC.Spread.Sheets.LineStyle.medium);
defaultStyle.borderBottom = new GC.Spread.Sheets.LineBorder("Green",GC.Spread.Sheets.LineStyle.medium);
activeSheet.setDefaultStyle(defaultStyle, GC.Spread.Sheets.SheetArea.viewport);

复制代码

可以参考：https://demo.grapecity.com.cn/sp ... l#scsheetstyle.html

		自动登录	找回密码
密码			立即注册

[已处理] spreadjs 设置单元格样式失效

1 个回复

微信认证勋章