Can the comment widget from the Spreadsheet Toolbar be added to Context menu

1 Answer 22 Views
Spreadsheet Toolbar
Daniel
Top achievements
Rank 1
Iron
Daniel asked on 12 May 2022, 04:45 PM

I have three related questions:

Can spreadsheet cell comments from the tool bar be added to the context menu. 

If not, can a custom function be added to the context menu.

When you update a cell comment using the comment control from the menu bar, is there an event either at the cell level or comment dialog level that can be captured. From what I can see so far, not of the widgets on the menu bar have events that can be captured. Is that correct?

1 Answer, 1 is accepted

Sort by
1
Neli
Telerik team
answered on 17 May 2022, 01:49 PM

Hello Daniel,

I am afraid that the Spreadsheet Context Menu does not support an option for enabling the comments. To achieve such functionality you will need a custom implementation. You could take a look at the link from our forum below where adding a custom command to the Spreadsheet context menu is discussed:

https://www.telerik.com/forums/customize-context-meu

Regarding exposing an event for comments in the Spreadsheet there is a related feature request in our official Feedback Portal. Below you will find a link to the item. I would encourage you to cast a vote for the request.

- https://feedback.telerik.com/kendo-jquery-ui/1513138-add-a-support-for-spreadsheet-event-on-comment

I hope this helps. 

Regards,
Neli
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/.

Daniel
Top achievements
Rank 1
Iron
commented on 18 May 2022, 01:48 PM

I don't know if this is considered best practices but what I wanted from the context menu is to remove all options then have the context menu load my own custom dialog to manage comments. I was able to do this by removing all the list items from the  ul using jquery, then binding an event to the Context Menu "active" event to load the dialog. It actually worked well. So the ContextMenu has no buttons and loads my dialog on activation

 var list = $('.k-spreadsheet-cell-context-menu li:first-child').remove();
            var list = $('.k-spreadsheet-cell-context-menu li:first-child').remove();
            var list = $('.k-spreadsheet-cell-context-menu li:first-child').remove();
            var list = $('.k-spreadsheet-cell-context-menu li:first-child').remove();
            var list = $('.k-spreadsheet-cell-context-menu li:first-child').remove();

Then

 contextMenu.bind("activate", function (e) {

                    makeDialog();
                    openDialog();
            })
Neli
Telerik team
commented on 23 May 2022, 11:55 AM

Hi Daniel,

I am glad to hear you have managed to find a solution to the issue yourself. Thank you very much for sharing it here with the community. I am sure it will be helpful to the other users in the forum.

Regards,

Neli

Tags
Spreadsheet Toolbar
Asked by
Daniel
Top achievements
Rank 1
Iron
Answers by
Neli
Telerik team
Share this question
or