Класс IconSetConditionalFormatOperator

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

Конструктор

 IconSetConditionalFormatOperator(ConditionalFormatIconSetEntries entries, bool isValueShown)

Пример

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

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

 auto iconSetOperator = createIconSetConditionalFormatOperator(entries, true);

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

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