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]
