Platforms to show: All Mac Windows Linux Cross-Platform

XLConditionalFormatMBS class

// highlighting alternating rows
book.RgbMode = true

Var cFormat As XLConditionalFormatMBS = book.addConditionalFormat()
cFormat.FillPattern = cFormat.FillPatternSolid
cFormat.PatternBackgroundColor = book.PackColor(240, 240, 240)

Var cFormatting As XLConditionalFormattingMBS = sheet.addConditionalFormatting()
cFormatting.addRange(4, 20, 1, 10)
cFormatting.addRule(cFormatting.FormatTypeExpression, cFormat, "=MOD(ROW(),2)=0")

For row As Integer = 4 To 19
  For col As Integer = 1 To 9
    Call sheet.WriteNumber(row, col, row + col)
  Next
Next

• 16 properties
  • property Book as XLBookMBS
  • property BorderBottom as Integer
  • property BorderBottomColor as Integer
  • property BorderLeft as Integer
  • property BorderLeftColor as Integer
  • property BorderRight as Integer
  • property BorderRightColor as Integer
  • property BorderTop as Integer
  • property BorderTopColor as Integer
  • property CustomNumFormat as String
  • property FillPattern as Integer
  • property Font as XLFontMBS
  • property Handle as Integer
  • property NumFormat as Integer
  • property PatternBackgroundColor as Integer
  • property PatternForegroundColor as Integer
• 3 methods
  • method Constructor   Private
  • method SetBorder(style as Integer = 1)
  • method SetBorderColor(color as Integer)
• 69 constants

This class has no sub classes.

Blog Entries

• News from the MBS Xojo Plugins Version 24.2
• Conditional Formatting in Excel exports from Xojo
• MBS Xojo Plugins, version 24.2pr1

Release notes

• Version 24.2
  • Added XLConditionalFormattingMBS and XLConditionalFormatMBS classes.

Some methods using this class:

• XLBookMBS.AddConditionalFormat as XLConditionalFormatMBS
• XLConditionalFormattingMBS.AddAboveAverageRule(format as XLConditionalFormatMBS, aboveAverage as Boolean = true, equalAverage as Boolean = false, stdDev as Integer = 0, stopIfTrue as Boolean = false)
• XLConditionalFormattingMBS.AddOpNumRule(op as Integer, format as XLConditionalFormatMBS, value1 as double, value2 as double = 0.0, stopIfTrue as Boolean = false)
• XLConditionalFormattingMBS.AddOpStrRule(op as Integer, format as XLConditionalFormatMBS, value1 as String = "", value2 as String = "", stopIfTrue as Boolean = false)
• XLConditionalFormattingMBS.AddRule(FormatType as Integer, format as XLConditionalFormatMBS, value as String = "", stopIfTrue as Boolean = false)
• XLConditionalFormattingMBS.AddTimePeriodRule(format as XLConditionalFormatMBS, timePeriod as Integer, stopIfTrue as Boolean = false)
• XLConditionalFormattingMBS.AddTopRule(format as XLConditionalFormatMBS, value as Integer, bottom as Boolean = false, percent as Boolean = false, stopIfTrue as Boolean = false)

Some examples using this class:

• /XL/Conditional formatting

Some related classes:

• class XLBookMBS
• class XLConditionalFormattingMBS
• class XLFontMBS

The items on this page are in the following plugins: MBS XL Plugin.

XLBookMBS   -   XLConditionalFormattingMBS