vaadin
Spreadsheet too slow when updating cell or deleting a row
When a sheet contains significantly number of rows (~4000), then updating even a single cell, or deleting the whole row, or column becomes really really slow.
I've attached file with some test data.
How to reproduce?
Plase go to Vaadin Spreadsheet Demo page and import file, then update particular cell, or even worse delete a row using context menu.
It takes significantly number of seconds to complete.
Test data: test.xlsx
This issue persists in Vaadin 24 Spreadsheet, where editing an xlsx document with more than 200 rows becomes extremely slow. For example, to delete a row in a document with 5000 rows took about 60 secs. It's a commercial component and needs to be a lot more responsive to be included in a business application.
