Export (0) Print
Expand All
Expand Minimize

2.4.246 ScenMan

Office

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 SubstreamABNF. The collection of Scenario records specifies individual scenarios.


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

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.

Show:
© 2014 Microsoft