https://issues.apache.org/bugzilla/show_bug.cgi?id=45322
Summary: POI reportSheet.autoSizeColumn
java.lang.ArrayIndexOutOfBoundsException: -1
HSSFDataFormat.getFormat
Product: POI
Version: unspecified
Platform: PC
OS/Version: Windows XP
Status: NEW
Keywords: ErrorMessage
Severity: minor
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Attached the ExcelReportGenerator.java
1) If I do NOT call the autoSizeColumn method, then I am able to get the excel
report. Attached the excel report without calling autoSizeColumn method.
2) When I call the autoSizeColumn method, I get the below output and exception.
formatFontCount =5
columnValueStyles.length =25
column Count = 25
called autoSizeColumn for the following values of i
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
java.lang.ArrayIndexOutOfBoundsException: -1
at java.util.Vector.get(Vector.java:712)
at
org.apache.poi.hssf.usermodel.HSSFDataFormat.getFormat(HSSFDataFormat.java:266)
at
org.apache.poi.hssf.usermodel.HSSFSheet.autoSizeColumn(HSSFSheet.java:1815)
at
com.jbhunt.report.generator.ExcelReportGenerator.setAutoColumnWidths(ExcelReportGenerator.java:457)
at
com.jbhunt.report.generator.ExcelReportGenerator.generateHSSFWorkbook(ExcelReportGenerator.java:110)
at
com.jbhunt.report.generator.ExcelReportGenerator.generateReport(ExcelReportGenerator.java:65)
at
com.jbhunt.report.service.GenerateReportSvc.generateReport(GenerateReportSvc.java:59)
at
com.jbhunt.pace.biz.reports.ReportHandler.getReportUsingCustomJavaAPI(ReportHandler.java:635)
at
com.jbhunt.pace.biz.reports.ejb.ReportsBean.getReportUsingCustomJavaAPI(ReportsBean.java:338)
at
com.jbhunt.pace.biz.reports.test.CustomJavaReportTest.main(CustomJavaReportTest.java:29)
14540 [main] ERROR service.GenerateReportSvc - Error in generate Excel report.
com.jbhunt.report.exception.ReportServiceException: Error in generate Excel
report.
at
com.jbhunt.report.generator.ExcelReportGenerator.generateReport(ExcelReportGenerator.java:70)
at
com.jbhunt.report.service.GenerateReportSvc.generateReport(GenerateReportSvc.java:59)
at
com.jbhunt.pace.biz.reports.ReportHandler.getReportUsingCustomJavaAPI(ReportHandler.java:635)
at
com.jbhunt.pace.biz.reports.ejb.ReportsBean.getReportUsingCustomJavaAPI(ReportsBean.java:338)
at
com.jbhunt.pace.biz.reports.test.CustomJavaReportTest.main(CustomJavaReportTest.java:29)
Caused by: java.lang.ArrayIndexOutOfBoundsException: -1
at java.util.Vector.get(Vector.java:712)
at
org.apache.poi.hssf.usermodel.HSSFDataFormat.getFormat(HSSFDataFormat.java:266)
at
org.apache.poi.hssf.usermodel.HSSFSheet.autoSizeColumn(HSSFSheet.java:1815)
at
com.jbhunt.report.generator.ExcelReportGenerator.setAutoColumnWidths(ExcelReportGenerator.java:457)
at
com.jbhunt.report.generator.ExcelReportGenerator.generateHSSFWorkbook(ExcelReportGenerator.java:110)
at
com.jbhunt.report.generator.ExcelReportGenerator.generateReport(ExcelReportGenerator.java:65)
... 4 more
com.jbhunt.report.exception.ReportServiceException: Error in generate Excel
report.
at
com.jbhunt.report.generator.ExcelReportGenerator.generateReport(ExcelReportGenerator.java:70)
at
com.jbhunt.report.service.GenerateReportSvc.generateReport(GenerateReportSvc.java:59)
at
com.jbhunt.pace.biz.reports.ReportHandler.getReportUsingCustomJavaAPI(ReportHandler.java:635)
at
com.jbhunt.pace.biz.reports.ejb.ReportsBean.getReportUsingCustomJavaAPI(ReportsBean.java:338)
at
com.jbhunt.pace.biz.reports.test.CustomJavaReportTest.main(CustomJavaReportTest.java:29)
Caused by: java.lang.ArrayIndexOutOfBoundsException: -1
at java.util.Vector.get(Vector.java:712)
at
org.apache.poi.hssf.usermodel.HSSFDataFormat.getFormat(HSSFDataFormat.java:266)
at
org.apache.poi.hssf.usermodel.HSSFSheet.autoSizeColumn(HSSFSheet.java:1815)
at
com.jbhunt.report.generator.ExcelReportGenerator.setAutoColumnWidths(ExcelReportGenerator.java:457)
at
com.jbhunt.report.generator.ExcelReportGenerator.generateHSSFWorkbook(ExcelReportGenerator.java:110)
at
com.jbhunt.report.generator.ExcelReportGenerator.generateReport(ExcelReportGenerator.java:65)
... 4 more
Exception in thread "main" com.jbhunt.report.exception.ReportServiceException:
Error in generate Excel report.
at
com.jbhunt.report.service.GenerateReportSvc.generateReport(GenerateReportSvc.java:65)
at
com.jbhunt.pace.biz.reports.ReportHandler.getReportUsingCustomJavaAPI(ReportHandler.java:635)
at
com.jbhunt.pace.biz.reports.ejb.ReportsBean.getReportUsingCustomJavaAPI(ReportsBean.java:338)
at
com.jbhunt.pace.biz.reports.test.CustomJavaReportTest.main(CustomJavaReportTest.java:29)
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
