Actually, 2.5 already works like 2.0 did, as long as you don't use the new image and drawing features. 2.5 handles the Escher layer like 2.0 did (i.e., ignores it and tries to copy everything through), unless you make a drawing object. If you use the API to make a drawing object, it builds the Escher objects from scratch, and replaces anything that was already present.
I think the biggest problem with 2.5 is when people have a template with (for example) cell comments in the template, then attempt to use POI to insert a drawing using the new code. It's not obvious that cell comments and images are related. So if you add images to a sheet that contains comments, you will destroy the frames which are used to position the comments. Apparently, not quite everything is cleaned up (in the case of comments), because the resulting workbook is corrupt. -----Original Message----- From: Daniel Joshua [mailto:[EMAIL PROTECTED] Sent: Monday, May 31, 2004 10:57 PM To: 'POI Users List' Subject: RE: Problems with POI 2.5 Just curious, will there be another release which handles the Escher layer like POI 2.0 did? Regards, Daniel -----Original Message----- From: Michael Zalewski [mailto:[EMAIL PROTECTED] Sent: Tuesday, 01 June, 2004 1:23 AM To: POI Users List Subject: RE: Problems with POI 2.5 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]
