Spreadsheet event on comment

[Janaki]

Hi ,

we have a requirement to disable comment option on click of few cells (which are disabled) or to show a toastr message on click of comment that user can't add comment on specific cell. Do you have any such feature or event to track this requirement ?

 

[Ivan Danchev]

Hello Janaki,

Currently, the cell comment functionality is not tied to the state of the cell, so at the moment the comment dialog will appear for both enabled and disabled cells.

We don't expose a suitable event that can be used to control that behavior. Consider logging this as a feature request in our Feedback Portal: https://feedback.telerik.com/kendo-jquery-ui If the community is interested in such an enhancement, we will consider implementing it.

Regards,
Ivan Danchev
Progress Telerik

[Janaki]

Submitted a request. Is there a way to dynamically hide and show comment button based on some condition ?

[Ivan Danchev]

Hi,

The Range object has a comment method, which allows setting or removing a comment (by passing null to the method): https://docs.telerik.com/kendo-ui/api/javascript/spreadsheet/range/methods/comment

You can use this method to show/remove a comment. Here's a dojo example showing the comment in A1 being removed in the click handler of a button: https://docs.telerik.com/kendo-ui/api/javascript/spreadsheet/range/methods/comment

Regards,
Ivan Danchev
Progress Telerik