Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
170
Parentheses in Formula column names not getting handled
posted

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