Can I save and reuse a SheetView as an editor for the MultiColumnComboBoxCellType

Posted by: j2associates on 8 September 2017, 1:22 pm EST

  • Posted 8 September 2017, 1:22 pm EST

    Hello all,


    I'm trying to use a MultiColumnComboBoxCellType but there is a lot of setup to do for the editor (eg hidden columns, frozen columns, etc). I really don't want to have to do this every time the multi combo box drops. I seem to remember a thread a while ago where someone said that you could set up a SheetView and use that for the editor. Can someone help me with this? Thanks in advance for any ideas and/or suggestions!

  • Replied 8 September 2017, 1:22 pm EST

    j2 -

    I searched all morning for this and couldn't find anything.  Scott and I then discussed it and we think we added this as an enhancement for a future release.  You could perhaps try saving a spread to an xml file and then open that in the editor but we are not sure what the behavior would be, especially since you would be bound.

  • Replied 8 September 2017, 1:22 pm EST

    Hello BobM,


    I happened upon it when searching for some other stuff. The following 3 threads all delve fairly deeply into MultiColumnComboBoxCellTypes:


    Subeditor questions: http://www.clubfarpoint.com/Forums/forums/thread/63230.aspx


    Loading a predefined fpSpread as SubEditor: http://www.clubfarpoint.com/Forums/forums/thread/51537.aspx


    Possible bug in 3.0 using Arrow Keys when SubEditor spread has Horizontal ScrollBar enabled with FrozenColumnCount > 0: http://www.clubfarpoint.com/Forums/forums/thread/48978.aspx


    I am using the following code in a test project and it seems to be working correctly:


    Public Class Form1


        Private m_SubEditorSheetView As SheetView = Nothing


        Private Sub FpSpread1_SubEditorOpening(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.SubEditorOpeningEventArgs) Handles FpSpread1.SubEditorOpening
            Dim subEditor As FpSpread = CType(e.SubEditor, FpSpread)
            If m_SubEditorSheetView Is Nothing Then
                m_SubEditorSheetView = subEditor.ActiveSheet
                'm_SubEditorSheetView.ColumnHeaderVisible = False
                m_SubEditorSheetView.ColumnHeader.Rows(0).Height = 0
                m_SubEditorSheetView.Columns(0).Visible = False


            Else
                subEditor.Sheets(0) = m_SubEditorSheetView
            End If
        End Sub

  • Replied 8 September 2017, 1:22 pm EST

    j2 -

    I vaguely remember those posts.  Thanks for remembering them.

Need extra support?

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

Learn More

Forum Channels