https://issues.apache.org/bugzilla/show_bug.cgi?id=54636
Yujun Liang <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|REOPENED |RESOLVED Resolution|--- |INVALID --- Comment #9 from Yujun Liang <[email protected]> --- (In reply to comment #8) > Created attachment 30022 [details] > Test file converted into OOXML format. Thank you Mark. You did answer my question, as well as taught me to save as xlsx format to examine the older spreadsheet. If I had known that before I wouldn't have created this bug report. I agree this is not a POI bug. jxl uses native api so it can handle this situation, I understand POI can't do that. I am new to POI so I didn't understand the subtle difference in the storage, your example well illustrates it for me. Thanks. I wrote some POI wrapper so it allows me to do this, workbook.sheet(0).cell("A1") workbook.sheet("sheet1").cell("A2") workbook.sheet("sheet1").column("AT") workbook.sheet("sheet1").row("1") // row("1") is getRow(0) and workbook1.equals(workbook2) will compare sheet by sheet, cell by cell. That's how I found out the spreadsheet generated by older jasper library is not same as the one generated by the later jasper which using newer POI. Do you want to incorporate this API into POI library? -- 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]
