2.4.246 ScenMan
The ScenMan record specifies the state of the Scenario Manager for the sheet.
This record also specifies the beginning of a collection of Scenario records as defined by the Worksheet Substream ABNF. The collection of Scenario records specifies individual scenarios.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
csct |
isctCur |
||||||||||||||||||||||||||||||
|
isctShown |
irefResult |
||||||||||||||||||||||||||||||
|
rgref (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
csct (2 bytes): A signed integer that specifies the total number of scenarios in the sheet. MUST be equal to the number of Scenario records in the Worksheet substream and MUST be greater than or equal to 0.
isctCur (2 bytes): A signed integer that specifies the zero-based index of the Scenario in this Worksheet substream that is currently selected in the Scenario Manager. If csct is greater than 0, then isctCur MUST be greater than or equal to –1 and MUST be less than the number of Scenario records in the Worksheet substream. The value -1 means that no scenario is currently selected.
isctShown (2 bytes): A signed integer that specifies the zero-based index of the Scenario in this Worksheet substream that specifies the scenario that is currently applied in the sheet associated with this record. If csct is greater than 0, then isctShown MUST be greater than or equal to –1 and MUST be less than the number of Scenario records in the Worksheet substream. The value –1 means that no scenario is currently shown.
irefResult (2 bytes): A signed integer that specifies the number of result cells that are referenced in the field rgref. MUST be greater than or equal to 0 and less than or equal to 32.
rgref (variable): An array of Ref8U structures. Each element specifies a range of cells in the current sheet. These cells contain the results that are to be compared across scenarios. Its count MUST be equal to irefResult.