2.4.273.69 SXAddl_SXCSXCondFmt_SXDSXCondFmt

Office

The SXAddl_SXCXCondFmt_SXDSXCondFmt record specifies information for a PivotTable conditional formatting rule, for a SXCSXCondFmt class.


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

hdr

...

reserved

...

sxcondfmtScope

sxcondfmtType

ipriority

csxrule

hdr (6 bytes):  An SXAddlHdr structure. The value of hdr.sxc MUST equal 0x1B and the value of hdr.sxd MUST equal 0x35.

reserved (6 bytes): MUST be zero, and MUST be ignored.

sxcondfmtScope (4 bytes): An unsigned integer that specifies the scope of the PivotTable view conditional formatting. MUST be a value from the following table:

Name

Value

Description

SXCONDFMTSELECTIONSCOPE

0x00000000

This conditional formatting is applied to the cells, as specified by the SXCSXrule classes contained in this SXCSXCondFmt class.

SXCONDFMTDATASCOPE

0x00000001

This conditional formatting is applied to all cells that display values for the data item, as specified by the SXCSXrule class contained in this SXCSXCondFmt class.

SXCONDFMTFIELDSCOPE

0x00000002

This conditional formatting is applied to all cells that display values for the pivot field intersections, as specified by the SXCSXrule class contained in this SXCSXCondFmt class.

The value MUST be SXCONDFMTFIELDSCOPE if the value of sxcondfmtType is SXCONDFMTTOP10R or SXCONDFMTTOP10C.

If the value is SXCONDFMTDATASCOPE or SXCONDFMTFIELDSCOPE, there MUST be only one SXCSXrule class contained in this SXCSXCondFmt class.

sxcondfmtType (4 bytes): An unsigned integer that specifies the type of this PivotTable view conditional formatting. MUST be one of the values from following table:

Name

Value

Description

SXCONDFMTTOP10NIL

0x00000000

Top N or Bottom N conditional formatting is not evaluated.

SXCONDFMTTOP10A

0x00000001

Top N or Bottom N conditional formatting is evaluated across the entire scope range.

SXCONDFMTTOP10R

0x00000002

Top N or Bottom N conditional formatting is evaluated for each row.

SXCONDFMTTOP10C

0x00000003

Top N or Bottom N conditional formatting is evaluated for each column.

The value MUST be equal to SXCONDFMTTOP10NIL or SXCONDFMTTOP10A if the value of sxcondfmtScope is SXCONDFMTSELECTIONSCOPE or SXCONDFMTDATASCOPE.

ipriority (4 bytes): An unsigned integer that specifies the priority of the PivotTable view conditional formatting. It is used to locate the conditional formatting rule by matching the ipriority field of either CF12 or the rgbContent field which is a CFExNonCF12 structure in CFEx. MUST be greater than or equal to 1.

csxrule (4 bytes): An unsigned integer that specifies the number of SXCSXrule classes contained in this SXCSXCondFmt class. The SXCSXrule classes specify the area that the conditional formatting is applied to.

Show: