We are trying to implement a calculator type functionality with in a databoundgrid. We have a double column and all we wanted to is too add or subtract within the cell itsself. we need not hold the formula in the cell for future refernce.
we have A = 10 in a cell
we want to make A= 10+20 within the cell. we want to psot 10+20 value as it is an calculate the new value and update the cell. we are doing some accounting table and wanted to have a inplace update with + and - signs within cells.
any help in resolving this matter is appreciated.
So, you want to have a GridDataBoundGrid where if your user enters 10+20 in a cell, the cells shows 30 and 30 is saved into the datasource of the grid.
I think the simplest way to do this is to use Essential Calculate. You can create a CalcQuick object.
this.calculator = new Syncfusion.Calculate.CalcQuick();
Then handle the CurrentCellValidating event.