2.4.287 SxFormat

The SxFormat record specifies the beginning of a collection of records as defined by the Worksheet substream ABNF. The collection of records specifies the differential formatting and specifies a PivotRule that specifies the area of the PivotTable view to apply the formatting to.


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

rlType

reserved

cbData

rlType (4 bits): A Boolean (section 2.5.14) that specifies whether formatting was applied to the PivotTable view. MUST be a value from the following table:

Value

Description

0x0000

The formatting was cleared.

0x0001

The formatting was applied.

reserved (12 bits): MUST be zero, and MUST be ignored

cbData (2 bytes): An unsigned integer that specifies the number of bytes in the SxDXF record that follows this record. MUST be zero if rlType is zero. If this field is zero then zero SxDXF records MUST follow this record.