You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Babu kumar Thannasi <ba...@yahoo.com> on 2007/10/31 16:25:01 UTC
is arrow Head line in POI HSSF available?
Hi ,
i am using POI 3.0.1 JAR . i am using it for Excel . we have to draw line with arrrow head in our excel . i searched the API , but i could not not find one.
is POI- HSSF supports one ?
thanks
Babu
Thanks,
Babu.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Re[2]: is arrow Head line in POI HSSF available?
Posted by Yegor Kozlov <ye...@dinom.ru>.
1. You can checkout the latest version from svn
http://poi.apache.org/subversion.html
2. Download the source code for POI 3.0.1 from an Apache download
mirror.
Yegor
> Hello , where can i find poifs.dev or hssf.dev ?
> Nick Burch <ni...@torchbox.com> wrote: On Wed, 31 Oct 2007, Babu kumar Thannasi wrote:
>> As of now we do not have "HSSFSimpleShape.LINESTYLE_ARROWHEAD " . so i
>> could not draw a line with Arrow head.
> Your best bet is to:
> * create a file with excel with no arrow
> * save a copy of it
> * open the copy in excel, and set the linestyle to what you want
> * compare the two files (using the tools in poifs.dev or hssf.dev), and
> figure out what the value is we'd need to set to get the arrowhead
> * let us know, and we'll add that constant to poi
> Nick
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
> Thanks,
> Babu.
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: is arrow Head line in POI HSSF available?
Posted by Nick Burch <ni...@torchbox.com>.
On Tue, 6 Nov 2007, Babu kumar Thannasi wrote:
> Hello , where can i find poifs.dev or hssf.dev ?
Those are short for the packages
org.apache.poi.poifs.dev
and
org.apache.poi.hssf.dev
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: is arrow Head line in POI HSSF available?
Posted by Babu kumar Thannasi <ba...@yahoo.com>.
Hello , where can i find poifs.dev or hssf.dev ?
Nick Burch <ni...@torchbox.com> wrote: On Wed, 31 Oct 2007, Babu kumar Thannasi wrote:
> As of now we do not have "HSSFSimpleShape.LINESTYLE_ARROWHEAD " . so i
> could not draw a line with Arrow head.
Your best bet is to:
* create a file with excel with no arrow
* save a copy of it
* open the copy in excel, and set the linestyle to what you want
* compare the two files (using the tools in poifs.dev or hssf.dev), and
figure out what the value is we'd need to set to get the arrowhead
* let us know, and we'll add that constant to poi
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Thanks,
Babu.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Re: is arrow Head line in POI HSSF available?
Posted by Nick Burch <ni...@torchbox.com>.
On Wed, 31 Oct 2007, Babu kumar Thannasi wrote:
> As of now we do not have "HSSFSimpleShape.LINESTYLE_ARROWHEAD " . so i
> could not draw a line with Arrow head.
Your best bet is to:
* create a file with excel with no arrow
* save a copy of it
* open the copy in excel, and set the linestyle to what you want
* compare the two files (using the tools in poifs.dev or hssf.dev), and
figure out what the value is we'd need to set to get the arrowhead
* let us know, and we'll add that constant to poi
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: is arrow Head line in POI HSSF available?
Posted by Babu kumar Thannasi <ba...@yahoo.com>.
Thanks For Reply Anthony,
I am trying to do like
HSSFClientAnchor a28 = new HSSFClientAnchor();
a28.setAnchor((short) 9, 3, 100, 125, (short)14, 3, 1000, 125);
HSSFSimpleShape shape28 = patriarch.createSimpleShape(a28);
shape28.setShapeType(HSSFSimpleShape.OBJECT_TYPE_LINE);
shape28.setLineStyle(HSSFSimpleShape.LINESTYLE_ARROWHEAD); // i Need a Arrow Head line.
As of now we do not have "HSSFSimpleShape.LINESTYLE_ARROWHEAD " . so i could not draw a line with Arrow head.
Anthony Andrews <py...@yahoo.com> wrote:
I am not completely sure what you are after, so forgive me please if I am stating the obvious.
Are you trying to do something like;
----------->
Or are you after something far more 'graphical' such as the sort of line you would see on a UML diagram?
If the latter, I would guess that the best thing to do is to insert an image into a cell or cells.
Babu kumar Thannasi wrote: Hi ,
i am using POI 3.0.1 JAR . i am using it for Excel . we have to draw line with arrrow head in our excel . i searched the API , but i could not not find one.
is POI- HSSF supports one ?
thanks
Babu
Thanks,
Babu.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Thanks,
Babu.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Re: is arrow Head line in POI HSSF available?
Posted by Anthony Andrews <py...@yahoo.com>.
I am not completely sure what you are after, so forgive me please if I am stating the obvious.
Are you trying to do something like;
----------->
Or are you after something far more 'graphical' such as the sort of line you would see on a UML diagram?
If the latter, I would guess that the best thing to do is to insert an image into a cell or cells.
Babu kumar Thannasi <ba...@yahoo.com> wrote: Hi ,
i am using POI 3.0.1 JAR . i am using it for Excel . we have to draw line with arrrow head in our excel . i searched the API , but i could not not find one.
is POI- HSSF supports one ?
thanks
Babu
Thanks,
Babu.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com