You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by "Height, Jason" <jh...@subcorp.com.au> on 2004/02/11 02:06:14 UTC
RE: cvs commit: jakarta-poi/src/documentation/content/xdocs/hssf
quick-guide.xml
Now that your work is in CVS, there was a bit of discussion on the mailing
list of people who wanted to work on this area.
Hopefully they should be able to take what has been done and extend it to
support reading/modification of existing drawings.
Jason
-----Original Message-----
From: Glen Stampoultzis [mailto:gstamp@iinet.net.au]
Sent: Wednesday, 11 February 2004 11:33 AM
To: POI Developers List
Subject: RE: cvs commit: jakarta-poi/src/documentation/content/xdocs/hssf
quick-guide.xml
At the moment creating a drawing on a sheet will not keep any existing
drawings. The potential is there to try and support reading drawing
objects but the initial requirement was to support writing so I played it
safe and didn't attempt to interpret existing shape objects.
At 09:54 AM 11/02/2004, you wrote:
>Is there a HSSFSheet.getPatriarch that will return the current Drawing
>Patriarch and wont erase drawings in the sheet? (There is no example of
this
>in the doco you just provided).
>
>Does this mean that there is one Patriarch for all drawings?
Glen Stampoultzis
gstamp@iinet.net.au
http://members.iinet.net.au/~gstamp/glen/
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org
--------------------------------------------------------------------------------------------------------------------
This e-mail (including attachments) is confidential information of Australian Submarine Corporation Pty Limited (ASC). It may also be legally privileged. Unauthorised use and disclosure is prohibited. ASC is not taken to have waived confidentiality or privilege if this e-mail was sent to you in error. If you have received it in error, please notify the sender promptly. While ASC takes steps to identify and eliminate viruses, it cannot confirm that this e-mail is free from them. You should scan this e-mail for viruses before it is used. The statements in this e-mail are those of the sender only, unless specifically stated to be those of ASC by someone with authority to do so.
RE: cvs commit:
jakarta-poi/src/documentation/content/xdocs/hssf quick-guide.xml
Posted by Glen Stampoultzis <gs...@iinet.net.au>.
At 04:14 PM 11/02/2004, you wrote:
>There are many reasons to read shapes. For instance, how else would you read
>and index the text inside of a text box or call-out.
Streaming the records out to extract the text probably wouldn't be hard to
implement (just an extension to the current event model). This would solve
your indexing issue. Building up the records into a higher level user
model would require more work however as you need to have a deeper
understanding of all ways shapes hang together.
>And OLE documents embedded in Excel (including ChartObjects) are within
>shape containers. So my guess is a call to getPatriarch will destroy any
>charts and embedded OLE documents on the worksheet (just a guess... haven't
>tried it).
That's correct as it currently stands.
>The OLE objects are actually in a separate stream, and referenced
>by OBJ records. But they are framed by a shape object, and if getPatriarch()
>kills all the shape objects, you would loose the properties like where the
>OLE window was positioned, whether it had a border, what the zoom ratio is,
>etc.
Yes. It wasn't designed to support this although I have no issue with
anyone attempting to add this support and I'd be happy to assist.
Regards,
Glen Stampoultzis
gstamp@iinet.net.au
http://members.iinet.net.au/~gstamp/glen/
RE: cvs commit: jakarta-poi/src/documentation/content/xdocs/hssf
quick-guide.xml
Posted by Michael Zalewski <za...@optonline.net>.
There are many reasons to read shapes. For instance, how else would you read
and index the text inside of a text box or call-out.
And OLE documents embedded in Excel (including ChartObjects) are within
shape containers. So my guess is a call to getPatriarch will destroy any
charts and embedded OLE documents on the worksheet (just a guess... haven't
tried it). The OLE objects are actually in a separate stream, and referenced
by OBJ records. But they are framed by a shape object, and if getPatriarch()
kills all the shape objects, you would loose the properties like where the
OLE window was positioned, whether it had a border, what the zoom ratio is,
etc.
-----Original Message-----
From: Glen Stampoultzis [mailto:gstamp@iinet.net.au]
Sent: Tuesday, February 10, 2004 9:23 PM
To: POI Developers List
Subject: RE: cvs commit: jakarta-poi/src/documentation/content/xdocs/hssf
quick-guide.xml
Yep. Although I'm not sure why reading shape objects would be useful to be
honest.
Keeping existing shape objects would be handy and probably easier to
implement than full reading support.
Regards,
Glen
At 12:06 PM 11/02/2004, you wrote:
>Now that your work is in CVS, there was a bit of discussion on the mailing
>list of people who wanted to work on this area.
>
>Hopefully they should be able to take what has been done and extend it to
>support reading/modification of existing drawings.
>
>Jason
>
>-----Original Message-----
>From: Glen Stampoultzis [mailto:gstamp@iinet.net.au]
>Sent: Wednesday, 11 February 2004 11:33 AM
>To: POI Developers List
>Subject: RE: cvs commit: jakarta-poi/src/documentation/content/xdocs/hssf
>quick-guide.xml
>
>
>At the moment creating a drawing on a sheet will not keep any existing
>drawings. The potential is there to try and support reading drawing
>objects but the initial requirement was to support writing so I played it
>safe and didn't attempt to interpret existing shape objects.
>
>At 09:54 AM 11/02/2004, you wrote:
> >Is there a HSSFSheet.getPatriarch that will return the current Drawing
> >Patriarch and wont erase drawings in the sheet? (There is no example of
>this
> >in the doco you just provided).
> >
> >Does this mean that there is one Patriarch for all drawings?
>
>
>Glen Stampoultzis
>gstamp@iinet.net.au
>http://members.iinet.net.au/~gstamp/glen/
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: poi-dev-help@jakarta.apache.org
>
>---------------------------------------------------------------------------
-----------------------------------------
>This e-mail (including attachments) is confidential information of
>Australian Submarine Corporation Pty Limited (ASC). It may also be
>legally privileged. Unauthorised use and disclosure is prohibited. ASC
>is not taken to have waived confidentiality or privilege if this e-mail
>was sent to you in error. If you have received it in error, please notify
>the sender promptly. While ASC takes steps to identify and eliminate
>viruses, it cannot confirm that this e-mail is free from them. You should
>scan this e-mail for viruses before it is used. The statements in this
>e-mail are those of the sender only, unless specifically stated to be
>those of ASC by someone with authority to do so.
Glen Stampoultzis
gstamp@iinet.net.au
http://members.iinet.net.au/~gstamp/glen/
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org
RE: cvs commit:
jakarta-poi/src/documentation/content/xdocs/hssf quick-guide.xml
Posted by Glen Stampoultzis <gs...@iinet.net.au>.
Yep. Although I'm not sure why reading shape objects would be useful to be
honest.
Keeping existing shape objects would be handy and probably easier to
implement than full reading support.
Regards,
Glen
At 12:06 PM 11/02/2004, you wrote:
>Now that your work is in CVS, there was a bit of discussion on the mailing
>list of people who wanted to work on this area.
>
>Hopefully they should be able to take what has been done and extend it to
>support reading/modification of existing drawings.
>
>Jason
>
>-----Original Message-----
>From: Glen Stampoultzis [mailto:gstamp@iinet.net.au]
>Sent: Wednesday, 11 February 2004 11:33 AM
>To: POI Developers List
>Subject: RE: cvs commit: jakarta-poi/src/documentation/content/xdocs/hssf
>quick-guide.xml
>
>
>At the moment creating a drawing on a sheet will not keep any existing
>drawings. The potential is there to try and support reading drawing
>objects but the initial requirement was to support writing so I played it
>safe and didn't attempt to interpret existing shape objects.
>
>At 09:54 AM 11/02/2004, you wrote:
> >Is there a HSSFSheet.getPatriarch that will return the current Drawing
> >Patriarch and wont erase drawings in the sheet? (There is no example of
>this
> >in the doco you just provided).
> >
> >Does this mean that there is one Patriarch for all drawings?
>
>
>Glen Stampoultzis
>gstamp@iinet.net.au
>http://members.iinet.net.au/~gstamp/glen/
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: poi-dev-help@jakarta.apache.org
>
>--------------------------------------------------------------------------------------------------------------------
>This e-mail (including attachments) is confidential information of
>Australian Submarine Corporation Pty Limited (ASC). It may also be
>legally privileged. Unauthorised use and disclosure is prohibited. ASC
>is not taken to have waived confidentiality or privilege if this e-mail
>was sent to you in error. If you have received it in error, please notify
>the sender promptly. While ASC takes steps to identify and eliminate
>viruses, it cannot confirm that this e-mail is free from them. You should
>scan this e-mail for viruses before it is used. The statements in this
>e-mail are those of the sender only, unless specifically stated to be
>those of ASC by someone with authority to do so.
Glen Stampoultzis
gstamp@iinet.net.au
http://members.iinet.net.au/~gstamp/glen/