Hi, pradeep,

Thank you for the provided video. 

I completed the steps as instructed, and it appears that the current KendoReact Spreadsheet does not support retrieving data from one sheet to another. I also tested the Kendo UI for Angular Spreadsheet and observed the same behavior. I also attempted to achieve the desired functionality with custom logic, but based on the current component implementation, there doesn’t appear to be a reliable way to achieve this behavior.

I’ve converted this ticket into an official feature request on our public portal and added your vote for convenience. Please let me know in case further questions arise and I will gladly assist.

Regards,
Filip
Progress Telerik

Hello, pradeep,

I inspected and reviewed the provided screenshots in order, though I may not be fully certain about the exact issue being experienced. Based on what I can see, it appears that when switching to another sheet while entering a formula, the Spreadsheet stops the formula entry instead of generating a cross-sheet reference, resulting in the formula being treated as plain text rather than executing. Could you please confirm if this is accurate?

In case I have misunderstood the issue, can you please send me a video of the reproduction steps? This will enable me to better understand the faced scenario and investigate the root-cause further.

Regards,
Filip
Progress Telerik