Why does following formula not parse with the wincalcmanager
"(508767.36+0)/(100-(0+0+0+0+2.8421709430404E-14+7+2.8421709430404E-14))*5"
this is the code used:
calculationformula="(508767.36+0)/(100-(0+0+0+0+2.8421709430404E-14+7+2.8421709430404E-14))*5"
Infragistics.Win.CalcEngine.UltraCalcValue val = mgr.Calculate(calculationformula);
result=double.Parse(val.Value.ToString());
Error returned is "Formula syntax error. Unable to compile the formula: Unexpected token \"E\" <TEXT>, expected \")\", on line: 1 column: 44"
If i can not used exponent notation, how do i transform that to something the calculation manager understands?
Hi,
I think the problem may be the scientific notation. Try re-writing the formula without using scientific notation.
Sandip