GrapeCity.Documents.Excel.IScenario.Show

Show Method

Show()

Applies the values saved in this scenario to the worksheet.

The affected cells are the changing cells of the scenario. This method replaces the current values in those cells with the values stored in the scenario. Formulas that reference the changing cells are recalculated when the calculation engine is enabled.

Declaration

void Show()

Sub Show()

Examples

worksheet.Range["B2:B3"].Value = new object[,] {{10}, {20}};
IScenario scenario = worksheet.Scenarios.Add("Sales Plan", worksheet.Range["B2:B3"], null);
worksheet.Range["B2:B3"].Value = new object[,] {{30}, {40}};
scenario.Show();