Skip to main content

Класс ConditionalFormatRule

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

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


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

Пример​


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