2.5.22 CFDatabar

Office

The CFDatabar structure specifies the parameters of a conditional formatting rule that uses data bar formatting.


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

unused

reserved1

A

B

reserved2

iPercentMin

iPercentMax

color (16 bytes)

...

...

...

cfvoDB1 (variable)

...

cfvoDB2 (variable)

...

unused (2 bytes): Undefined and MUST be ignored.

reserved1 (1 byte): MUST be zero and MUST be ignored.

A - fRightToLeft (1 bit): A bit that specifies whether the data bars are drawn starting from the right of the cell. MUST be a value from the following table:

Value

Meaning

0x0

Data bars are drawn starting from the left of the cell

0x1

Data bars are drawn starting from the right of the cell

B - fShowValue (1 bit): A bit that specifies whether the numerical value of the cell appears in the cell along with the data bar.

reserved2 (6 bits): MUST be zero and MUST be ignored.

iPercentMin (1 byte): An unsigned integer that specifies the length of a data bar, as a percentage of the cell width, that is applied to cells with values equal to the CFVO value specified by cfvoDB1. MUST be less than or equal to 100.

iPercentMax (1 byte):  An unsigned integer that specifies the length of a data bar, as a percentage of the cell width, that is applied to cells with values equal to the CFVO value specified by cfvoDB2. MUST be greater than iPercentMin and less than or equal to 100.

color (16 bytes): A CFColor structure that specifies the color of the data bar.

cfvoDB1 (variable): A CFVO that specifies the maximum cell value that will be represented with a minimum width data bar.  All cell values that are less than or equal to the CFVO value specified by this field are represented with a data bar of iPercentMin percent of the cell width.

cfvoDB2 (variable): A CFVO that specifies the minimum cell value that will be represented with a maximum width data bar. All cell values that are greater than or equal to the CFVO value specified by this field are represented with a data bar of iPercentMax percent of the cell width.

Show: