Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

2.4.234 BrtBeginSXEdit

Office

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).


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

FRTHeader (variable)

...

sxet

xnum (optional)

...

...

datetime (optional)

...

...

st (variable)

...

f (optional)

err (optional)

FRTHeader (variable): An optional FRTHeader (section 2.5.60) 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.58) 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.146) 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.171) 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.100) 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.168) 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.146). 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.97.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.97.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.

Show:
© 2015 Microsoft