本帖最后由 Derrick.Jiao 于 2021-9-9 17:46 编辑
var style = new GC.Spread.Sheets.Style();
style.backColor = "pink";
var cell = new GC.Spread.Sheets.ConditionalFormatting.NormalConditionRule();
cell.ruleType(GC.Spread.Sheets.ConditionalFormatting.RuleType.cellValueRule);
cell.operator(GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators.equalsTo);
cell.value1();
cell.ranges([new GC.Spread.Sheets.Range(3, 8, activesheet.getRowCount()-3, 1),new GC.Spread.Sheets.Range(3, 10, activesheet.getRowCount()-3, 7)]);
cell.style(style);
activesheet.conditionalFormats.addRule(cell);
设置区域单元格如果为空就变红,但是 不管value1('')value1() value1(null) 为0的单元格也会出现条件格式 所以这个value()里到底填什么才是空啊
|