Formula in Virtual Grid

[Administrator]

Hello,

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]

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.

Regards,
Lingaraj S