2.4.273.69 SXAddl_SXCSXCondFmt_SXDSXCondFmt

The SXAddl_SXCSXCondFmt_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.