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 2014/02/28 15:56:42 UTC
[Bug 56200] New: Sheet not visible with Java 1.7
https://issues.apache.org/bugzilla/show_bug.cgi?id=56200
Bug ID: 56200
Summary: Sheet not visible with Java 1.7
Product: POI
Version: unspecified
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: dev@poi.apache.org
Reporter: ktrykid@hotmail.com
Created attachment 31355
--> https://issues.apache.org/bugzilla/attachment.cgi?id=31355&action=edit
Code used for Debugging
Using the same code, I get different results between the 1.6.43x64 JRE and the
1.7.21x64 JRE. With 1.6 JRE the spreadsheet formats as expected. With 1.7
JRE, the created columns appear hidden. I've tried with POI 3.8 and 3.10
Final. The data is in the spreadsheet. If I select all rows/columns and paste
values to another sheet, I see the information entered.
--
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 56200] Sheet not visible with Java 1.7
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56200
--- Comment #3 from Nick Burch <ap...@gagravarr.org> ---
Are you certain you're using the same jars on both JVMs?
http://poi.apache.org/faq.html#faq-N10006 has some code you can use to verify
this
--
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 56200] Sheet not visible with Java 1.7
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56200
Chris W <kt...@hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |RESOLVED
Resolution|--- |FIXED
--- Comment #13 from Chris W <kt...@hotmail.com> ---
Updating to 1.7.51 seems to resolve this issue.
--
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 56200] Sheet not visible with Java 1.7
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56200
Nick Burch <ap...@gagravarr.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS| |All
--- Comment #1 from Nick Burch <ap...@gagravarr.org> ---
Since you're using .xlsx, the file format is a zip of xml files. Any chance you
could unzip the .xlsx files from 1.6 and 1.7, then compare them for
differences?
--
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 56200] Sheet not visible with Java 1.7
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56200
--- Comment #10 from awm@mbcli.com ---
autoSizeColumn has been causing issues with JAVA 7 since the very release of
1.7.0. For some reason I remember you (Nick) saying that you had narrowed it
down to a bug in Java libs. I may have to go back to the archives and see if I
can find that thread.
--
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 56200] Sheet not visible with Java 1.7
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56200
Nick Burch <ap...@gagravarr.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #11 from Nick Burch <ap...@gagravarr.org> ---
As mentioned on list, if someone could write a very small unit test based on
that, which works on 6 but fails on 7, that'd be very helpful!
Perhaps something that does:
* new workbook
* create some cells
* sets some styles, fonts etc
* autosizes two columns
* saves
* loads
* checks column widths
* asserts that simple columns are right (6 and 7 ok?)
* asserts that some more complex ones are too (fails on 7?)
The simpler and more standalone it is, the better the chances someone will be
able to reproduce + investigate + fix!
--
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 56200] Sheet not visible with Java 1.7
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56200
--- Comment #5 from Chris W <kt...@hotmail.com> ---
Confirmed. Just added those lines and ran it with both JREs. POI Jar paths
are the same. Results are different.
--
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 56200] Sheet not visible with Java 1.7
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56200
--- Comment #12 from Ole Tjensvold Johannessen <ol...@gmail.com> ---
https://bugs.openjdk.java.net/browse/JDK-8013716
try to upgrade your JDK
--
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 56200] Sheet not visible with Java 1.7
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56200
--- Comment #2 from Chris W <kt...@hotmail.com> ---
Unzipped and examined with a compare tool. The main difference I see is the
Width attribute under the \xl\worksheets\sheet1.xml on the column tags. I also
note that if I comment out the sheet.autosizecolumn() that it shows up. So
somehow the font/data size is getting interpreted as zero?
--
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 56200] Sheet not visible with Java 1.7
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56200
--- Comment #6 from Chris W <kt...@hotmail.com> ---
Here's the differences in the sheet1.xml files that I unzipped.
JRE 1.6
<cols>
<col min="1" max="1" width="8.7265625" customWidth="true" bestFit="true"/>
<col min="2" max="2" width="13.703125" customWidth="true" bestFit="true"/>
<col min="3" max="3" width="20.859375" customWidth="true" bestFit="true"/>
</cols>
JRE 1.7
<cols>
<col min="1" max="1" width="0.0" customWidth="true" bestFit="true"/>
<col min="2" max="2" width="0.0" customWidth="true" bestFit="true"/>
<col min="3" max="3" width="0.0" customWidth="true" bestFit="true"/>
</cols>
--
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 56200] Sheet not visible with Java 1.7
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56200
--- Comment #8 from Chris W <kt...@hotmail.com> ---
Getting a list of the available Fonts appears identical in both JVMs.
--
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 56200] Sheet not visible with Java 1.7
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56200
--- Comment #4 from Chris W <kt...@hotmail.com> ---
I'm pretty sure. I've executed it different ways to isolate the cause. I
created executable JARs and that's where I first noticed the difference but I
recreated it when I changed the JRE Library in Eclipse.
--
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 56200] Sheet not visible with Java 1.7
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56200
--- Comment #9 from Chris W <kt...@hotmail.com> ---
I do believe it is Font related though. I changed to cell_normal style to set
the Font to "Consolas" and it formats it as desired. Leaving it set to the
default Font (which is "Calibri") seems to be the root of the problem.
--
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 56200] Sheet not visible with Java 1.7
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=56200
--- Comment #7 from Nick Burch <ap...@gagravarr.org> ---
Can you check what fonts both JVMs can see? (AWT should let you check the fonts
installed + available to the JVM). I wonder if the 1.7 JVM is either missing a
key font, or has a broken font file?
--
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