回复 1楼xiechenming的帖子
你好:
思想就是将每列的WordWrap设置我True,然后用Spread的EditModeOff事件去获取最优行高
测试代码如下,请参考:
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
' テキスト型セルを設定します
Dim tcell As New FarPoint.Win.Spread.CellType.TextCellType()
tcell.WordWrap = True
FpSpread1.ActiveSheet.Columns(1).CellType = tcell
End Sub
Private Sub FpSpread1_EditModeOff(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles FpSpread1.EditModeOff
' 最も高さのあるテキストの高さに設定します
FpSpread1.ActiveSheet.Rows(0).Height = FpSpread1.ActiveSheet.GetPreferredRowHeight(0)
End Sub |