Skip to main content

Таблица DocumentAPI.ColorScaleConditionalFormatOperator

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

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


 ColorScaleConditionalFormatOperator(ConditionalFormatColorScaleEntries entries)

Пример​


 local sheet = document:getBlocks():getTable(0)
 local rules = sheet:getConditionalFormatRules()
 
 local entries = DocumentAPI.ConditionalFormatColorScaleEntries()
 local value1 = DocumentAPI.ConditionalFormatValueObject(DocumentAPI.ConditionalFormatValueObjectType_Min, "0", false)
 local entry1 = DocumentAPI.ConditionalFormatColorScaleEntry(value1, DocumentAPI.Color(DocumentAPI.ColorRGBA(255, 0, 0, 150)))
 entries:addEntry(entry1)
 local value2 = DocumentAPI.ConditionalFormatValueObject(DocumentAPI.ConditionalFormatValueObjectType_Percent, "50", false)
 local entry2 = DocumentAPI.ConditionalFormatColorScaleEntry(value2, DocumentAPI.Color(DocumentAPI.ColorRGBA(255, 220, 56, 150)))
 entries:addEntry(entry2)
 local value3 = DocumentAPI.ConditionalFormatValueObject(DocumentAPI.ConditionalFormatValueObjectType_Max, "0", false)
 local entry3 = DocumentAPI.ConditionalFormatColorScaleEntry(value3, DocumentAPI.Color(DocumentAPI.ColorRGBA(0, 255, 0, 150)))
 entries:addEntry(entry3)
 
 local cellRange = sheet:getCellRange("G2:G12")
 local cellRangePosition = cellRange:getTableRange()
 
 local colorScaleOperator = DocumentAPI.createColorScaleConditionalFormatOperator(entries)
 
 local colorScaleRule = DocumentAPI.ConditionalFormatRule()
 colorScaleRule:setRange(cellRangePosition)
 colorScaleRule:setOperator(colorScaleOperator)
 rules:addRule(colorScaleRule)