You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2011/08/24 07:28:17 UTC
DO NOT REPLY [Bug 51715] New: Unreadable content opening XSSF
generated excel using websphere 7
https://issues.apache.org/bugzilla/show_bug.cgi?id=51715
Bug #: 51715
Summary: Unreadable content opening XSSF generated excel using
websphere 7
Product: POI
Version: 3.6
Platform: PC
Status: NEW
Severity: critical
Priority: P2
Component: XSSF
AssignedTo: dev@poi.apache.org
ReportedBy: jagadish.b.n@gmail.com
Classification: Unclassified
I have been developing excel reports using Apache poi. Initially I have
developed reports using HSSF implementation. The HSSF reports opened
successfully in office 2003.Later I started converting HSSF reports to XSSF
implementation to generate .xlsx report. The web application contaning xlsx
reports when hosted in tomcat server in stand alone system, the reports opened
successfully. But same application when hosted in Websphere 7 in client server
system does not open the excel report using office 2007. The error pops ups as
shown here --- excel found unreadable content in filename.xlsx.Do you want to
recover the contents of this workbook? .The list of jar files used in xssf
implementation i.e. poi-ooxml-3.6-20091214.jar,
poi-ooxml-schemas-3.6-20091214.jar,poi-3.6-20091214.jar, dom4j-1.6.1.jar
--
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 51715] Unreadable content opening XSSF generated excel using
websphere 7
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=51715
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |RESOLVED
Resolution|--- |INVALID
--- Comment #4 from Dominik Stadler <do...@gmx.at> ---
seems to have been caused by code outside of poi
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 51715] Unreadable content opening XSSF generated
excel using websphere 7
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=51715
--- Comment #1 from jagadish.b.n@gmail.com 2011-08-29 06:11:45 UTC ---
Created attachment 27444
--> https://issues.apache.org/bugzilla/attachment.cgi?id=27444
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.
--
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 51715] Unreadable content opening XSSF generated
excel using websphere 7
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=51715
--- Comment #3 from jagadish.b.n@gmail.com 2011-09-05 05:35:02 UTC ---
Hi, We have fixed the below issue by using Servlet outStream to print the data
instead of JSP outStream.Thanks,Jagadish
--
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 51715] Unreadable content opening XSSF generated
excel using websphere 7
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=51715
Nick Burch <ni...@alfresco.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #2 from Nick Burch <ni...@alfresco.com> 2011-08-29 12:53:33 UTC ---
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?
--
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 51715] Unreadable content opening XSSF generated
excel using websphere 7
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=51715
jagadish.b.n@gmail.com changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |jagadish.b.n@gmail.com
OS/Version| |All
--
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org