It would be great if you would allow loading single sheets instead of all the sheets every time. I receive data per sheet from my server.
Also the Spreadsheet fails to trigger events for:
Hi Abhijit,
Thank you for bringing these requests to our attention.
Currently, the Spreadsheet component loads all sheets simultaneously. For server-side scenarios that stream data per sheet, this would require buffering an entire workbook before rendering, which, in turn, can impact performance.
Adding support for single-sheet loading or lazy-loading would indeed be valuable, and I can confirm that this is a valid feature request that you can track here in the current Feedback Portal item.
Regarding your observation about missing events, I will share below a detailed breakdown of the mentioned scenarios.
In general, there is a formatChange event that fires for number format changes only (Currency, Percentage, Date, Time, etc.) via the Custom format... menu tool. However, this event does not fire for visual formatting changes like color, bold, italic, font, alignment, etc.
On that note, the change event should be emitted in the cases you mentioned, i.e., when rows or columns are added/deleted, when the color of the cell content is changed, etc., but currently it does not fire on these occasions. This is a known issue that has been logged as a bug report in our public GitHub repository. You can subscribe to this issue in order to track it and stay notified of the fix implementation progress:
I hope this helps.
Regards,
Zornitsa
Progress Telerik
Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.