2.4.227 BrtBeginSparklineGroup
The BrtBeginSparklineGroup record specifies sparkline group information and specifies the beginning of a collection of records and collections as defined by the Worksheet part ABNF (section 2.1.7.62). The collection of records specifies the properties for this sparkline group.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
FRTHeader (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
A |
B |
C |
D |
E |
F |
G |
H |
I |
J |
K |
L |
M |
N |
O |
brtcolorSeries |
||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
brtcolorNegative |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
brtcolorAxis |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
brtcolorMarkers |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
brtcolorFirst |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
brtcolorLast |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
brtcolorHigh |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
brtcolorLow |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
dManualMax |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
dManualMin |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
dLineWeight |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
isltype |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
FRTHeader (variable): An FRTHeader (section 2.5.61) that specifies the date range for the sparkline group.
The FRTHeader fields MUST have the values listed in the following table.
-
Field
Value
FRTHeader.fRef
0
FRTHeader.fSqref
0
FRTHeader.fFormulas
0 or 1
FRTHeader.fRelID
0
If FRTHeader.fFormulas equals 1, then cformula of the FRTHeader.rgFormulas MUST be equal to 1 and the formula of the single FRTFormula (section 2.5.59) comprising the array of the FRTHeader.rgFormulas MUST contain only one Ptg (section 2.5.98.16) structure, and that Ptg structure MUST be either PtgName (section 2.5.98.60), PtgNameX (section 2.5.98.61), PtgRef3d (section 2.5.98.69), or PtgArea3d (section 2.5.98.19). If the Ptg structure is a PtgRef3d or PtgArea3d, then the ixti of the PtgRef3d or PtgArea3d MUST specify an Xti (section 2.5.173) that MUST have firstSheet greater than or equal to zero, and MUST have lastSheet equal to firstSheet. If the Ptg structure is a PtgArea3d, then the area of the PtgArea3d MUST either have rowFirst equal to rowLast and columnFirst.fRwRel equal to columnLast.fRwRel, or columnFirst.col equal to columnLast.col and columnFirst.fColRel equal to columnLast.fColRel.
A - fDateAxis (1 bit): A bit that specifies whether this sparkline group uses a date axis.
-
Value of fDateAxis
Meaning
0
No date axis is specified for this sparkline group.
1
A date axis is specified by FRTHeader for this sparkline group.
B - fShowEmptyCellAsZero (2 bits): An unsigned integer that specifies how empty cells are plotted. This value MUST be a value from the following table.
-
Value of fShowEmptyCellAsZero
Meaning
0x0
Empty cells are plotted as zero.
0x1
Empty cells are not plotted.
0x2
Empty cells are plotted as interpolated.
C - fMarkers (1 bit): A bit that specifies whether data markers are displayed for each sparkline in this sparkline group.
D - fHigh (1 bit): A bit that specifies whether the data points with the highest value are formatted differently for each sparkline in this sparkline group.
E - fLow (1 bit): A bit that specifies whether the data points with the lowest value are formatted differently for each sparkline in this sparkline group.
F - fFirst (1 bit): A bit that specifies whether the first data point is formatted differently for each sparkline in this sparkline group.
G - fLast (1 bit): A bit that specifies whether the last data point is formatted differently for each sparkline in this sparkline group.
H - fNegative (1 bit): A bit that specifies whether the negative data points are formatted differently for each sparkline in this sparkline group.
I - fAxis (1 bit): A bit that specifies whether the horizontal axis is displayed for each sparkline in this sparkline group.
J - fDisplayHidden (1 bit): A bit that specifies whether data in hidden cells are plotted for the sparklines in this sparkline group.
K - fIndividualAutoMax (1 bit): A bit that specifies whether the vertical axis maximum for each sparkline in this sparkline group is calculated automatically such that the data point with the maximum value can be displayed in the plot area. This value MUST be 0 if fGroupAutoMax equals 1.
L - fIndividualAutoMin (1 bit): A bit that specifies whether the vertical axis minimum for each sparkline in this sparkline group is calculated automatically such that the data point with the minimum value can be displayed in the plot area. This value MUST be 0 if fGroupAutoMin equals 1.
M - fGroupAutoMax (1 bit): A bit that specifies whether the vertical axis maximum is shared across all sparklines in this sparkline group and is calculated automatically such that the data point with the maximum value can be displayed in the plot area. This value MUST be 0 if fIndividualAutoMax equals 1.
N - fGroupAutoMin (1 bit): A bit that specifies whether the vertical axis minimum is shared across all sparklines in this sparkline group and is calculated automatically such that the data point with the minimum value can be displayed in the plot area. This value MUST be 0 if fIndividualAutoMin equals 1.
O - fRTL (1 bit): A bit that specifies whether each sparkline in the sparkline group is displayed in a right-to-left manner.
brtcolorSeries (8 bytes): A BrtColor (section 2.4.334) that specifies the color for each sparkline in this sparkline group. The xColorType of this BrtColor MUST NOT equal 0x00.
brtcolorNegative (8 bytes): A BrtColor that specifies the color of the negative data points for each sparkline in this sparkline group. The xColorType of this BrtColor MUST NOT equal 0x00.
brtcolorAxis (8 bytes): A BrtColor that specifies the color of the horizontal axis for each sparkline in this sparkline group. The xColorType of this BrtColor MUST NOT equal 0x00.
brtcolorMarkers (8 bytes): A BrtColor that specifies the color of the data markers for each sparkline in this sparkline group. The xColorType of this BrtColor MUST NOT equal 0x00.
brtcolorFirst (8 bytes): A BrtColor that specifies the color of the first data point for each sparkline in this sparkline group. The xColorType of this BrtColor MUST NOT equal 0x00.
brtcolorLast (8 bytes): A BrtColor that specifies the color of the last data point for each sparkline in this sparkline group. The xColorType of this BrtColor MUST NOT equal 0x00.
brtcolorHigh (8 bytes): A BrtColor that specifies the color of the highest data point for each sparkline in this sparkline group. The xColorType of this BrtColor MUST NOT equal 0x00.
brtcolorLow (8 bytes): A BrtColor that specifies the color of the lowest data point for each sparkline in this sparkline group. The xColorType of this BrtColor MUST NOT equal 0x00.
dManualMax (8 bytes): An Xnum (section 2.5.172) that specifies the maximum for the vertical axis that is shared across all sparklines in this sparkline group. This value MUST be 0 if either fIndividualAutoMax or fGroupAutoMax equal 1.
dManualMin (8 bytes): An Xnum that specifies the minimum for the vertical axis that is shared across all sparklines in this sparkline group. This value MUST be 0 if either fIndividualAutoMin or fGroupAutoMin equal 1.
dLineWeight (8 bytes): An Xnum that specifies the line weight for each sparkline in the sparkline group, where the line weight is measured in points. This value MUST be greater than or equal to zero, and MUST be less than or equal to 1584.
isltype (4 bytes): An unsigned integer that specifies the type of the sparkline group. This value MUST be one of the following values.
-
Value of isltype
Meaning
0x00000000
Line sparklines
0x00000001
Column (2) sparklines
0x00000002
100% stacked column (2) sparklines