You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Daniel Joshua <da...@gridnode.com> on 2004/06/01 04:57:16 UTC
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:zalewski@optonline.net]
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: acoliver@apache.org [mailto:acoliver@apache.org]
Sent: Monday, May 31, 2004 12:19 PM
To: poi-user@jakarta.apache.org
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 <kh...@yahoo.co.jp>
> Reply-To: "POI Users List" <po...@jakarta.apache.org>
> Date: Mon, 31 May 2004 21:23:02 +0900 (JST)
> To: poi-user@jakarta.apache.org
> 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: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
RE: Problems with POI 2.5
Posted by Michael Zalewski <za...@optonline.net>.
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:daniel.joshua@gridnode.com]
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:zalewski@optonline.net]
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: acoliver@apache.org [mailto:acoliver@apache.org]
Sent: Monday, May 31, 2004 12:19 PM
To: poi-user@jakarta.apache.org
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 <kh...@yahoo.co.jp>
> Reply-To: "POI Users List" <po...@jakarta.apache.org>
> Date: Mon, 31 May 2004 21:23:02 +0900 (JST)
> To: poi-user@jakarta.apache.org
> 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: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: Problems with POI 2.5
Posted by ac...@apache.org.
By ignoring it and hoping that it still worked? No, probably not.
--
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: "Daniel Joshua" <da...@gridnode.com>
> Reply-To: "POI Users List" <po...@jakarta.apache.org>
> Date: Tue, 1 Jun 2004 10:57:16 +0800
> To: "'POI Users List'" <po...@jakarta.apache.org>
> 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:zalewski@optonline.net]
> 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: acoliver@apache.org [mailto:acoliver@apache.org]
> Sent: Monday, May 31, 2004 12:19 PM
> To: poi-user@jakarta.apache.org
> 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 <kh...@yahoo.co.jp>
>> Reply-To: "POI Users List" <po...@jakarta.apache.org>
>> Date: Mon, 31 May 2004 21:23:02 +0900 (JST)
>> To: poi-user@jakarta.apache.org
>> 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: poi-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org