Sudden errors in form designer

Posted by: wayne2 on 8 September 2017, 12:32 pm EST

  • Posted 8 September 2017, 12:32 pm EST

    I have a problem with a VS2005/VB project using Spread for Windows 2.0. The prpject has been working fine but suddenly I am getting errors from the forms designer code referencing Spread. The only system change I made was to remove MS Office 2007 Beta and install the full version of Office 2007. The errors all point to designer code such as:


    Me.FpSpread1_Sheet1.ColumnHeader.Get(0, 0).Text = "Seq Nbr"


    With an error msg such as:


    Error 2 'Get' is not a member of 'FarPoint.Win.Spread.ColumnHeader'.


    Any thoughts on how to resolve this?


    Wayne

  • Replied 8 September 2017, 12:32 pm EST

    Wayne,


    This was a bug in the older build of Spread for Windows Forms. The latest maintenance release should fix this issue. You will need to redesign the form or go into this generated code by hand to fix the code. In the example you show, it should read as:


    Me.FpSpread1_Sheet1.ColumnHeader.Cells.Get(0, 0).Text = "Seq Nbr"

  • Replied 8 September 2017, 12:32 pm EST

    Thanks Scott. Where do I find that maintenence release for WinForms 2.0? I only see one for vers 2.5?


    Also, what is the correct syntax for the following:


    Me.FpSpread1_Sheet1.ColumnHeader.Get(0,).Height = 40.0!


    Me.FpSpread1_Sheet1.RowHeader.Default.Resizable = True


    Me.FpSpread1_Sheet1.Get(0). Label = "Seq Nbr"


     

  • Replied 8 September 2017, 12:32 pm EST

    Wayne,


    The maintenance releases for all products are all in the same place on www.clubFarPoint.com. Once there click on the Updates link and you should see updates for all products.


    Here is the code to fix these lines of code.

     
    Me.FpSpread1_Sheet1.ColumnHeader.Rows.Get(0).Height = 40.0!
    Me.FpSpread1_Sheet1.RowHeader.Columns.Default.Resizable = True
    Me
    .FpSpread1_Sheet1.Columns.Get(0). Label = "Seq Nbr"

     
Need extra support?

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

Learn More

Forum Channels