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 2015/01/20 07:31:16 UTC

[Bug 57469] New: Unable to view excel cell compiled in jdk1.6.0_45

https://issues.apache.org/bugzilla/show_bug.cgi?id=57469

            Bug ID: 57469
           Summary: Unable to view excel cell compiled in jdk1.6.0_45
           Product: POI
           Version: 3.11-FINAL
          Hardware: PC
            Status: NEW
          Severity: critical
          Priority: P2
         Component: SXSSF
          Assignee: dev@poi.apache.org
          Reporter: Viknesh.Veluchamy@aia.com

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.

-- 
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 57469] Unable to view excel cell compiled in jdk1.6.0_45

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=57469

--- Comment #5 from viknesh <Vi...@aia.com> ---
Created attachment 32384
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=32384&action=edit
File which able to view

Hi Andreas,
    This is the file generated using JDK 1.6.0.37 which able to view the
records

-- 
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 57469] Unable to view excel cell compiled in jdk1.6.0_45

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=57469

--- Comment #7 from Andreas Beeker <ki...@apache.org> ---
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?

-- 
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 57469] Unable to view excel cell compiled in jdk1.6.0_45

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=57469

--- Comment #2 from viknesh <Vi...@aia.com> ---
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?

-- 
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 57469] Unable to view excel cell compiled in jdk1.6.0_45

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=57469

--- Comment #4 from viknesh <Vi...@aia.com> ---
Created attachment 32383
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=32383&action=edit
File which not able to view

Hi Andreas,

  Attached file is the one having problem to view the cell .

-- 
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 57469] Unable to view excel cell compiled in jdk1.6.0_45

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=57469

--- Comment #3 from Andreas Beeker <ki...@apache.org> ---
> 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 ...

-- 
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 57469] Unable to view excel cell compiled in jdk1.6.0_45

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=57469

viknesh <Vi...@aia.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |Viknesh.Veluchamy@aia.com
                 OS|                            |All

-- 
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 57469] Unable to view excel cell compiled in jdk1.6.0_45

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=57469

Nick Burch <ap...@gagravarr.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |NEEDINFO

--- Comment #1 from Nick Burch <ap...@gagravarr.org> ---
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.

-- 
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 57469] Unable to view excel cell compiled in jdk1.6.0_45

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=57469

--- Comment #8 from viknesh <Vi...@aia.com> ---
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?

-- 
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 57469] Unable to view excel cell compiled in jdk1.6.0_45

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=57469

--- Comment #6 from viknesh <Vi...@aia.com> ---
Created attachment 32385
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=32385&action=edit
Source code

Attached is the source code used to generated both the reports.

-- 
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