[prev in list] [next in list] [prev in thread] [next in thread] 

List:       poi-user
Subject:    RE: Excel 2013 thinks file is corrupt
From:       "Renaut, Jonathan (CTR)" <Jonathan.Renaut () associates ! hq ! dhs ! gov>
Date:       2015-03-19 17:37:35
Message-ID: 7596C21EB13EE348A01A53FE5ED8314341020D81 () D2ASEPREA018
[Download RAW message or body]

Nick - thanks, trying to answer your questions led me to the solution. I think a few \
versions back there was a bug in void \
org.apache.poi.xssf.usermodel.XSSFSheet.createFreezePane(int colSplit, int rowSplit, \
int leftmostColumn, int topRow) that flipped two of the parameters. We have a comment \
in a bunch of our files noting we'll eventually have to do something about this, and \
it appears that the introduction of Excel 2013 is that "eventually".

-----Original Message-----
From: Nick Burch [mailto:apache@gagravarr.org] 
Sent: Thursday, March 19, 2015 10:28 AM
To: POI Users List
Subject: Re: Excel 2013 thinks file is corrupt

On Thu, 19 Mar 2015, Renaut, Jonathan (CTR) wrote:
> We've been using POI (most recently 3.10) for a while to create Excel 
> reports and we're suddenly having a problem with a user who recently 
> upgraded to Excel 2013. If they try to open the file directly from IE, 
> Excel says it can't open the file because it's corrupt. If they save 
> and open, Excel offers to repair the file. From each sheet in the 
> file, it says "Removed Feature: View from /xl/worksheets/sheet1.xml 
> part". I tried upgrading to 3.11 and the results were the same.

Does the file look fine after Excel has repaired it? Anything lost? How do the \
original and repaired files differ? Does this happen on all files, or just some? If \
so, what triggers - size, comments, pictures, other?

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org For additional commands, \
e-mail: user-help@poi.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


[prev in list] [next in list] [prev in thread] [next in thread]