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

    <P>Upgrade to ver: 4.0.2012.2005</P>
    <P>I serliazed the spreadsheet containing  cell with a combo box and a defined set of values, one of the value being empty string.</P>
    <P>Now after the upgrade when i tried to load the spreadsheet it gives me the following error</P>
    <P>   at FarPoint.Win.Spread.CellType.ComboBoxCellType.Format(Object o)<BR>   at FarPoint.Win.Spread.CellType.ComboBoxCellType.IsValid(Object value)<BR>   at FarPoint.Win.Spread.SpreadView.a(Int32 A_0, Int32 A_1, ICellType A_2)<BR>   at FarPoint.Win.Spread.SpreadView.a(Object A_0, SheetViewPropertyChangeEventArgs A_1)<BR>   at FarPoint.Win.Spread.SheetViewPropertyChangeEventHandler.Invoke(Object sender, SheetViewPropertyChangeEventArgs e)<BR>   at FarPoint.Win.Spread.SheetView.FirePropertyChanged(String propertyName)<BR>   at FarPoint.Win.Spread.SheetView.SetActiveCell(Int32 row, Int32 column, Boolean clearSelection)<BR>   at FarPoint.Win.Spread.SpreadView.a(Int32 A_0, Int32 A_1, MouseEventArgs A_2)<BR>   at FarPoint.Win.Spread.SpreadView.g(MouseEventArgs A_0)<BR>   at FarPoint.Win.Spread.FpSpread.OnMouseDown(MouseEventArgs e)<BR>   at Frameworks.Controls.FpSpread.OnMouseDown(MouseEventArgs e) in D:\Development\Solmon\PT1523\Framework Desktop\AFControls\AFSpread.vb:line 84<BR>   at System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks)<BR>   at System.Windows.Forms.Control.WndProc(Message& m)<BR>   at FarPoint.Win.Spread.FpSpread.WndProc(Message& m) </P>
    <P>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.</P>
    <P>Any thoughts??</P>
    <P>Thanks and Regards </P>
    <P> </P>
    <P> </P>
    <P> </P>
    <P> </P>
  • Replied 8 September 2017, 2:25 pm EST

    <p>Hello,</p><p>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?</p><p><br></p><p> </p><p>Thanks,</p><p> </p>
  • Replied 8 September 2017, 2:25 pm EST

    <P>Hi</P>
    <P>Thanks for the quick reply. Please find few answers for your questions, i will follow with more</P>
    <P> we are using binary serialization.</P>
    <P>however I tried to debug and the reason i could find is the null value stored for empty string///</P>
    <P>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</P>
    <P>is </P>
    <P><ListItem whitespace=""/> --> New version</P>
    <P><ListItem/> --> Old version..</P>
    <P>HOpe this helps. i will try to get your anwsers soon.</P>
    <P>Thanks </P>
  • Replied 8 September 2017, 2:25 pm EST

    <P>AssemblyVersion of assembly "FarPoint.win.spread.dll" that was upgraded from is 2.0.2.0 </P>
    <P>Thanks</P>
    <P> </P>
  • Replied 8 September 2017, 2:25 pm EST

    <p>Hello,</p><p>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.</p><p>And also let us know that are you trying to open XML created in version 2 of Spread in version 4?</p><p>Thanks.<br></p>
    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