spreadsheet icon indicating copy to clipboard operation
spreadsheet copied to clipboard

Exception when using table filter

Open carlmcc opened this issue 8 years ago • 4 comments

I get an exception trying to use a table filter in the attached "Parameter_File2_s1" workbook:

  • select the "entity" tab
  • in column A, click on the "Parameter" drop-down to trigger this error java.lang.IllegalArgumentException: lastRow < firstRow || lastCol < firstCol at org.apache.poi.ss.util.CellRangeAddress.&lt;init&gt;(CellRangeAddress.java:52) at com.vaadin.addon.spreadsheet.SpreadsheetFilterTable.&lt;init&gt;(SpreadsheetFilterTable.java:94) at com.vaadin.addon.spreadsheet.SpreadsheetFilterTable.&lt;init&gt;(SpreadsheetFilterTable.java:70) at com.vaadin.addon.spreadsheet.SpreadsheetFactory.loadSheetTables(SpreadsheetFactory.java:455) at com.vaadin.addon.spreadsheet.SpreadsheetFactory.reloadSpreadsheetData(SpreadsheetFactory.java:410) at com.vaadin.addon.spreadsheet.Spreadsheet.setActiveSheetWithPOIIndex(Spreadsheet.java:1301) at com.vaadin.addon.spreadsheet.Spreadsheet.setActiveSheetIndex(Spreadsheet.java:1275) at com.vaadin.addon.spreadsheet.Spreadsheet.onSheetSelected(Spreadsheet.java:1323)

carlmcc avatar Nov 03 '17 22:11 carlmcc

Thank you for the report. What version are you using?

johannesh2 avatar Nov 04 '17 10:11 johannesh2

Sorry, I forgot to say I'm using 1.4.0.alpha2, but the same error also occurs with the on-line spreadsheet demo, which is currently at 2.1.0.alpha1.

carlmcc avatar Nov 04 '17 18:11 carlmcc

@carlmcc, it looks like something happened and the attachment is missing, can you add it again?

alvarezguille avatar Nov 06 '17 11:11 alvarezguille

Here it is:

Parameter_File2_s1.xlsx

carlmcc avatar Nov 06 '17 16:11 carlmcc