2.4.795 BrtSparkline
The BrtSparkline record specifies information for a single sparkline.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
FRTHeader (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
FRTHeader (variable): An FRTHeader (section 2.5.61) that specifies the future record (section 2.1.6) information for this record.
The FRTHeader fields MUST have the values listed in the following table:
-
Field
Value
FRTHeader.fRef
0
FRTHeader.fSqref
1
FRTHeader.fFormulas
0 or 1
FRTHeader.fRelID
0
The FRTHeader.rgSqrefs specifies the cell in which the sparkline is located. The csqref of FRTHeader.rgSqrefs MUST equal 1. The crfx of the sqrfx of the single FRTSqref (section 2.5.66) comprising the array of the FRTHeader.rgSqrefs MUST equal 1. The single UncheckedRfX (section 2.5.154) comprising the sqrfx of the single FRTSqref comprising the array of FRTHeader.rgSqrefs MUST have its rwFirst equal to its rwLast, and MUST have its colFirst equal to its colLast.
The FRTHeader.rgFormulas specifies the data range for this sparkline. If FRTHeader.fFormulas equals 1, then cformula of the FRTHeader.rgFormulas MUST equal 1 and the formula (section 2.2.2) 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 0, 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.