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.
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.
Hello ,
After working on this and doing some research, “Formula Per cell” has been determined to be a new product idea. You can suggest new product ideas for future versions (or vote for existing ones) at <http://ideas.infragistics.com>.
There are many benefits to submitting a product idea:
- Direct communication with our product management team regarding your product idea.
- Notifications whenever new information regarding your idea becomes available.
- Ability to vote on your favorite product ideas to let us know which ones are the most important to you. You will have ten votes for this and can change which ideas you are voting for at any time.
- Allow you to shape the future of our products by requesting new controls and products altogether.
- You and other developers can discuss existing product ideas with members of our Product Management team.
Steps to create your idea:
1. Log into the Infragistics Product Idea site at http://ideas.infragistics.com (creating a new login if needed).
2. Navigate to the product / platform channel of your choice (e.g. WPF, Windows Forms, ASP.NET, HTML5 / Ignite UI, iOS / NucliOS, etc.)
3. Add your product idea and be sure to be specific and provide as much detail as possible.
Explain the context in which a feature would be used, why it is needed, why it can’t be accomplished today, and who would benefit from it. You can even add screenshots to build a stronger case. Remember that for your suggestion to be successful, you need other members of the community to vote for it. Be convincing!
[CASE: “Reference case [case number], FORUMS: “Include a link to this thread”] in your idea so product management will be able to look back at this case.
The Product Idea site puts you in the driver’s seat and allows you to track the progress of your ideas at any time, see how many votes it got, read comments from other developers in the community, and see if someone from the product team has additional questions for you.
Thanks Mike.
Is there a plan or idea to implement this feature in future?
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.