Skip to main content

Класс IconSetConditionalFormatOperator

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

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


 IconSetConditionalFormatOperator(ConditionalFormatIconSetEntries entries, bool isValueShown)

Пример​


 sheet = document.getBlocks().getTable(0)
 rules = sheet.getConditionalFormatRules()
 
 entries = myOfficeSDK.ConditionalFormatIconSetEntries()
 value1 = myOfficeSDK.ConditionalFormatValueObject(myOfficeSDK.ConditionalFormatValueObjectType_Percent, "0", False)
 entry1 = myOfficeSDK.ConditionalFormatIconSetEntry(value1, myOfficeSDK.ConditionalFormatIconSet_ThreeArrows, 0)
 entries.addEntry(entry1)
 value2 = myOfficeSDK.ConditionalFormatValueObject(myOfficeSDK.ConditionalFormatValueObjectType_Percent, "33", False)
 entry2 = myOfficeSDK.ConditionalFormatIconSetEntry(value2, myOfficeSDK.ConditionalFormatIconSet_ThreeArrows, 1)
 entries.addEntry(entry2)
 value3 = myOfficeSDK.ConditionalFormatValueObject(myOfficeSDK.ConditionalFormatValueObjectType_Percent, "67", False)
 entry3 = myOfficeSDK.ConditionalFormatIconSetEntry(value3, myOfficeSDK.ConditionalFormatIconSet_ThreeArrows, 2)
 entries.addEntry(entry3)
 
 iconSetOperator = myOfficeSDK.createIconSetConditionalFormatOperator(entries, True)
 
 cellRange = sheet.getCellRange("G2:G12")
 cellRangePosition = cellRange.getTableRange()
 
 iconSetRule = myOfficeSDK.ConditionalFormatRule()
 iconSetRule.setOperator(iconSetOperator)
 iconSetRule.setRange(cellRangePosition)
 rules.addRule(iconSetRule)