Export (0) Print
Expand All
Expand Minimize

2.4.56 CondFmt

Office

The CondFmt record specifies conditional formatting rules that are associated with a set of cells.

This record specifies the beginning of a collection of CF records as defined in the Worksheet SubstreamABNF. The collection of CF records specifies conditional formatting rules.


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

ccf

A

nID

refBound

...

sqref (variable)

...

ccf (2 bytes): An unsigned integer that specifies the count of CF records that follow this record. MUST be greater than or equal to 0x0001, and less than or equal to 0x0003.

A - fToughRecalc (1 bit): A bit that specifies that the appearance of the cell requires significant processing. This information can be used to optimize the redraw of conditional formatting when data values change.

For example, an application could determine that a conditional formatting rule that contains certain functions or a conditional formatting rule that takes more than a predetermined amount of time to calculate designates that the conditional formatting requires significant processing, and could set this bit to 1.

nID (15 bits): An unsigned integer that identifies this record. The CFEx record uses this identifier to specify which CondFmt it extends.

refBound (8 bytes): A Ref8U structure that specifies the bounds of the set of cells to which the conditional formatting rules apply. The set of cells that this field represents MUST include all of the cells represented by the sqref field.

sqref (variable): A SqRefU structure that specifies the cells to which the conditional formatting rules apply. sqref.cref MUST be greater than zero and less than or equal to 1026.

Show:
© 2014 Microsoft