Change in kendo sheet content

[Saby]

Good morning, I have seen the "Change" event, but it detects even when a cell is clicked. What I would like to know is if there is an event that detects when there is a change in content, add data and delete it, make merge, change color, etc.
Thank you for your attention

[Martin]

Hello, Saby,

When you simply click on a cell, the select event is triggered. The change event is triggered when you blur the selected cell and its content is changed. Feel free to check that out in our Events demo. Currently there are no specific events when merging and changing a color.

Let me know if you have any further questions.

Regards,
Martin
Progress Telerik

[Saby]

Hi Martin, thanks for your answer.

[Saby]

Hi Martin, thanks for your answer.
Could you tell me how to work or create an event for merging and color change? I need to be able to recognize all the changes that can be made to a sheet.
I apreciate it

[Saby]

Hi Martin, an additional question: For the format changes (attached in the image), which event can work?

 

 

[Neli]

Hi Saby,

I am afraid that currently, the Spreadsheet API does not provide a suitable event for detecting changes in the color or other styles in the cells. 

There is such a Feature Request for this functionality on our Feedback portal. Below you will find a link to the issue.

- https://feedback.telerik.com/kendo-jquery-ui/1426457-spreadsheet-style-change-event

I would encourage you to cast a vote for the request.

Regards,

Neli

[Saby]

Hi Neli,  is there any way that you can tell if a filter has been applied?

[Neli]

You could try to subscribe to the render event of the widget. In the event handler, you could check for example the filtered rows:

 function onRender(e) {
      var sheet = e.sender.activeSheet();
      var filteredRows = sheet._filteredRows
}

I hope this helps.

Regards,

Neli

[Saby]

Hi Neli, a question please: 

If I have an empty cell and I apply a -all filter, it is generating an error like the one I show in the attached file. How could I control that? Thanks

[Neli]

Could you please provide more details about the steps that need to be followed in order to replicate the described issue? I tried to reproduce the issue in the Dojo from the provided image but to no avail. When I try to filter by applying a filter on empty cells, no error is thrown on my side.

Looking forward to your reply.

 

[Saby]

The error occurs when applying the filter on an empty cell and selecting the All. Even if the filter is applied to a single cell, with data, the same error appears:

1.- Select cell.

2.- Apply filter

3.- Open filter options and select All

 

[Neli]

There is such a known issue that has been fixed with the 2021 R3 release. 

- https://github.com/telerik/kendo-ui-core/issues/5279

I would suggest you upgrade to the latest version.

Regards,

Neli