Yep, use code.

Search through the past message in the group and you
will find that one member has posted a method that
determines the required column width based upon the
contents of it's cells.

As to right to left, well instead of starting at
column 0 and adding to the column number, simply start
at the furthest right column your code determines is
necessary and decrement the column number to move
left.

--- Behrang Saeedzadeh <[EMAIL PROTECTED]> wrote:

> Hi,
> 
> Thanks for the reply. By RTL I mean "Right to Left".
> 
> Also, is it possible to force columns be at least as
> wide enough to
> make all their contents be visible (without the need
> for the user to
> double click on the column bar)?
> 
> Thanks in advance,
> Behi
> 
> On 12/18/05, Anthony Andrews
> <[EMAIL PROTECTED]> wrote:
> > By RTL do youmean that you want to write the Excel
> > file out to a large plotter/printer?
> >
> > If so, surely that is a function of a
> printer/plotter
> > driver and not of HSSF.
> >
> > --- Behrang Saeedzadeh <[EMAIL PROTECTED]>
> wrote:
> >
> > > Hi,
> > >
> > > How can I programatically make my Excel sheet to
> be
> > > RTL?
> > >
> > > Thanks in advance,
> > > Behi
> > >
> > > --
> > > "Science is a differential equation. Religion is
> a
> > > boundary limit" - Alan
> > > Turing
> > >
> > > Behrang Saeedzadeh
> > > http://www.jroller.com/page/behrangsa
> > > http://my.opera.com/behrangsa
> > >
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam?  Yahoo! Mail has the best spam
> protection around
> > http://mail.yahoo.com
> >
> >
>
---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> > Mailing List:    
> http://jakarta.apache.org/site/mail2.html#poi
> > The Apache Jakarta Poi Project: 
> http://jakarta.apache.org/poi/
> >
> >
> 
> 
> --
> "Science is a differential equation. Religion is a
> boundary limit" - Alan Turing
> 
> Behrang Saeedzadeh
> http://www.jroller.com/page/behrangsa
> http://my.opera.com/behrangsa
> 
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> Mailing List:    
> http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: 
> http://jakarta.apache.org/poi/
> 
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/

Reply via email to