How can I define a function in Kendo UI Spreadsheet?

1 Answer 144 Views
Spreadsheet
Maria
Top achievements
Rank 1
Maria asked on 23 Oct 2023, 05:55 PM | edited on 24 Oct 2023, 07:36 AM

I have a project that uses Kendo UI for jQuery to work with spreadsheets. I want to recreate the project from scratch in Angular using the Spreadsheet component.

We have some custom functions to use in the spreadsheets. In jQuery, I am currently using `kendo.spreadsheet.defineFunction()` to define our custom functions and I would like to do the same in Angular. How can I do it? I tried to find some information in the documentation but I didn't succeed. 

1 Answer, 1 is accepted

Sort by
0
Martin Bechev
Telerik team
answered on 26 Oct 2023, 11:56 AM

Hi Maria,

I am not sure what is the desired outcome and where these custom-defined functions should be applied. We are still gathering feedback from customers to help us decide what to implement further in the Spreadsheet so any other details or requests will be appreciated.

Besides editing the properties that came with the SheetDescritpor, the developer can customize the properties that are exposed by the SpreadsheetWidget (which actually holds the core logic of the Spreadsheet).

Here is an example where the SpreadsheetWidget properties are logged inside the console and a sample code for disabling the sheet cells.

https://stackblitz.com/edit/angular-6wpguc

I am looking forward to your reply.

Regards,
Martin
Progress Telerik

Stay tuned by visiting our public roadmap and feedback portal pages! Or perhaps, if you are new to our Kendo family, check out our getting started resources
Maria
Top achievements
Rank 1
commented on 30 Oct 2023, 02:44 PM

Hi Martin, 

Thanks for your response!! I can access the component, indeed, but I don't get to achieve what I need, so my original question remains: how can I create a custom function using Angular components like you would do in Jquery (docs)?
Martin Bechev
Telerik team
commented on 02 Nov 2023, 09:07 AM

Hi Maria,

So far there is no built-in option to apply custom functions to the Kendo UI for Angular Spreadsheet.

I logged a feature request on your behalf about it in our Feedback Portal and added your vote. We will track the customer demand and consider adding it in the future based on the interest.

https://feedback.telerik.com/kendo-angular-ui/1629603-custom-functions-in-spreadsheet

 

Tags
Spreadsheet
Asked by
Maria
Top achievements
Rank 1
Answers by
Martin Bechev
Telerik team
Share this question
or