Grid Formula using a program variable

[Rob Grunkemeyer]

I am trying to use a formula cell but want to reference a variable from my program is there a way to do this?

sample would be
int total = 100;

style.CellType = "FormulaCell";
style.CellValue = "=(A0+B0)/100";

But I really want to pass in total in the formula to replace the literal 100.

[Administrator]

Once the variable has been assigned a value, you can use:

style.CellValue = string.Format("=(A0+B0)/{0}", myVariable);

Then anytime myVariable changes, you would also have to reassign the formula.