design time error trying to display tables of data

Posted by: dfsoftware on 8 September 2017, 1:05 pm EST

  • Posted 8 September 2017, 1:05 pm EST

    I am trying to display tables of data using FarPoint, there are no equations, just tables of numbers and some text.  i have upto 15 Farpoint spread tables on my form, i do a little bit of formatting, SimpleSkin, center the data, control the number of decimal points and thats about it.  all i do is copy and past data from an excel spreadsheet into each of the farpoint spreadsheets i have on my VB form.

    i can get all the tables and data input but when i save the VB code and come back to it and get an error message and i cannot get to view the form designer. below is the massage i get.

    Value cannot be null. Parameter name: value.RangeGroupModel

    at System.ComponentModel.ReflectPropertyDescriptor.SetValue(Object component, Object value)
    at System.ComponentModel.Design.Serialization.CodeDomSerializerBase.DeserializeAssignStatement(IDesignerSerializationManager manager, CodeAssignStatement statement)
    at System.ComponentModel.Design.Serialization.CodeDomSerializerBase.DeserializeStatement(IDesignerSerializationManager manager, CodeStatement statement)


    Warning 1 Value cannot be null.
    Parameter name: value.RangeGroupModel C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Copy of Salt Tables\Salt Tables\Salt_Tables.Designer.vb 768 0 

    below are the lines of code where the line error is reported from, line 768.

    767       Me.CaCl_Spread.Models = CType(resources.GetObject("CaCl_Spread.Models"),  FarPoint.Win.Spread.SheetView.DocumentModels)

    768       Me.CaCl_Table.SetViewportTopRow(0, 0, 3)

    769       Me.CaCl_Table.SetActiveViewport(0, -1, 0)

    full list of all lines of code associated with the Spread view i am trying to show.




    Me.CaCl_Spread.SheetName = "CaCl"

    Me.CaCl_Spread.ColumnCount = 13

    Me.CaCl_Spread.ColumnHeader.RowCount = 0

    Me.CaCl_Spread.RowCount = 43

    Me.CaCl_Spread.RowHeader.ColumnCount = 0

    Me.CaCl_Spread.ActiveSkin = FarPoint.Win.Spread.DefaultSkins.Simple1

    Me.CaCl_Spread.FrozenRowCount = 3

    Me.CaCl_Spread.Models = CType(resources.GetObject("CaCl_Spread.Models"), FarPoint.Win.Spread.SheetView.DocumentModels)

    Me.CaCl_Table.SetViewportTopRow(0, 0, 3)

    Me.CaCl_Table.SetActiveViewport(0, -1, 0)


    it talks about a value cannot be null but when i look at the line of code, there is no null value.

    Me.CaCl_Spread.Models = CType(resources.GetObject("CaCl_Spread.Models"), FarPoint.Win.Spread.SheetView.DocumentModels)


    i have tried to compose this same VB form and application 3 times and each time i run into this error.


  • Replied 8 September 2017, 1:05 pm EST


    First of all, which release of Spread for Windows Forms are you using? When saving the VB form, are you using the Spread Designer for wach of the Spread controls to paste values in from Excel, and then saving the project? If this is the case, try setting the SerializeModels property of each of the SheetView objects to False before saving the changes in Spread Designer.

  • Replied 8 September 2017, 1:05 pm EST

    Hi - I did binding redirect ..still i need to changes the property for each spread? Still I see the issue.
  • Replied 8 September 2017, 1:05 pm EST


    Could you post a small zipped project reproducing this issue for us to debug?

Need extra support?

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

Learn More

Forum Channels