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

Formula in Virtual Grid

Thread ID:





80372 Apr 1,2009 10:17 AM UTC Apr 3,2009 04:31 PM UTC WinForms 1
Tags: GridControl
Administrator [Syncfusion]
Asked On April 1, 2009 10:17 AM UTC


I have virtual grid with 2 header rows and using formula cells in certain places on the grid.

While I have custom captions on both header rows and column headers - I'm looking to bring the grid into A,B,C 1,2,3 captions when user brought formula cell into edit mode and return back to "normal" labels once editing completed for whatever reason.

Also the other problem is that formula engine I guess using my second header row as 1st row, can it be changed or at least is there a possibility to start row labeling with 2?

Many thanks for your help.

Lingaraj S [Syncfusion]
Replied On April 3, 2009 04:31 PM UTC

Hi Eugene,

Thanks for your interest in Syncfusion product.

When the editing has been completed in the formula cell the save cell might not be called by the FormulaEngine. To avoid this issue we can force the cell to save by setting the property called ForceSaveCellInfo property.

Please refer the code below:

GridFormulaEngine engine = ((GridFormulaCellModel)gridControl1.Model.CellModels["FormulaCell"]).Engine;
engine.ForceSaveCellInfo = true;

The RowIndex or the ColIndex of a GridControl has been handled internally which cannot be changed.

Let me know if you have any queries.

Lingaraj S


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