Skip to main content

Таблица DocumentAPI.IconSetConditionalFormatOperator

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

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


 IconSetConditionalFormatOperator(ConditionalFormatIconSetEntries entries, bool isValueShown)

Пример​


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