Hi,
I have following code to set a formula expression for a column in my code.
FormulaColumn fc = new FormulaColumn("TEST1", "([COLUMN (1)] - [COLUMN (2)]) / [COLUMN (3)]");
The ultrawingrid shows up with "#REF!" in the column 'TEST1'. It seems if there are any parentheses
in formula field names in the expression then it does not work. I tried with column names which did not have parentheses then it works good.
In above code COLUMN (1), COLUMN (2) and COLUMN (3) , all have parentheses in the column names.
Can anybody suggest how to escape the parentheses in the formula expression ?
Thanks
I tried this out and it worked fine for me. What version of the controls are you using?
Hi Mike,
We are using following version of the control:
NetAdvantage for Win Client 2009 Vol. 1 - Windows Forms Source Code (Release Build Version 9.1.1000)
We did many testing the only parentheses in which works in the formula expression is of type {} .We would like () to work.