NamedRange

[Tito Toro]

How do I set the value programtically for a named range?

Thanks

[Administrator]

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;

            

[Saravanan]

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;

Test

            

[Sindhu Nagarajan]

Hi Saravanan, 

  

Thanks for the update. 

  

We will wait till we hear from you. Please let us know if you need further assistance. 

  

Regards,  

Sindhu