本帖最后由 Richard.Ma 于 2021-8-2 10:18 编辑
例子:
- function initSpread(spread) {
- var sheet = spread.getActiveSheet();
- //Add text to first cell
- sheet.setValue(0, 0, "带料 不锈钢 800");
- let range = new GC.Spread.Sheets.Range(-1, -1, -1, -1);
- const cfs = sheet.conditionalFormats;
- const style = new GC.Spread.Sheets.Style();
- style.foreColor = "red";
- cfs.addCellValueRule(GC.Spread.Sheets.ConditionalFormatting.ComparisonOperators.lessThan, 0, 0, style, [range]);
- }
复制代码 上述代码,0,0的单元格出现非预期的红显。
|