Hide column in MultiColumnCombo

Posted by: suvi on 8 September 2017, 1:17 pm EST

  • Posted 8 September 2017, 1:17 pm EST


    i am using Spread for Windows Forms v25 for Visual Studio 2005.

    I want to hide some column on MultiColumnCombo on grid. Please suggest me how to achieve this.




  • Replied 8 September 2017, 1:17 pm EST

    Deepak -

    The MultiColumnCombobox was not added until version 3.  There is nothing in the cell type that allows for hiding a column.
  • Replied 8 September 2017, 1:17 pm EST


    As Bob stated, there is nothing on the CellType object to hide particular columns. However, you can use the SubEditorOpening event to get the SubEditor, which is a FpSpread object. You can get it's SheetView and hide a column.

     Private Sub FpSpread1_SubEditorOpening(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.SubEditorOpeningEventArgs) Handles FpSpread1.SubEditorOpening
    Dim ss As FarPoint.Win.Spread.FpSpread = CType(e.SubEditor, FarPoint.Win.Spread.FpSpread)
    ss.Sheets(0).ColumnHeaderVisible = False
    ss.Sheets(0).Columns(0).Visible = False

    End Sub
Need extra support?

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

Learn More

Forum Channels