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

    Hello,

    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?


     

    Thanks,

     

  • Replied 8 September 2017, 2:25 pm EST

    Hi


    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


    is


    --> New version


    --> Old version..


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


    Thanks

  • Replied 8 September 2017, 2:25 pm EST

    AssemblyVersion of assembly "FarPoint.win.spread.dll" that was upgraded from is 2.0.2.0


    Thanks


     

  • Replied 8 September 2017, 2:25 pm EST

    Hello,

    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?

    Thanks.


    2010/08/LoadAndSaveUsingBinarySerialization.zip
Need extra support?

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

Learn More

Forum Channels