I have an ultrawebgrid with both bound and unbound columns.

I want to input data on the cell of unbound column and set other cell's values on the same unbound column based on some condition like formula behavior in Excel.

But whenever I do a postback, all the value on unbound columns are cleared even I add column and cell like below:

UltraGridColumn v_colQ1 = new UltraGridColumn(true);

v_colQ1.Header.Caption = "Q1-Actual";
 v_colQ1.Key = "Q1-Actual";
UltraWebGrid1.DisplayLayout.Bands[0].Columns.Add(v_colQ1);

UltraGridCell v_Cell = new UltraGridCell(true);

e.Row.Cells.Remove(e.Row.Cells.FromKey("Q1-Actual"));

v_Cell.Key = "Q1-Actual";
v_Cell.Value = v_rptItemEntity.RptItemValue;
e.Row.Cells.Add(v_Cell);