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:[email protected]] 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: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
