version compatability with grid designer serialzation and deserialzation of combo values

Posted by: solmon on 8 September 2017, 2:25 pm EST

  • Posted 8 September 2017, 2:25 pm EST

    Upgrade to ver: 4.0.2012.2005

    I serliazed the spreadsheet containing  cell with a combo box and a defined set of values, one of the value being empty string.

    Now after the upgrade when i tried to load the spreadsheet it gives me the following error

       at FarPoint.Win.Spread.CellType.ComboBoxCellType.Format(Object o)
       at FarPoint.Win.Spread.CellType.ComboBoxCellType.IsValid(Object value)
       at FarPoint.Win.Spread.SpreadView.a(Int32 A_0, Int32 A_1, ICellType A_2)
       at FarPoint.Win.Spread.SpreadView.a(Object A_0, SheetViewPropertyChangeEventArgs A_1)
       at FarPoint.Win.Spread.SheetViewPropertyChangeEventHandler.Invoke(Object sender, SheetViewPropertyChangeEventArgs e)
       at FarPoint.Win.Spread.SheetView.FirePropertyChanged(String propertyName)
       at FarPoint.Win.Spread.SheetView.SetActiveCell(Int32 row, Int32 column, Boolean clearSelection)
       at FarPoint.Win.Spread.SpreadView.a(Int32 A_0, Int32 A_1, MouseEventArgs A_2)
       at FarPoint.Win.Spread.SpreadView.g(MouseEventArgs A_0)
       at FarPoint.Win.Spread.FpSpread.OnMouseDown(MouseEventArgs e)
       at Frameworks.Controls.FpSpread.OnMouseDown(MouseEventArgs e) in D:\Development\Solmon\PT1523\Framework Desktop\AFControls\AFSpread.vb:line 84
       at System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks)
       at System.Windows.Forms.Control.WndProc(Message& m)
       at FarPoint.Win.Spread.FpSpread.WndProc(Message& m) 

    after some level of debug i figured out that the way empty string values are handled different in the new version of the far point while serilizing and deserializing.

    Any thoughts??

    Thanks and Regards 





  • Replied 8 September 2017, 2:25 pm EST


    Which version of Spread for Windows forms are you upgrading from? You have mentioned that you are upgrading to  v4.0.2012.2005. I would suggest you to upgrade to our latest build of Spread v4.0.2024.2005 also let me know are you using the Binay Serialization or XML Serialization?




  • Replied 8 September 2017, 2:25 pm EST


    Thanks for the quick reply. Please find few answers for your questions, i will follow with more

     we are using binary serialization.

    however I tried to debug and the reason i could find is the null value stored for empty string///

    when i tried the same with xml serilazation i could the see only difference in the combo box values wrt to new version and the old one


    <ListItem whitespace=""/> --> New version

    <ListItem/> --> Old version..

    HOpe this helps. i will try to get your anwsers soon.


  • Replied 8 September 2017, 2:25 pm EST

    AssemblyVersion of assembly "" that was upgraded from is



  • Replied 8 September 2017, 2:25 pm EST


    We are unable to get your issue replicated at my end with the latest version using binary serialization and deserialization wherein i am able to save Spreadsheet having combo-box with an empty string too into XML and open the same as well. Please have a look at the attached sample and let us know your further observations on the same.

    And also let us know that are you trying to open XML created in version 2 of Spread in version 4?


Need extra support?

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

Learn More

Forum Channels