Change in kendo sheet content

3 Answers 45 Views
Spreadsheet
Saby
Top achievements
Rank 1
Veteran
Iron
Saby asked on 25 Oct 2021, 01:11 PM
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

3 Answers, 1 is accepted

Sort by
0
Martin
Telerik team
answered on 28 Oct 2021, 11:30 AM

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

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

Saby
Top achievements
Rank 1
Veteran
Iron
commented on 28 Oct 2021, 02:38 PM | edited

Hi Martin, thanks for your answer.
0
Saby
Top achievements
Rank 1
Veteran
Iron
answered on 28 Oct 2021, 02:39 PM
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
Top achievements
Rank 1
Veteran
Iron
commented on 28 Oct 2021, 10:36 PM

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

 

 
Neli
Telerik team
commented on 02 Nov 2021, 11:58 AM

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
Top achievements
Rank 1
Veteran
Iron
commented on 10 Nov 2021, 07:52 PM

Hi Neli,  is there any way that you can tell if a filter has been applied?
Neli
Telerik team
commented on 11 Nov 2021, 11:12 AM

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

0
Saby
Top achievements
Rank 1
Veteran
Iron
answered on 08 Nov 2021, 10:22 PM

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
Telerik team
commented on 11 Nov 2021, 11:08 AM

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
Top achievements
Rank 1
Veteran
Iron
commented on 11 Nov 2021, 07:22 PM

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
Telerik team
commented on 16 Nov 2021, 09:06 AM

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

Tags
Spreadsheet
Asked by
Saby
Top achievements
Rank 1
Veteran
Iron
Answers by
Martin
Telerik team
Saby
Top achievements
Rank 1
Veteran
Iron
Share this question
or