AD
Administrator
Syncfusion Team
April 27, 2007 04:22 PM UTC
There is a second collection in the grid that you need to clear. But in addition, you also need to clear your cache of GridFormulaTag objects. If you are using formulacells in a GridDataBoundGrid, then you need to be caching the FormulaTags in Model.SaveCellInfo and providing them back in Model.QueryCellInfo. Exactly, how you clear your formulatag cache would depend upon what you are using to hold them. In addition, as part of clearing your formulatag cache, you would also want to clear whatever formulas are in your grid.DataSource. If you do not, they will just reappear.
engine.DependentCells.Clear();
engine.DependentFormulaCells.Clear();
ClearFormulaTagCacheAndFormulasFromDataSource();
grid.Refresh();