Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
80
Excel like formula in grid cell.
posted

Hi,

I am trying to evaluate if there is any sample of knowledge base around this. We are looking to implement a feature that allows the user to add a column at runtime. Within this column the user can specify a formula for each cell on the grid similar to excel.

Example - in the cell the user can specify "=sum(100 + 200)" and the cell value should be "300".

Similarly, the user should be able to base a calculation on the basis of other cells in that grid. Example - "=sum((Column 1 - Row 5) + (Column 2 - Row 1)).

Thanks in advance, any pointers will be helpful.