Hello Srinivas,

Thanks for provided details, but for such kind scenario this is absolutly expected behavior. You apply a Formula to the "Items" column, by this way you change (modify) the data in the current cell in that column and apply again formula and so on .... That`s why you get circular reference error.

I`m not familar with your scenario and final goal, but maybe you could try to use additional Unbound Column. Also if you need to validate your data, you could try to implement UltraValidator.

Please let me know if you have any further questions.

Regards

Hi,

Thanks for your help.

I am using version 11.1.20111.2090. You are writing the formula in column 2. But my case is to write the formula in column 0 itself while column 1 in some other grid loaded on the same form. Follow the steps to reproduce the error.

Step 1 : Create a form and add two wingrids and name as ultragrid1 and ultragrid2

Step 2 : Add a column named "Items" in ultragrid1 and add rows with data {Apple,Mango,Grapes}.  This is just an example my original grid will have lot of other information

Step 3 : Add two columns named "Items" and "Price" in ultragrid2.

Step 4 : Write the formula for column "Items" in ultragrid2 as IF([Items]=[/ultragrid1/Items(*)],[Items],'Error')

Step 5 : Add a row or bind with some data in datatable , you can come across the error of Circular reference for the column "items".

The objective is to validate the data entered in grid ( "ultragrid2") for column ("Items") against the data present in grid ("ultragrid1").

I can't use the dropdown list because i have huge number of rows from 50000 to million.

I can provide a sample application if you are not able to reproduce the error.

Thanks,

Srinivas