On Wed, 26 Mar 2008, [EMAIL PROTECTED] wrote:
Querying in the Microsoft forums has revealed that such issues are
present for other users also. However, details/solutions regarding the
same are not available.
I've tried updating the version of Apache POI used to 'poi-3.0.2-FINAL'.
However, the issue still remains.
A couple of things to try:
* If your application loads an existing file, puts the data into it, then
gives that to the user, try using a completely blank file as your
template. That will help you figure out if the problem is with how poi
treats your complex template, or with how poi writes your file
* Try exporting less data into the spreadsheet. Is there some magic amount
of data that allows your file to open ok?
* Try exporting your data without formatting. Does that fix it? If so, are
you adding a very large number of styles? Complex fonts?
* Try to write a small unit test for the problem. Say, have file A which
opens fine in excel. Load it in the unit test, perform some edits on
it, and save as file B. File B no longer opens properly in excel.
That'll help us narrow down where your problem lies
It's also probably worth trying with a recent svn checkout / nightly build
(<http://encore.torchbox.com/poi-svn-build/>). None of the changes since
3.0.2 spring to mind as being able to help your situation, but it's worth
trying all the same
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
