GrapeCity.Documents.Excel.IScenario.ChangingCells

ChangingCells Property

ChangingCells

Gets a IRange object that represents the changing cells for the scenario.

Use the returned range to access the cells whose values are stored and applied by the scenario.

Declaration

IRange ChangingCells { get; }

ReadOnly Property ChangingCells As IRange

Examples

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