Класс ConditionalFormatRule

Класс ConditionalFormatRule представляет собой правило условного форматирования. Используется в методе ConditionalFormatTableRules.addRule().

Конструкторы

 public ConditionalFormatRule()
 public ConditionalFormatRule(ConditionalFormatOperator conditionalFormatOperator, ConditionalFormatCellStyle cellStyle, CellRangePosition cellRangePosition, bool stopCalculations)
 public ConditionalFormatRule(ConditionalFormatOperator conditionalFormatOperator, ConditionalFormatCellStyle cellStyle, CellRangePositions cellRangePositions, bool stopCalculations)

Пример

 Table sheet = document.getBlocks().getTable(0);
 ConditionalFormatTableRules rules = sheet.getConditionalFormatRules();

 CellRange cellRange = sheet.getCellRange("F2:F12");
 var cellRangePosition = cellRange.getTableRange();

 var aboveStyle = new ConditionalFormatCellStyle();
 var cellProperties = new CellProperties();
 cellProperties.fill = new Fill(new Color(new ColorRGBA(0, 255, 0, 150)));
 aboveStyle.cellProperties = cellProperties;

 var aboveOperator = DocumentAPI.createAboveAverageConditionalFormatOperator(ConditionalFormatAboveAverageCondition.Above);

 var aboveRule = new ConditionalFormatRule(aboveOperator, aboveStyle, cellRangePosition, false);
 rules.addRule(aboveRule);