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. Image for the cookie policy date
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

GridControl FormulaCell not calculating

Thread ID:





12844 Apr 13,2004 06:52 PM UTC Apr 14,2004 06:52 PM UTC WinForms 4
Tags: GridControl
Paul Laudeman
Asked On April 13, 2004 06:52 PM UTC

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 07:47 PM UTC

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 12:53 PM UTC

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 06:06 PM UTC

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 06:52 PM UTC

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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon 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.Close Icon

Live Chat Icon For mobile
Live Chat Icon