Класс DataBarConditionalFormatOperator

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

Конструктор

 DataBarConditionalFormatOperator(ConditionalFormatDataBarParams params)

Пример

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