2.5.27 CFExNonCF12

Office

The CFExNonCF12 structure specifies properties that extend a conditional formatting rule that is specified by a CF record.


0


1


2


3


4


5


6


7


8


9

1
0


1


2


3


4


5


6


7


8


9

2
0


1


2


3


4


5


6


7


8


9

3
0


1

icf

cp

icfTemplate

ipriority

A

B

C

D

E

fHasDXF

dxf (variable)

...

cbTemplateParm

rgbTemplateParms (16 bytes)

...

...

...

icf (2 bytes): An unsigned integer that specifies a zero-based index of a CF record in the collection of CF records directly following the CondFmt record that is referenced by the parent CFEx record with the nID field.  The referenced CF specifies the conditional formatting rule to be extended.

cp (1 byte): An unsigned integer that specifies the type of comparison operation to use when the ct field of the CF record referenced by the icf field of this structure is equal to 0x01. MUST be zero when the ct field of the CF record is not equal to 1. SHOULD<154> be equal to the cp field in the referenced CF record.

In the following table, v represents the cell value, and v1 and v2 represent the results of evaluating the formulas specified by rgce1 and rgce2 fields of the referenced CF record specified by icf. The value of this field MUST be a value from the following table:

Value

Comparison Operation

0x00

No comparison

0x01

v2 is greater than or equal to v1, and v is greater than or equal to v1 and less than or equal to v2

–Or–

v1 is greater than v2, and v is greater than or equal to v2 and less than or equal to v1

0x02

v2 is greater than or equal to v1, and v is less than v1 or greater than v2

–Or–

v1 is greater than v2, and v is less than v2 or greater than v1

0x03

v is equal to v1

0x04

v is not equal to v1

0x05

v is greater than v1

0x06

v is less than v1

0x07

v is greater than or equal to v1

0x08

v is less than or equal to v1

icfTemplate (1 byte):  An unsigned integer that specifies the template from which the rule was created.  MUST be the least significant byte of one of the valid values specified for the icfTemplate field in the CF12 record.

ipriority (2 bytes):  An unsigned integer that specifies the priority of the rule.  Rules that apply to the same cell are evaluated in increasing order of ipriority. MUST be unique across all CF12 records and CFExNonCF12 structures in the worksheet substream.

A - fActive (1 bit): A bit that specifies whether the rule is active.  If set to zero, the rule will be ignored.

B - fStopIfTrue (1 bit): A bit that specifies whether, when a cell fulfills the condition corresponding to this rule, the lower priority conditional formatting rules that apply to this cell are evaluated. MUST be one of the following values:

Value

Meaning

0x0

Always evaluate lower priority conditional formatting rules that apply to this cell

0x1

If the cell fulfills the condition corresponding to this rule, do not evaluate lower priority conditional formatting rules that apply to this cell

C - reserved1 (1 bit): MUST be zero and MUST be ignored.

D - unused (1 bit): Undefined and MUST be ignored.

E - reserved2 (4 bits): MUST be zero and MUST be ignored.

fHasDXF (1 byte):  A Boolean (section 2.5.14) that specifies whether cell formatting data is part of this record extension.  MUST be a value from the following table:

Value

Meaning

0x00

No formatting data in this record extension.

0x01

Formatting data is part of this record extension.

dxf (variable): A DXFN12 structure that specifies the format to use for cells that satisfy the condition.  MUST NOT be present when fHasDXF is zero.

cbTemplateParm (1 byte): An unsigned integer that specifies the size of the rgbTemplateParms field in bytes.  MUST be equal to 16.

rgbTemplateParms (16 bytes): A CFExTemplateParams that specifies parameters for the rule specified by this structure. 

Show: