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

    <P>Hello all,</P>
    <P>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!</P>
  • Replied 8 September 2017, 1:22 pm EST

    <p>j2 -</p><p>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. <br></p>
  • Replied 8 September 2017, 1:22 pm EST

    <P>Hello BobM,</P>
    <P>I happened upon it when searching for some other stuff. The following 3 threads all delve fairly deeply into MultiColumnComboBoxCellTypes:</P>
    <P>Subeditor questions: <A href="http://www.clubfarpoint.com/Forums/forums/thread/63230.aspx">http://www.clubfarpoint.com/Forums/forums/thread/63230.aspx</A></P>
    <P>Loading a predefined fpSpread as SubEditor: <A href="http://www.clubfarpoint.com/Forums/forums/thread/51537.aspx">http://www.clubfarpoint.com/Forums/forums/thread/51537.aspx</A></P>
    <P>Possible bug in 3.0 using Arrow Keys when SubEditor spread has Horizontal ScrollBar enabled with FrozenColumnCount > 0: <A href="http://www.clubfarpoint.com/Forums/forums/thread/48978.aspx">http://www.clubfarpoint.com/Forums/forums/thread/48978.aspx</A></P>
    <P>I am using the following code in a test project and it seems to be working correctly:</P>
    <P>Public Class Form1</P>
    <P>    Private m_SubEditorSheetView As SheetView = Nothing</P>
    <P>    Private Sub FpSpread1_SubEditorOpening(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.SubEditorOpeningEventArgs) Handles FpSpread1.SubEditorOpening<BR>        Dim subEditor As FpSpread = CType(e.SubEditor, FpSpread)<BR>        If m_SubEditorSheetView Is Nothing Then<BR>            m_SubEditorSheetView = subEditor.ActiveSheet<BR>            'm_SubEditorSheetView.ColumnHeaderVisible = False<BR>            m_SubEditorSheetView.ColumnHeader.Rows(0).Height = 0<BR>            m_SubEditorSheetView.Columns(0).Visible = False</P>
    <P>        Else<BR>            subEditor.Sheets(0) = m_SubEditorSheetView<BR>        End If<BR>    End Sub<BR></P>
  • Replied 8 September 2017, 1:22 pm EST

    <p>j2 -</p><p>I vaguely remember those posts.  Thanks for remembering them. <br></p>
Need extra support?

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

Learn More

Forum Channels