2.5.17 CFTextOper

The CFTextOper enumeration specifies the valid types of text comparisons used in conditional formatting rules. The value of the cell is compared against the string stored in the strParam field of the BrtBeginCFRule (section 2.4.23) or BrtBeginCFRule14 (section 2.4.24) record.

The value of this enumeration MUST be a value from the following table.

Name

Value

Meaning

CF_TEXTOPER_CONTAINS

0x00000000

This rule evaluates to True (1) when the cell contains the specified text.

CF_TEXTOPER_NOTCONTAINS

0x00000001

This rule evaluates to True (1) when the cell does not contain the specified text.

CF_TEXTOPER_BEGINSWITH

0x00000002

This rule evaluates to True (1) when the cell's text begins with the specified text.

CF_TEXTOPER_ENDSWITH

0x00000003

This rule evaluates to True (1) when the cell's text does not begin with the specified text.