Combobox hangs occasionally

Posted by: pugal on 8 September 2017, 1:54 pm EST

  • Posted 8 September 2017, 1:54 pm EST

    I have a combo box as cell type. It is filled with list of years. When the user keeps on changing the selected item in the combo box, it hangs suddenly and is in expanded state till we close the application. Please let me know if any solution is available.


     


    Thanks,


    Pugal

  • Replied 8 September 2017, 1:54 pm EST

    Pugal,

    I tested the issue with 4.0.2009.2005 & 4.0.2010.2005 versions of the spread control and it did not hang/freeze upon changing the selected item in from the combo box.I have set up a cell as combo box cell type and populated it with name of the years and tried changing the slected item frequently. but it did not freeze. Please let us know, in case we missed any step while replicating the reported issue.

    Thanks

  • Replied 8 September 2017, 1:54 pm EST

    Hi,


     We are using 4.0.2003.2005 version of spread control. Can you please verify in this version and update me.


    Thanks,


    Pugal

  • Replied 8 September 2017, 1:54 pm EST

    Pugal,

    I have tested the reported issue with 4.0.2003.2005 version of the control and still not able to reproduce the same at my side.I used the below snippet to set the combobox cell type:

            Dim cbstr As String()
            cbstr = New String() {"1900", "1910", "1920", "1930", "1940", "1950"}
            Dim cmbocell As New FarPoint.Win.Spread.CellType.ComboBoxCellType()
            cmbocell.Items = cbstr
            cmbocell.Editable = True
            cmbocell.MaxDrop = 4
            FpSpread1.ActiveSheet.Cells(0, 0).CellType = cmbocell

    On changing the cell value, it does not freeze and works as expected. In case you are seeing the issue at your side, please let us know steps to replicate or a zipped sample project which replicates it at our side. I also suggest you to upgrading to latest available build of Spread to verify the issue and let us know your observations.

    Thanks

  • Replied 8 September 2017, 1:54 pm EST

    Suresh,


    We have 5 combo boxes under a tab. When trying to click a year and before the dropdown closes, weare trying to select another year and the issue occurs. We have the below events defined for this..


    Private Sub sprBalSheet_EditChange(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.EditorNotifyEventArgs) Handles sprBalSheet.EditChange


    If sprBalSheet.ActiveSheet.ActiveCell.Text = "" And Not (sprBalSheet.ActiveSheet.ActiveRowIndex = 0 Or sprBalSheet.ActiveSheet.ActiveRowIndex = 1) And sprBalSheet.ActiveSheet.ActiveColumnIndex > 1 Then


    sprBalSheet.ActiveSheet.ActiveCell.Text = 0


    End If


    End Sub


     


    Private Sub sprBalSheet_ComboCloseUp(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.EditorNotifyEventArgs) Handles sprBalSheet.ComboCloseUp


    Me.sprBalSheet.ActiveSheet.ActiveColumnIndex = Me.sprBalSheet.ActiveSheet.ColumnCount


    Me.sprBalSheet.ActiveSheet.ActiveRowIndex = Me.sprBalSheet.ActiveSheet.RowCount


    End Sub


     


    Does the above code hve anything to do with the issue.


     


    Thanks,


    Pugal

  • Replied 8 September 2017, 1:54 pm EST

    Pugal,


    I tried reproducing this issue and was not able to do so either. I do not think the code you posted could cause the combobox to hang as you are seeing. You can try cmomenting out the code in your project to see if you still have problems. Or you can post a small zipped project reproducing the issue for us to debug.

Need extra support?

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

Learn More

Forum Channels