CellContextMenu for KendoReact Spreadsheet

[Dhruv]

Hi, I checked that there is a cellContextMenu method for the Kendo jQuery Spreadsheet but I could not find a similar method for the react spreadsheet component. I want to create a context menu which opens up on right click done at the cell level. How to do so?

[Yanko]

Hi, Dhruv,

The required functionality is not available in the KendoReact Spreadsheet at the moment. We have a similar feature request in our feedback portal where you can vote and depending on the interest from clients we plan and implement the most popular requests:

• https://feedback.telerik.com/kendo-react-ui/1618150-kendoreact-spreadsheet-column-filters 

I understand your inquiry may not be exactly the same, but I can suggest adding more information about the described feature to the existing request by commenting on it. Therefore, this scenario will also be considered when this feature is implemented. 

Please let me know if I can provide further assistance on this matter.

Regards,
Yanko
Progress Telerik

[Dhruv]

Thanks for the reply, I am using React as frontend in my application and I want to display a spreadsheet which has custom commands in the cell level context menu. But as the KendoReact Spreadsheet component does not have this functionality, I will have to us the Spreadsheet component of Kendo for JQuery. I am trying to integrate that into my React component but am unable to do so. Can someone help me out with it, I need a React component which will have functionalities like this
https://docs.telerik.com/kendo-ui/api/javascript/ui/spreadsheet/methods/cellcontextmenu

[Yanko]

Hello, Dhruv,

Yes, you can integrate a Kendo UI for jQuery Spreadsheet in React. To achieve this you need to load the jQuery Spreadsheet widget inside an useEffect:

import '@progress/kendo-ui/esm/kendo.spreadsheet';
...

React.useEffect(() => {
    spreadsheet = $('#spreadsheet')
      .kendoSpreadsheet({
          ...
      })
      .data('kendoSpreadsheet');
 }, []);

Note that you need to add jQuery to your application inside the `index.js`:

import jquery from 'jquery';
window.$ = jquery;
window.jQuery = jquery;

For convenience, I prepared an example with a KendoUI for jQuery Spreadsheet that has a CellContextMenu and is integrated inside React:

• https://stackblitz.com/edit/react-2g22wy?file=src%2FApp.js 

Please try the above approach and let me know if more inquiries arise.

Regards,
Yanko
Progress Telerik