We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

GridControl FormulaCell not calculating

Thread ID:





12844 Apr 13,2004 02:52 PM Apr 14,2004 02:52 PM Windows Forms 4
Tags: GridControl
Paul Laudeman
Asked On April 13, 2004 02:52 PM

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

Administrator [Syncfusion]
Replied On April 13, 2004 03: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; engine.DependentCells.Clear(); engine.DependentFormulaCells.Clear();

Administrator [Syncfusion]
Replied On April 14, 2004 08:53 AM

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

Paul Laudeman
Replied On April 14, 2004 02: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. -Paul

Administrator [Syncfusion]
Replied On April 14, 2004 02:52 PM

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


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.