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.
ADAdministrator Syncfusion Team April 13, 2004 02:47 PM
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;
ADAdministrator Syncfusion Team April 14, 2004 07:53 AM
I''m using 220.127.116.11 of the Suite.
I''ll try your suggestion and let you know the outcome.
PLPaul LaudemanApril 14, 2004 01:06 PM
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.
ADAdministrator Syncfusion Team April 14, 2004 01:52 PM
You should try the 18.104.22.168 code base. It may help in this problem.
If you can post a sample project showing the problem, I can try it here.