Skip to main content

Таблица DocumentAPI.ConditionalFormatRule

Таблица ConditionalFormatRule представляет собой правило условного форматирования. Используется в методе ConditionalFormatTableRules:addRule().

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


 ConditionalFormatRule()
 ConditionalFormatRule(ConditionalFormatOperator conditionalFormatOperator, ConditionalFormatCellStyle cellStyle, CellRangePosition cellRangePosition, bool stopCalculations)
 ConditionalFormatRule(ConditionalFormatOperator conditionalFormatOperator, ConditionalFormatCellStyle cellStyle, CellRangePositions cellRangePositions, bool stopCalculations)

Пример​


 local sheet = document:getBlocks():getTable(0)
 local rules = sheet:getConditionalFormatRules()
 
 local cellRange = sheet:getCellRange("F2:F12")
 local cellRangePosition = cellRange:getTableRange()
 
 local aboveStyle = DocumentAPI.ConditionalFormatCellStyle()
 local cellProperties = DocumentAPI.CellProperties()
 cellProperties.fill = DocumentAPI.Fill(DocumentAPI.Color(DocumentAPI.ColorRGBA(0, 255, 0, 150)))
 aboveStyle.cellProperties = cellProperties
 
 local aboveOperator = DocumentAPI.createAboveAverageConditionalFormatOperator(DocumentAPI.ConditionalFormatAboveAverageCondition_Above)
 
 local aboveRule = DocumentAPI.ConditionalFormatRule(aboveOperator, aboveStyle, cellRangePosition, false)
 rules:addRule(aboveRule)