we would need to implement the following excel-like functions on a Telerik spreadsheet:
- Average/Sum/Count of the selected cells. (sum-avarage-count.jpg)
- copy-paste in the cells below with respect to a cell selected by double clicking in the lower-right corner. (copy-paste double click 1/2.jpg)
Are there any options in Telerik to replicate these features?
Kind regards,
5 Answers, 1 is accepted
Hello Claudio,
Thank you for writing to us.
You can achieve this requirement using the following approach:
.Formula("SUM(F3:F14)")
Here you can check the full sample live:
https://demos.telerik.com/aspnet-mvc/spreadsheetAnd I believe it will be helpful if you have all the Functions and Formulas available at your hand. They are listed here:
https://docs.telerik.com/kendo-ui/controls/data-management/spreadsheet/end-user/list-of-formulas
Regards,
Eyup
Progress Telerik
Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.
Hello Eyup
I try to explain better.
I do not need to insert a SUM Formula in a cell but I have to replicate the Excel behavior that, if I select two or more cell, it calculates the SUM, the AVARAGE and the COUNT of the selection and put result on the sheetbar (as highlighted in the attached image sum-avarage-count.jpg).
Kind regards
Hi Claudio,
Thank you for the providing the additional details.
Before continuing to discuss the technical situation, I would like to clarify something first. It seems that you are using Telerik UI for MVC and Kendo.dll assembly, but I couldn't find active license for this account regarding this product.
Could you first contact your License Representative of your company and ensure that they add your account as a Licensed Developer? Or they can also contact our Sales department for additional inquiries.
Once this is done and an active license is attached to your account, I can then fully test the mentioned behavior and suggest the proper steps to handle the technical issues.
Hello,
thks for your feedback.
Our license has expired actually, this is the reason why we're using the Forum and we've not opened a support ticket.
Thank you for the clarification.
Feel free to use our forum system where you can find answers to various technical inquiries. Also, our community members can help you with specific questions.
In addition, we can help you with official support tickets if you renew your license. This will allow you to send us sample project archives which we can modify and then send back to you: