In the case of formulas, you should be OK unless you are using
=EMBED(). In
the case of macros, you should also be OK unless you have a button on
the
page to execute the macro.
If you are trying to modify a sheet which already contains an image,
that is
where you are probably finding a problem. However, modifying a sheet
that
contains just a simple image should work just fine. If your worksheet
contains things that POI 2.5 does not understand - I can think of images
that have associated hyperlinks or macros, for example - you will
likely end
up with a corrupt file.
POI 2.0 did not touch the Escher layer, so it didn't have this
problem. But
POI 2.5 does the same thing unless you use the new drawing API. So
POI 2.5
should work to modify a spreadsheet which contains drawings. Are you
saying
that this is the case? (I.e., your code which worked in 2.0 now does not
work in 2.5, even though you did not add any of the new API? If that
is the
case, you should post to Bugzilla, and the problem might get fixed
soon. If
you are trying to update the Escher layer, that will probably take a
while
longer).
-----Original Message-----
From: Tim Wilkins [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 01, 2004 4:52 AM
To: POI Users List
Subject: Re: Problems with POI 2.5
Thanks for that explanation Michael. Could you clarify for me if formula
cells and macro's are also Escher objects?
In my particular use case I don't have any of the objects you described
but with POI 2.5 my code produces non-readable xls files. However I do
modify sheets with images already embedded. Am I right in saying that
the reason POI 2.0 worked was because it did not touch the Escher layer
and so did not corrupt it?
Does anyone know if this corruption issue of the Escher layer look like
being solved anytime soon or is it currently a black whole issue that
might be with us for some time?
Any information greatfully received.
Cheers,
Tim
Michael Zalewski wrote:
You should be aware that a lot of objects that can be embedded into a
spreadsheet are 'Escher' objects. I would change what Andy said from
'The
main problem will be in modifying sheets with embedded graphics' to
'The
main problem will be in modifying sheets with embedded Escher objects'.
The main problems in 2.5 will occur if you try to modify the Escher
layer
on
a workbook that already contains an Escher layer. If you don't use
Escher
objects at all, create them from scratch, or copy them without
modification,
things work much better.
Objects which are affected by the Escher layer include
1) Embedded Charts
2) Embedded Office documents and drawings
3) Buttons, drop down boxes, text areas (as associated with user
dialogs and
VBA)
4) Comments
5) Embedded office applets, such as word art, organization charts,
equations, etc.
6) Embedded line art, even if it does not contain an image (such as
arrows,
lines, circles, etc.)
All of the above (and probably even more things) are part of Escher.
I have
found the main problem with POI 2.5 is that it destroys the Escher
layer if
you attempt to insert a graphic or other drawing. Works much better
if you
either have all your graphics in a template, or if you have a
template with
none of the above objects. For example, if you try to use POI to add a
single graphic to a spreadsheet which contains a single comment or
button...
*boom*.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, May 31, 2004 12:19 PM
To: [EMAIL PROTECTED]
Subject: Re: Problems with POI 2.5
POI 2.5 is a production release. The main problem will be in modifying
sheets with embedded graphics. Graphics support is pretty complete for
creating embedded Escher graphics but is not as complete for modifying
them.
If your use case does not involve modifying sheets containing embedded
graphics 2.5 and 2.0 are pretty much the same code. Again, I never
advocate
coding *anything* without unit tests to prove it works. Unit tests
will
allow you to code with confidence.
-Andy
--
Andrew C. Oliver
http://www.superlinksoftware.com/poi.jsp
Custom enhancements and Commercial Implementation for Jakarta POI
http://jakarta.apache.org/poi
For Java and Excel, Got POI?
The views expressed in this email are those of the author and are
almost
definitely not shared by the Apache Software Foundation, its board
or its
general membership. In fact they probably most definitively
disagree with
everything espoused in the above email.
From: KH Lim <[EMAIL PROTECTED]>
Reply-To: "POI Users List" <[EMAIL PROTECTED]>
Date: Mon, 31 May 2004 21:23:02 +0900 (JST)
To: [EMAIL PROTECTED]
Subject: Problems with POI 2.5
Has anyone came across this issue whether codes work under
POI 2.0 but not 2.5?
I can use 2.0, but HSSFSheet.setRowBreak is only available
in POI 2.5 ...
thx
__________________________________________________
Do You Yahoo!?
http://bb.yahoo.co.jp/
---------------------------------------------------------------------
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]
---------------------------------------------------------------------
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
