Skip to main content

Класс IconSetConditionalFormatOperator

Класс IconSetConditionalFormatOperator представляет собой оператор, который содержит настройки применения форматирования для правила "Значки". Используется при создании правила условного форматирования (ConditionalFormatRule).

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


 public IconSetConditionalFormatOperator(ConditionalFormatIconSetEntries entries, bool isValueShown)

Пример​


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

 var entries = new ConditionalFormatIconSetEntries();
 var value1 = new ConditionalFormatValueObject(ConditionalFormatValueObjectType.Percent, "0", false);
 var entry1 = new ConditionalFormatIconSetEntry(value1, ConditionalFormatIconSet.ThreeArrows, 0);
 entries.addEntry(entry1);
 var value2 = new ConditionalFormatValueObject(ConditionalFormatValueObjectType.Percent, "33", false);
 var entry2 = new ConditionalFormatIconSetEntry(value2, ConditionalFormatIconSet.ThreeArrows, 1);
 entries.addEntry(entry2);
 var value3 = new ConditionalFormatValueObject(ConditionalFormatValueObjectType.Percent, "67", false);
 var entry3 = new ConditionalFormatIconSetEntry(value3, ConditionalFormatIconSet.ThreeArrows, 2);
 entries.addEntry(entry3);

 var iconSetOperator = DocumentAPI.createIconSetConditionalFormatOperator(entries, true);

 CellRange cellRange = sheet.getCellRange("G2:G12");
 var cellRangePosition = cellRange.getTableRange();

 var iconSetRule = new ConditionalFormatRule();
 iconSetRule.setOperator(iconSetOperator);
 iconSetRule.setRange(cellRangePosition);
 rules.addRule(iconSetRule);