2.5.98.40 PtgExp
The PtgExp structure specifies that the containing Rgce (section 2.5.98.88) is part of an array formula (section 2.2.2) or shared formula and specifies the row of the cell in which that formula exists. The column (1) of the cell in which that formula exists is specified by the col field of the corresponding PtgExtraCol (section 2.5.98.42) in the RgbExtra (section 2.5.98.87) of the containing Rgce.
There MUST be a PtgExtraCol in the RgbExtra corresponding to this PtgExp.
There MUST be a BrtFmlaString (section 2.4.680), BrtFmlaNum (section 2.4.679), BrtFmlaBool (section 2.4.677), or BrtFmlaError (section 2.4.678) record specifying the array formula or shared formula. That record MUST have a cell.col field equal to the col field of the PtgExtraCol, and MUST be between a BrtRowHdr (section 2.4.761) record with a rw field equal to the row field and the next BrtRowHdr or BrtEndSheetData (section 2.4.550) record, as defined in the Worksheet part ABNF (section 2.1.7.62) and Macro Sheet (section 2.1.7.32) part ABNF.
The array formula or shared formula that the containing Rgce is a part of MUST be followed by either a BrtShrFmla (section 2.4.785) record or a BrtArrFmla (section 2.4.6) record.
If the record specifying the array formula or shared formula is followed by a BrtShrFmla, the row of this PtgExp MUST be greater than or equal to the value of the rfx.rwFirst field and less than or equal to the value of the rfx.rwLast field of the BrtShrFmla, and the col field of the PtgExtraCol MUST be greater than or equal to the value of the rfx.colFirst field and less than or equal to the value of the rfx.colLast field of the BrtShrFmla.
If the record specifying the array formula or shared formula is followed by a BrtArrFmla, the row of this PtgExp MUST be equal to the value of the rfx.rwFirst field of the BrtArrFmla, and the col field of the PtgExtraCol MUST be equal to the value of the rfx.colFirst field of the BrtArrFmla.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
ptg |
A |
row |
|||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
ptg (7 bits): Reserved. This value MUST be 0x01.
A - reserved0 (1 bit): This value MUST be 0, and MUST be ignored.
row (4 bytes): An Rw (section 2.5.126) structure that specifies a zero-based index of the row of the cell on the current sheet that contains the array formula or shared formula that the containing Rgce is a part of. Its value MUST be less than or equal to 1048575.