Michael,
>However, modifying a sheet that contains just a simple
image should work just fine
Could you elaborate what a simple image is? I tried
bipmap/gif/wmf/emf, but to no avail.
--- Michael Zalewski <[EMAIL PROTECTED]> からのメッ
セージ：
> 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]
>
=== message truncated ===
__________________________________________________
Do You Yahoo!?
http://bb.yahoo.co.jp/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
