How can I define a function in Kendo UI Spreadsheet?

[Maria]

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. 

[Martin Bechev]

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

[Maria]

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]

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