Really slow performance - 45,000 cells

[swallace21]

WRITE CELLS w/Styles: ~10 seconds loop through hashMap: Cell newCell = spreadsheet.createCell(row, col, cellValue); newCell.setCellStyle(someStyle);

AUTO-FIT COLUMNS: ~6 seconds for 14 columns spreadsheet.autofitColumn(colNumber);

[WoozyG]

A big part of the performance is Apache POI. I improved it by an order of magnitude in POI 3.16, which should work with an unmodified Vaadin-Spreadsheet release (I see the POM still says 3.15). POI 3.17 has several important bug fixes, but is not binary compatible due to removed deprecated methods.

[swallace21]

Thanks! I ended move back to the grid. The performance boosts and inline editor proved to be overall better user experience.