I am afraid, we can really do this with POI-HSSF, but what we have been
doing here is that, we are using merge and then specifying the cell value
needed, and it will automatically wrap. but one rider is that, make sure
that, the merged region can relly accmodate your cell contents
regards,
chandoo
> -----Original Message-----
> From: David Pereira [SMTP:[EMAIL PROTECTED]
> Sent: Wednesday, June 04, 2003 2:45 PM
> To: lista POI
> Subject: Merge cell with WrapText=true
>
> Hello.
> I am trying:
> ----------------------
> | | |
> ----------------------
> | This is a long text|
> | with WrapText=true |
> ----------------------
>
> but not work.
>
> In VB code:
> ERROR!!
> Range("D16:E16").Select
> With Selection
> .HorizontalAlignment = xlGeneral
> .VerticalAlignment = xlBottom
> .WrapText = True
> .Orientation = 0
> .AddIndent = False
> .ShrinkToFit = False
> .MergeCells = True <----------------
> End With
>
> OK!!
> Range("D6:E6").Select
> With Selection
> .HorizontalAlignment = xlCenter
> .VerticalAlignment = xlBottom
> .WrapText = True
> .Orientation = 0
> .AddIndent = False
> .ShrinkToFit = False
> .MergeCells = False <----------------
> End With
> Selection.Merge <----------------
>
> How can I do it with HSSF?
>
> Thanks
>
> ---------------------------------------------------------------------
> 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]
