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

problem with setting up multiple grid application

Thread ID:





101620 Nov 8,2011 08:20 PM UTC Nov 11,2011 11:58 AM UTC WinForms 2
Tags: GridControl
Administrator [Syncfusion]
Asked On November 8, 2011 08:20 PM UTC

I am building an app with numerous GridControls. Each is initialized with:

GridFormulaEngine engine = ((GridFormulaCellModel)gridName.Model.CellModels["FormulaCell"]).Engine;
engine.FormulaCopyFlags |= GridFormulaCopyFlags.ClipBoardText;
engine.FormulaCopyFlags |= GridFormulaCopyFlags.ClipBoardFormula;
engine.FormulaCopyFlags |= GridFormulaCopyFlags.InsDelRangeReferencesUpdated;
engine.FormulaCopyFlags |= GridFormulaCopyFlags.ClipBoardReferencesAdjusted;
engine.FormulaCopyFlags |= GridFormulaCopyFlags.NamedRangeReferencesUpdated;

Everything works fine with cut/paste and calculation/formula support working as long as I am operating within each grid separately. However, as soon as I add the lines:

int sheetFamilyID = GridFormulaEngine.CreateSheetFamilyID();
GridFormulaEngine.RegisterGridAsSheet("grid1", grid1.Model, sheetFamilyID);
GridFormulaEngine.RegisterGridAsSheet("grid2", grid2.Model, sheetFamilyID);

The program crashes with the following message:

"Object reference not set to an instance of an object."

in the line:

engine.FormulaCopyFlags |= GridFormulaCopyFlags.ClipBoardText;

for one of the grids.

Has anyone run into this problem and know how I can fix it?

Administrator [Syncfusion]
Replied On November 10, 2011 03:21 PM UTC

I stripped the app down to a single grid and no functionality. I started testing at each step of development. Occurence of the "object reference not set to an instance of an object" error begins as soon as I change the value of the CellType parameter for the Standard Cells in the BaseStylesMap from "TextBox" to "FormulaCell". Is this a bug in Syncfusion's libraries? For those using new versions, I am using version of the libraries.

Asarudheen S [Syncfusion]
Replied On November 11, 2011 11:58 AM UTC

Hi Jan,

Thank you for your interest in Syncfusion products.

I am afraid that I was not able to reproduce the issue. Could you please share us simple sample to demonstrate the issue so that we could sort out the cause of the issue and provide you a solution?

Appreciate any additional information.



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