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