I am using the formula builder in run time. Everything works fine when I assign a non blank formula. In the formula builder dialog, if I clear the formula for any column, that blank formula never gets affected and the column still shows the old values. Although formula is blank !!
I tried many things but nothing seems to be working. Any ideas on how can I clear the old values?
There's no such thing as a Formula column with no formula. If the column has no formula, then it's not a formula column, it's just a regular column. Obviously, the grid can't just assume that every column without a formula should be blank - this would mean that no colmun in the grid could ever display any data without a formula.
As a workaround, i am already clearing the value of each cell by looping thru all the rows. However, i do not really like this solution.
Assigning empty string to the formula of the column is not clearing the cell contents. I think this should be treated as a bug, because formula column having no formula should have empty values.
A Blank formula is the same as no formula, which means the grid just displays the value of the cell without calculating anything. I think you would have to manually clear the contents of the cells by setting the Value of each cell to null. Or maybe change the formula so that it return null or an empty string.