I used SXSSF to generate the report via compiler jdk1.6.0_45. The excel file is generated with all the value available. But when i try to browse thru the record it some how not visible . I need to manually specify the cell number in the Excel . For example A1 in order to see the record. The same program when i switch to jdk1.6.0_37, i'm able to view the generated report and the contains.
Are you certain you're using the same version of Apache POI on both machines? No older versions on the classpath to confuse things? Assuming so, you'll need to unzip the .xlsx file generated on both JVMs, and diff the xml contents to see where things differ.
Yup i'm using the same version of apache poi jar to run both the application. For the JVM i have checked from the command prompt(java -version) to ensure i'm using the right version. By the way it was able to write but i'm not able to view the cell it was missing when i try to view from Microsoft Excel but if i use online Excel view i'm able to see the hidden cells. Do you require the excel which is having the issue?
> Do you require the excel which is having the issue? Please attach both files (jdk1.6.0_37/45) to this bug entry. We can do the unzipping/comparing for you ...
Created attachment 32383 [details] File which not able to view Hi Andreas, Attached file is the one having problem to view the cell .
Created attachment 32384 [details] File which able to view Hi Andreas, This is the file generated using JDK 1.6.0.37 which able to view the records
Created attachment 32385 [details] Source code Attached is the source code used to generated both the reports.
As the col width in sheet1.xml are all equal 0.0, this seems to be connected to the fontmanager.dll problem in 1.6.0_45 - see #54904 for more details. I assume you are running the code under Windows, right?
Yup i'm using windows, so this is basically issue on the font manager in the JRE causing the issue. Will try to use other font and see whether solve the issue. Not sure if this is the right platform how do i filter the date field which is in string to recognize as a date in excel?
Please re-try this with a current version of Java 7 or 8, I think there were some fixes done by Oracle in Java itself which might fix this. Inside POI we only could detect this and report at least some warning, i.e. that the reported font-sizing leads to 0-width columns whereas they are not actually hidden or set to 0 width...
We lately added a method SheetUtil.canComputeColumnWidht() which tries to provide a way to check if autosize will work. However it seems there are still cases where it returns "true" when in fact autosize will fail. It seems to not catch all cases as sometimes it depends on the actual string, i.e. "0" has a useful width, whereas "w" has no widht! I don't think we can do much more in POI currently except to desupport Java 6 as Java >= 7 seems to have far less problems with this.