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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Grid is not updating formula references on row insert

Thread ID:





115400 Jan 15,2014 05:12 PM UTC Jan 22,2014 03:56 AM UTC WinForms 1
Tags: GridControl
Asked On January 15, 2014 05:12 PM UTC

Working with syncfusion grid and need the formulas to update their reference on row insert. Followed solution suggested on forum in threads 107111, 68861 and 94721. In fact all of them suggest the same solution that appears to be pretty straight forward but unfortunately not working for me. I must be miossing something or doing a mistake. 
Here is my sample code:
GridFormulaEngine engine = ((GridFormulaCellModel)grid.CellModels["FormulaCell"]).Engine;
engine.FormulaCopyFlags |= GridFormulaCopyFlags.InsDelRangeReferencesUpdated;
engine.FormulaCopyFlags |= GridFormulaCopyFlags.NamedRangeReferencesUpdated;
grid.Model.Rows.InsertRange(12, 1);

Can somebody guide me where is the mistake?

Anish George [Syncfusion]
Replied On January 22, 2014 03:56 AM UTC

Hi Andria,


Thank you for using Syncfusion products.


We regret to let you know that we are unable to reproduce the scenario in which you are experiencing this problem. It would be helpful for us if you could provide us the reproducing sample so that we can find the root cause, why the sample is not running as expected.


Please let us know if you need any further assistance.





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