Hi,
I have looked at the documentation but couldn't find an example so I'm not sure if this feature is supported or not in DataGrid component. I want to create a DataGrid as in the picture below.As you can see, summary row is always visible. Sum and Average are calculated based on the selected cells. Does the DataGrid provide such functionality?Thanks in advance.
Hello Adem,
I’m glad I was able to help.
Thank you for choosing Infragistics!
Regards, Ivan Kitanov
Thank you Ivan. This should work for me.
This functionality is not supported out of the box, however it could be achieved with the help of the SelectedItemsChanged event of the grid and few labels that could be used for showing the summaries of the cell range. I have prepared a small sample to demonstrate this, after the user selects new cell/cell range the labels get updated to reflect the new sum, count, average etc.
Please note that this approach should be adapted to your application and it should be viewed as something that needs to be implemented on application level. If you would like to see this feature implemented out of the box, then I recommend you submitting a 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.
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.
You can find the sample attached below, please let me know if you have any questions or concerns.
CustonSummariesCellRange.zip