Get started
Loading...
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.

Product icon
TUTORIAL

Vaadin lets you build secure, UX-first PWAs entirely in Java.
Free ebook & tutorial.

CssImport when using Component Exporter by Mikhail Shabarov, 1 month ago
Recent Posts
Vaadin Forum1. Vaadin Flow - Java

Vaadin Spreadsheet doesn't work with latest POI versions

Syam Pillai
5 years ago Aug 27, 2016 11:18am

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
5 years ago Aug 29, 2016 3:42am

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.