ComboBoxCellType error on saveexcel

Posted by: buldom on 8 September 2017, 2:35 pm EST

  • Posted 8 September 2017, 2:35 pm EST

    I add many item in combobox. I see all item on spreaddsheet but when I save file in excel format, my cell lost combobox. If add less item, i see combobox in excel and i can choose item. You have maximum item or total charactere maximum when i save in excel format ?

    Using v5.0.3514

  • Replied 8 September 2017, 2:35 pm EST


    I tested your issue with the latest build of Spread5 and with approximately 80 items in combobox list and they are exported without any problem at my end. Could you please let me know the number of items you are exporting along wiht the length of the strings you have in your comboboxcelltype. If possible please send us the spread's xml for us to replicate the issue at our end and proceed further.


  • Replied 8 September 2017, 2:35 pm EST

    If i use top 16, i see combo box in my excel file. You can use new spreadsheet, i have same probleme

    Dim test As New ComboBoxCellType

    Dim tout(0) As String


    DBCtico.CommandText = "SELECT top 16 * FROM TICO_TRAVAILLEURS WHERE type = 1 order by travailleurs "

    Mysetdbc = DBCtico.ExecuteReader

    temp = 0

    While Mysetdbc.Read

           ReDim Preserve tout(temp)

           tout(temp) = Mysetdbc("travailleurs")

            temp += 1

    End While

    FpSpread1.Sheets(0).Cells(1, 0).CellType = New ComboBoxCellType   
    test = FpSpread1.Sheets(0).Cells(1, 0).CellType

    test.Items = tout

    Item in my table for top 16 :

    Bélec  G. abat.
    Bénard S.
    Bertrand A.
    Binette  M. déb.
    Bolduc R. Déb.
    Charbonneau P. déb.
    Cloutier Y. déb.
    Cyr  S. abat.
    Dufour D. abat.
    Dufour R. abat
    Fournier S. abat.
    Gaudreau Y. déb.
    Groulx R.
    Guénette M. déb.
    Léonard S. déb.
    Legault  abat.

    If I add one more, i lost combobox
    Labelle J-C. déb.



  • Replied 8 September 2017, 2:35 pm EST


    Thanks for providing us the string to replicate the issue. We are able to replicate the issue at our end with the string provided by you and have reported it as a bug in Spread and the bug number for the same is #99920626 which will be fixed in the future maintenance release of spread.


  • Replied 8 September 2017, 2:35 pm EST


    This issue(bug #99920626) has been fixed in our latest build for Spread version 5. Please download the latest build and test this behavior.
    You can download the latest build from:



    Manpreet Kaur

Need extra support?

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

Learn More

Forum Channels