You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by David Pereira <dp...@polar.es> on 2003/06/04 11:14:49 UTC

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