Summary: | Unreadable content opening XSSF generated excel using websphere 7 | ||
---|---|---|---|
Product: | POI | Reporter: | jagadish.b.n |
Component: | XSSF | Assignee: | POI Developers List <dev> |
Status: | RESOLVED INVALID | ||
Severity: | critical | CC: | jagadish.b.n |
Priority: | P2 | ||
Version: | 3.6-FINAL | ||
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | All | ||
Attachments: | attachment file generated using xssf in websphere |
Description
jagadish.b.n
2011-08-24 05:28:17 UTC
Created attachment 27444 [details]
attachment file generated using xssf in websphere
The attachment file enclosed is generated in websphere server.I have done few test on xlsx file by zipping it and found the issue in xl\worksheets\sheet1.xml as col width i.e col width="6.696695963541667". the decimals after dot(.) is more than 9. I have reset the decimals with exactly to 9 digits after dot(.) then I was able to open the report the successfully in ms-office 2007.
If you write a small unit test for this, and try to manually set the very long width value, what happens? Is it truncated as needed, or do you still end up with a >9 character width that excel objects to? Hi, We have fixed the below issue by using Servlet outStream to print the data instead of JSP outStream.Thanks,Jagadish seems to have been caused by code outside of poi |