DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://nagoya.apache.org/bugzilla/show_bug.cgi?id=26858>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=26858 Clone sheet with formulaes Summary: Clone sheet with formulaes Product: POI Version: 2.0-pre2 Platform: Other OS/Version: Other Status: NEW Severity: Normal Priority: Other Component: HSSF AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] Hi there, I am trying to create a report in Excel using POI. I read an Excel file as a template which also contins formulaes. Then I have to create around 15 Sheets dynamically for the report, in the same workbook. I create the first sheet successfully, and for the next on, I simply clone the first one. I found that if the first sheet contains formula, (in my case, it is simple SUM() function ) it gives me a funny exception as -- java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 0 When I remove the formaulaes, it works fine !!! I also tried to enter the formulaes using cell.setCellFormula() method, but the exception occus again. Cheers - Amol Athavale --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
