GrapeCity.Documents.Excel.IScenario

IScenario Interface

A scenario is a group of input values (called changing cells) that's named and saved.

public interface IScenario

Public Interface IScenario

Name	Description
ChangingCells	Returns a IRange object that represents the changing cells for the scenario. Read-only.
Comment	Returns or sets a String value that represents the comment associated with the scenario.
Hidden	Gets or sets a Boolean value that indicates if the scenario is hidden.
Index	Returns the index number of the object within the collection of similar objects.
Locked	Gets or sets a Boolean value that indicates if the scenario is locked.
Name	Gets or sets a String value representing the name of the object.
Values	Returns a list that contains the current values of the changing cells for the scenario. Read-only.

Name	Description
ChangeScenario(IRange, List<object>)	Changes the scenario to have a new set of changing cells and (optionally) scenario values.
Delete()	Deletes the object.
Show()	Shows the scenario by inserting its values on the worksheet. The affected cells are the changing cells of the scenario.