IMinutesField.ConditionalFormula Property

Property ConditionalFormula() As String

This language is not supported or no code example is available.

string ConditionalFormula {get; set;}

This language is not supported or no code example is available.

Property Value

The formula for conditional formatting of the field in a serialized string format. It contains formula and formatting rules.

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.

The value contains 0 or more formatting condition rules.

The rules are separated with the '|$|' delimiter. Each rule consists of a formula and 11 optional formatting parameters. 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

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).

.NET Framework