IWbsField.ConditionalFormula Property
A formula is always prepended with the '=' string. If there is no conditional formatting, this property is set to an empty string.
Formulas are in the format of the en-US culture (with . and , as decimal and list separators). In UI, a user works with formulas in the current culture with localized list and decimal separators.
The value contains 0 or more formatting condition rules.
The rules are separated with the '|$|' delimiter. Each rule consists of a formula, 11 optional formatting parameters and one optional filter. Each of these parts are separated with the '|~|' delimiter. The complete format of the rule parts is as follows:
- Formula
- FontBold
- FontItalic
- FontUnderline
- FontStrikeThrough
- FontColor
- BackColor
- PatternColor
- ColorIndex
- BackColorIndex
- PatternColorIndex
- PatternStyle
- Filter containing B, M, T flags for Branches, Minutes and Totals. An empty string means all BMT flags.
The boolean parts have values 0 for False, otherwise True. The RGB color parts contain a number created with Color.ToArgb method.
Values -3 are used when a value was not explicitly set.
The RGB colors are used in almost all cases. In this case, the indexed color values are -3. The indexed colors are only used for AUTOMATIC (-1) and NONE (-2).