AddCondition

AddCondition(FormatConditionType, OperatorType, string, string)

Adds a formatting condition.

public int AddCondition(FormatConditionType type, OperatorType operatorType, string formula1, 
    string formula2)
Parameter Type Description
type FormatConditionType of conditional formatting. It could be one of the members of FormatConditionType.
operatorType OperatorType The comparison OperatorType. It could be one of the members of OperatorType.
formula1 String The value or expression associated with conditional formatting. If the input value starts with ‘=’, then it will be taken as formula. Otherwise it will be taken as plain value(text, number, bool). For text value that starts with ‘=’, user may input it as formula in format: “="=…"”.
formula2 String The value or expression associated with conditional formatting. The input format is same with formula1

Return Value

Formatting condition object index;

See Also


AddCondition(FormatConditionType)

Add a format condition.

public int AddCondition(FormatConditionType type)
Parameter Type Description
type FormatConditionType Format condition type.

Return Value

Formatting condition object index;

See Also