Hello! Do notrecalculateformulavtable.Supposethere are6columns and rows. 6=columnformula,whichputsthe valueof 2and 4. The default valuesin the cellsare.But whenI changea figure, saya cellline2, the6cellandisthe sumof the default value
MGMohanraj Gunasekaran Syncfusion Team February 23, 2017 02:21 PM UTC
Thanks for using Syncfusion products.
We have tried to reproduce your scenario using below attached sample. But we are unable to reproduce your scenario at our end. By default, if you have used the cell reference in formula cell for calculations, the changes will be automatically reflected while changing that reference cell value. Please provide your code part to reproduce your scenario. If we have missed anything in our sample, please modify the sample to reproduce your scenario. It will be helpful to provide the solution at the earliest.
If you want to force a range of cells to recalculate or refresh the formula cell, you can use the ReCalculateRange or RefreshRange method in CurrentCellEditingComplete event. Please refer to the below code example,
GridFormulaCellModel model = (GridFormulaCellModel)this.gridControl1.CellModels["FormulaCell"];