GridControl FormulaCell not calculating

Hello, I have a Formula cell defined on my grid that is not calculating. The formula is a simple sum of cells, nothing complex. My GridControl object is setup so that I can dynamically add new rows to the GridControl as needed for input by the user. If the user adds a new row, the FormulaCell in the current location is cleared out and a new FormulaCell is added in the row below. When I add the new formula cell and then input numbers, the numbers are not summed. Additionally, I was able to call the model.RefreshRange to get the cell formula to work again, but the grid would crash and my cpu usage would rocket to 100% if I scrolled the GridControl. Help!! Thanks, -Paul

What version are you using? There is code in 2030 that can help reduce the 100% utilization problem. You say you clear the formula cell and then add it again. You might also try clearing the dependency tables too. GridFormulaEngine engine = ((GridFormulaCellModel) grid.CellModels["FormulaCell"]).Engine; engine.DependentCells.Clear(); engine.DependentFormulaCells.Clear();

I''m using 1.6.2.4 of the Suite. I''ll try your suggestion and let you know the outcome. Thanks, -Paul

No luck Clay. I tried your code and the formula still wouldn''t work. If I coupled your code with the call to RefreshRange, I got the runaway cpu usage issue. -Paul

You should try the 2.0.3.0 code base. It may help in this problem. If you can post a sample project showing the problem, I can try it here.