Export (0) Print
Expand All
Expand Minimize
1 out of 1 rated this helpful - Rate this topic

2.4.29 BRAI

Office

The BRAI record specifies a reference to data in a sheet (1) that is used by a part of a series, legend entry, trendline or error bars.


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

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 (3) 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 (1) is a category (3) name, series name or bubble size that was automatically generated.

0x01

The data source (1) is the text or value as specified by the formula field.

0x02

The data source (1) is the value from a range of cells in a sheet (1) 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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.