Can i create a editable dropdown which accepts only integer?

Posted by: bharath-ron on 8 September 2017, 2:23 pm EST

  • Posted 8 September 2017, 2:23 pm EST

    Hello  All,

     

    I want to create a editable dropdown which can accept only integer . Currently if we create editable dropdown it accepts strings . Can I restrict the entry as it is taken care when the cell data type is set to integer .

     

    Thanks in Advance

    Bharath Ron 

  • Replied 8 September 2017, 2:23 pm EST

    Hello Bharath,


    You can set CharacterSet property of the ComboBoxCellType to Numeric only along with setting Editable property to true.



            Dim cbstr As String()
            cbstr = New String() {1, 2, 3, 4, 5, 6}
            Dim cmbocell As New FarPoint.Win.Spread.CellType.ComboBoxCellType()
            cmbocell.Items = cbstr
            cmbocell.Editable = True
            cmbocell.CharacterSet = FarPoint.Win.ComboCharacterSet.Numeric
            FpSpread1.ActiveSheet.Cells(0, 0).CellType = cmbocell


    Hope this will help you. Thanks.

  • Replied 8 September 2017, 2:23 pm EST

    thank you reev it worked
Need extra support?

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

Learn More

Forum Channels