Thank you Nick, I had just tried your first suggestion before I got your email and still had to go through the multiple warnings. I like your suggestions and will continue along and report back. I use the POIFSFileSystem object to copy the template . I was wondering if there is another object I could try. Will be digging around and reporting my findings. Thanks for your response. - Jim
----- Original Message ----- From: "Nick Burch-11 [via Apache POI]" <[email protected]> To: "jamestthomas" <[email protected]> Sent: Monday, January 31, 2011 2:40:02 PM Subject: Re: POI from Excel 2000 to Excel 2010 issues. On Mon, 31 Jan 2011, jamestthomas wrote: > Up to now we have supported Excel 2000. We are moving to Office 2010 and > the download no longer works as well. Now when opening the downloaded > spread sheet there is a 4-step process where as before users simply > clicked enable macros. Office 2010 is stricter than Office 2000 was. You'll need to identify what POI is doing which is upsetting this newer excel. First up, see if you can get Excel to tell you what part of the file it objects to? Failing that, try: * open template in poi, save without changes, does excel like this? * create an empty template in excel (no macros, no/minimal data), then populate it with your application, does excel like this? * what is the smallest/simplest file that excel objects to? * and what parts do you need to leave out of that simple file to make excel like it? Hopefully the answer to those questions will help you identify which record(s) poi is writing out in a manner that excel 2010 doesn't like, and from there it's with any luck a quick bug fix Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [hidden email] For additional commands, e-mail: [hidden email] If you reply to this email, your message will be added to the discussion below: http://apache-poi.1045710.n5.nabble.com/POI-from-Excel-2000-to-Excel-2010-issues-tp3365053p3365100.html To unsubscribe from POI from Excel 2000 to Excel 2010 issues., click here . -- View this message in context: http://apache-poi.1045710.n5.nabble.com/POI-from-Excel-2000-to-Excel-2010-issues-tp3365053p3365148.html Sent from the POI - Dev mailing list archive at Nabble.com.
