Skip to main content

Таблица DocumentAPI.DataBarConditionalFormatOperator

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

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


 DataBarConditionalFormatOperator(ConditionalFormatDataBarParams params)

Пример​


 local sheet = document:getBlocks():getTable(0)
 local rules = sheet:getConditionalFormatRules()
 
 local cellRange = sheet:getCellRange("G2:G12")
 local cellRangePosition = cellRange:getTableRange()
 
 local value1 = DocumentAPI.ConditionalFormatValueObject()
 value1:setType(DocumentAPI.ConditionalFormatValueObjectType_AutoMin)
 value1:setValue("0")
 local value2 = DocumentAPI.ConditionalFormatValueObject()
 value2:setType(DocumentAPI.ConditionalFormatValueObjectType_AutoMax)
 value2:setValue("0")
 
 local dataBarParams = DocumentAPI.ConditionalFormatDataBarParams(value1, value2)
 dataBarParams.barFill = DocumentAPI.Color(DocumentAPI.ColorRGBA(0, 255, 0, 100))
 dataBarParams.borderColor = DocumentAPI.Color(DocumentAPI.ColorRGBA(0, 255, 0, 255))
 dataBarParams.negativeBarFill = DocumentAPI.Color(DocumentAPI.ColorRGBA(255, 0, 0, 100))
 dataBarParams.negativeBorderColor = DocumentAPI.Color(DocumentAPI.ColorRGBA(255, 0, 0, 255))
 dataBarParams.axisPosition = DocumentAPI.ConditionalFormatDataBarAxisPosition_Middle
 dataBarParams.axisColor = DocumentAPI.Color(DocumentAPI.ColorRGBA(0, 0, 255, 100))
 dataBarParams.fillType = DocumentAPI.ConditionalFormatDataBarFillType_Gradient
 dataBarParams.direction = DocumentAPI.ConditionalFormatDataBarDirection_LeftToRight
 dataBarParams.isValueVisible = true
 
 local dataBarOperator = DocumentAPI.createDataBarConditionalFormatOperator(dataBarParams)
 
 local dataBarRule = DocumentAPI.ConditionalFormatRule()
 dataBarRule:setRange(cellRangePosition)
 dataBarRule:setOperator(dataBarOperator)
 rules:addRule(dataBarRule)