-----Original Message-----
From: Nick Burch [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 02, 2008 9:45 AM
To: POI Users List
Subject: Re: All Charts removed after modifying cell data using 3.5 beta
3
On Thu, 2 Oct 2008, Dobson, Paul L CTR USAF AFMC 416 SCMS/OBN wrote:
> I unzipped a copy of the original file and the same file after right
> after using Xssf to modify cell values (unconverted by excel). The
> modified file was missing the Following:
I know that xssf doesn't copy over all parts of the old file by default,
it only does the bits we support, and some others we don't yet support
but know to keep. Possibly not all of your parts are currently on the
latter list?
Though, I think at least some of the ones you mention should be being
copied over, certainly with the refactorings Yegor has done recently.
Maybe Yegor will have an idea here?
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Until I can find a better solution, I'm thinking about taking the
following steps as a workaround.
1. Open up the workbook to be changed.
2. Change the values I need to change (I am only changing exiting cell
values in existing sheets).
3. Save the new workbook as a temp file.
4. Use Java to implement the workaround
a. open the original unmodified workbook and the new temp file
created from step 3.
b. copy the modified xml sheets from the new workbook to the
original workbook.
c. Save the merged zip file under the original file name.
d. Delete the temp file created by poi.
Any ideas on how successful this approach would be before I waste time
implementing a possibly bad idea?
Thanks for any input.
Paul
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]