2.4.245 BrtBeginSXEdit
The BrtBeginSXEdit record specifies the user input, related to PivotTable What-if Analysis (section 2.2.5.3.10), in a single cell of the PivotTable data area (section 2.2.5.3.8.1.4), and specifies the beginning of a collection of records and collections as defined by the PivotTable (section 2.1.7.40) part ABNF. The collection of records specifies a collection of MDX unique names that identifies the value in the OLAP source data (section 2.2.5.2.1), and specifies a PivotTable rule (section 2.2.5.3.9) that can be used to identify the cell in the PivotTable data area (section 2.2.5.3.8.1.4).
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
FRTHeader (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
sxet |
xnum (optional) |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
datetime (optional) |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
st (variable) |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
f (optional) |
err (optional) |
||||||||||||||||||||||||||||||
FRTHeader (variable): An optional FRTHeader (section 2.5.61) that specifies the future record (section 2.1.6) information for this record.
-
This field exists if and only if the size of this record is greater than 4 bytes. The FRTHeader fields in the following table MUST be equal to their respective values in the table:
-
Field
Value
fRef
0
fSqref
0
fFormula
0 or 1
fRelID
0
-
If FRTHeader.rgFormulas exists, FRTHeader.rgFormulas.cformula MUST be equal to 0x00000001 and the reserved field of the FRTFormula (section 2.5.59) structure in the first element of the array FRTHeader.rgFormulas.array MUST be equal to 0x00000002.
-
The length of FRTHeader.blob MUST be zero.
sxet (1 byte): An SXET (section 2.5.147) that specifies the value type of the user input in the PivotTable data area. MUST be equal to SXET_FMLA if and only if FRTHeader.fFormula is equal to 1. If the record size is less than 4, sxet MUST be equal to SXET_BOOL or SXET_ERROR. If the record size is greater than 4, sxet MUST be equal to SXET_NUM, SXET_DATETIME or SXET_FMLA.
xnum (8 bytes): An Xnum (section 2.5.172) that specifies the numerical value that replaces the original cell value in PivotTable data area by user input. This value MUST exist if and only if sxet is equal to SXET_NUM.
datetime (8 bytes): An PCDIDateTime (section 2.5.101) that specifies a date-time value that replaces the original cell value in PivotTable data area by user input. This value MUST exist if and only if sxet is equal to SXET_DATETIME.
st (variable): An XLWideString (section 2.5.169) that specifies a string value that replaces the original cell value in PivotTable data area by user input. This value MUST exist if and only if sxet is equal to SXET_STRING (section 2.5.147). The length of the string MUST be greater than 0 and MUST be less than 32,768 characters.
f (1 byte): A Boolean (section 2.5.98.3) that specifies a Boolean value that replaces the original cell value in PivotTable data area by user input. This value MUST exist if and only if sxet is equal to SXET_BOOL.
err (1 byte): A BErr (section 2.5.98.2) that specifies an error that replaces the original cell value in PivotTable data area by user input. This value MUST exist if and only if sxet is equal to SXET_ERROR.