Header Orientation

Posted by: hunny on 8 September 2017, 12:50 pm EST

  • Posted 8 September 2017, 12:50 pm EST

    When i set the textorientation to "TextTopDown", the height of the column header does not automatically adjust. Did i miss anything in order to fit the text?



  • Replied 8 September 2017, 12:50 pm EST

    It will not adjust automatically.  Try the following...

    FpSpread1.ActiveSheet.Columns(0).Label = "This is a test"
    Dim t As New FarPoint.Win.Spread.CellType.TextCellType
    t.TextOrientation = FarPoint.Win.TextOrientation.TextTopDown
    FpSpread1.ActiveSheet.ColumnHeader.Rows(0).CellType = t

    Dim i As Integer = FpSpread1.ActiveSheet.ColumnHeader.Rows(0).GetPreferredHeight()
    FpSpread1.ActiveSheet.ColumnHeader.Rows(0).Height = i
  • Replied 8 September 2017, 12:50 pm EST

    Great, it works!

    thanks a lot <img src="/emoticons/emotion-2.gif" alt="Big Smile [:D]" />

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels