Important Notice - Forums is archived
To simplify things and help our users to be more productive, we have archived the current forum and focus our efforts on helping developers on Stack Overflow. You can post new questions on Stack Overflow or join our Discord channel.

Vaadin lets you build secure, UX-first PWAs entirely in Java.
Free ebook & tutorial.
Vaadin Spreadsheet doesn't work with latest POI versions
In the latest POI versions, method org.apache.poi.ss.usermodel.Workbook.getNumCellStyles() returns 'int' instead of 'short'. So, if anyone tries to use spreadsheet add-on with latest POI versions, it won't work.
One will get a runtime error as follows:
java.lang.NoSuchMethodError: org.apache.poi.ss.usermodel.Workbook.getNumCellStyles()S
com.vaadin.addon.spreadsheet.SpreadsheetStyleFactory.reloadActiveSheetColumnRowStyles(SpreadsheetStyleFactory.java:222)
com.vaadin.addon.spreadsheet.Spreadsheet.reloadActiveSheetData(Spreadsheet.java:2715)
com.vaadin.addon.spreadsheet.Spreadsheet.setInternalWorkbook(Spreadsheet.java:2630)
com.vaadin.addon.spreadsheet.SpreadsheetFactory.reloadSpreadsheetComponent(SpreadsheetFactory.java:271)
com.vaadin.addon.spreadsheet.SpreadsheetFactory.reloadSpreadsheetComponent(SpreadsheetFactory.java:245)
com.vaadin.addon.spreadsheet.Spreadsheet.<init>(Spreadsheet.java:449)
Syam Pillai: In the latest POI versions, method org.apache.poi.ss.usermodel.Workbook.getNumCellStyles() returns 'int' instead of 'short'. So, if anyone tries to use spreadsheet add-on with latest POI versions, it won't work.
One will get a runtime error as follows:
java.lang.NoSuchMethodError: org.apache.poi.ss.usermodel.Workbook.getNumCellStyles()S com.vaadin.addon.spreadsheet.SpreadsheetStyleFactory.reloadActiveSheetColumnRowStyles(SpreadsheetStyleFactory.java:222) com.vaadin.addon.spreadsheet.Spreadsheet.reloadActiveSheetData(Spreadsheet.java:2715) com.vaadin.addon.spreadsheet.Spreadsheet.setInternalWorkbook(Spreadsheet.java:2630) com.vaadin.addon.spreadsheet.SpreadsheetFactory.reloadSpreadsheetComponent(SpreadsheetFactory.java:271) com.vaadin.addon.spreadsheet.SpreadsheetFactory.reloadSpreadsheetComponent(SpreadsheetFactory.java:245) com.vaadin.addon.spreadsheet.Spreadsheet.<init>(Spreadsheet.java:449)
SInce this change in POI library breaks binary compatibility with older verions, a recomplipation is required for all the projects that use POI library to work.