2.4.29 BRAI
The BRAI record specifies a reference to data in a sheet that is used by a part of a series, legend entry, trendline or error bars.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
id |
rt |
A |
reserved |
||||||||||||||||||||||||||||
|
ifmt |
formula (variable) |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
id (1 byte): An unsigned integer that specifies the part of the series, trendline, or error bars the referenced data specifies. MUST be a value from the following table:
-
Value
Meaning
0x00
Referenced data specifies the series, legend entry, or trendline name. Error bars name MUST be empty.
0x01
Referenced data specifies the values or horizontal values on bubble and scatter chart groups of the series and error bars.
0x02
Referenced data specifies the categories (2) or vertical values on bubble and scatter chart groups of the series and error bars.
0x03
Referenced data specifies the bubble size values of the series.
rt (1 byte): An unsigned integer that specifies the type of data that is being referenced. MUST be a value from the following table:
-
Value
Meaning
0x00
The data source is a category (2) name, series name or bubble size that was automatically generated.
0x01
The data source is the text or value as specified by the formula field.
0x02
The data source is the value from a range of cells in a sheet specified by the formula field.
A - fUnlinkedIfmt (1 bit): A bit that specifies whether the part of the chart specified by the id field uses number formatting from the referenced data. MUST be a value from the following table:
-
Value
Meaning
0x0
The data uses the number formatting of the referenced data.
0x1
The data uses the custom number formatting specified in the ifmt field.
reserved (15 bits): MUST be zero, and MUST be ignored.
ifmt (2 bytes): An IFmt structure that specifies the number format to use for the data.
formula (variable): A ChartParsedFormula structure that specifies the formula (section 2.2.2) that specifies the reference.