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

GridFormulaCopyFlags problem

Thread ID:





103822 Jun 4,2012 12:50 AM UTC Jun 18,2012 05:31 AM UTC WinForms 5
Tags: GridControl
Administrator [Syncfusion]
Asked On June 4, 2012 12:50 AM UTC

The following block of code, place in the "load" callback (or other initialization function), prevents inputting numbers in a grid
control and causes the error: "Object reference not set to an instance of an object.".

GridFormulaEngine engine = ((GridFormulaCellModel)grid.Model.CellModels["FormulaCell"]).Engine;

engine.FormulaCopyFlags |=


engine.FormulaCopyFlags |=


engine.FormulaCopyFlags |=


engine.FormulaCopyFlags |=


engine.FormulaCopyFlags |=



It appears that the engine.FormulaCopyFlags are set to null. Does anyone have suggestions on what I am doing wrong?

I have included the project in the attached .rar file. The bug is in the file GridEditor.

Administrator [Syncfusion]
Replied On June 4, 2012 12:51 AM UTC

Here is the .rar file.

Monte Carlo Estimator_c5ddc72b.rar

Jeya Preetha M [Syncfusion]
Replied On June 7, 2012 06:26 AM UTC

Hi Jan,

Thank you for interest in Syncfusion Products.

To perform copy/paste operation in the grid control, we have sample in our dash board.

Please refer the sample in the following link:

{Installed path}\Syncfusion\EssentialStudio\\Windows\Grid.Windows\Samples\2.0\MS Excel-Style Features\Grid Copy-Paste Demo

Please let me know if you have any concerns.


Jeya Preetha M

Administrator [Syncfusion]
Replied On June 8, 2012 12:37 PM UTC

Sorry, I obviously explained the problem poorly. The real problem is in adding a page to a tabcontrol containing grids on each page and having all the grids recognize the variables and user functions that are in use. I redid the example (see attached project). In the redone project, I tried to boil the problem down to the simplest form. If you run the example and the right-click on the tabcontrol and select "Add Page", the program throws an error saying that the new grid is not recognized. I think this is the real problem. (But I'm not an expert, so I may be wrong.) Any help will be appreciated.

Monte Carlo Estimator_37dcd82.rar

Administrator [Syncfusion]
Replied On June 8, 2012 01:44 PM UTC

I am apparently still describing the problem badly. In the example I just posted, the problem that arises has to do with a cross-sheet reference. I guess I am seeing it all as one big problem and not boiling it down correctly. I hope I didn't confuse things too much.
my appologies

Ragamathulla B [Syncfusion]
Replied On June 18, 2012 05:31 AM UTC

Hi Jan,

I am afraid that I was not able to reproduce the issue. Also I have created a simple sample to test this issue and it is available in the following link.


Please have a look at the preceding sample and if still the issue exists, could you please try reproducing it in the above sample so that we could sort out the cause of the issue and provide you a solution?

Ragamathullah B.


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