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