New Product Launch - BoldDesk !
Introducing help desk ticketing software.
New Product LaunchBoldDesk: Help desk ticketing software starts at $10 for 3 agents.
Try it for free.
GridFormulaEngine engine = ((GridFormulaCellModel)gridCashFlow.Model.CellModels["FormulaCell"]).Engine;
//name is the NamedRange name
//val is the NamedRange value
engine.AddNamedRange(name, val);
If the name is already present in the NamedRanges, you can change its value using
engine.NamedRanges[name] = val;
If it is a new namedrange that has not been registered yet, you would use code like:
GridFormulaEngine engine = ((GridFormulaCellModel)gridCashFlow.Model.CellModels["FormulaCell"]).Engine;
//name is the NamedRange name
//val is the NamedRange value
engine.AddNamedRange(name, val);
If the name is already present in the NamedRanges, you can change its value using
engine.NamedRanges[name] = val;