Excel-like functions not present in Telerik

5 Answers 73 Views
Spreadsheet
Claudio
Top achievements
Rank 1
Iron
Iron
Claudio asked on 21 Feb 2022, 08:24 AM
Good morning,

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

Sort by
0
Eyup
Telerik team
answered on 23 Feb 2022, 09:44 AM

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/spreadsheet

And 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/.

0
Claudio
Top achievements
Rank 1
Iron
Iron
answered on 23 Feb 2022, 09:56 AM

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

0
Eyup
Telerik team
answered on 28 Feb 2022, 08:53 AM

Hi

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.



0
Claudio
Top achievements
Rank 1
Iron
Iron
answered on 28 Feb 2022, 09:13 AM

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.

 

0
Eyup
Telerik team
answered on 03 Mar 2022, 06:29 AM

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:

https://www.telerik.com/purchase/support-plans

Tags
Spreadsheet
Asked by
Claudio
Top achievements
Rank 1
Iron
Iron
Answers by
Eyup
Telerik team
Claudio
Top achievements
Rank 1
Iron
Iron
Share this question
or