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.
Hi Dan,
The UltraCalcManager component allows you to apply formula in the grid, but you can only apply a formula to an entire column (or summary). There is no support for formulas on a single cell.
There is a sample included with NetAdvantage called "Formula Builder Runtime" which shows you how you can allow the user to display the FormulaBuilder at run-time and apply that formula to an entire column.
Thanks Mike.
Is there a plan or idea to implement this feature in future?
Hello,
I am just checking about the progress of this issue. Let me know If you need my further assistance on this issue?
Thank you for using Infragistics Components.