spreadjs如何获取某行是否存在某个规则？

收藏

本帖最后由 zhouhao 于 2021-9-26 17:45 编辑

比如我给第一行所有单元格都设置了一条公式规则cfs.addFormulaRule(“=$A1=TRUE”, style, [range])，我希望再次设置的时候校验一下是否已经设置了该规则，请问有什么办法获取到吗

const sheet = context.getSheetFromName(options.sheetName);
const cfs = sheet.conditionalFormats;
let style = context.getNamedStyle("taskList");
if (!style) {
      style = new GC.Spread.Sheets.Style();
      style.name = "taskList";
      style.textDecoration = GC.Spread.Sheets.TextDecorationType.lineThrough;
      context.addNamedStyle(style);
}
options.ranges.forEach(({ col, row }) => {
      const range = new GC.Spread.Sheets.Range(row, -1, 1, -1);
      const value = GC.Spread.Sheets.CalcEngine.rangeToFormula(new GC.Spread.Sheets.Range(row, col, 1,1), 0, 0, GC.Spread.Sheets.CalcEngine.RangeReferenceRelative.allRelative);
      cfs.addFormulaRule(`=$${ value }=TRUE`, style, [range]);
});