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.

    <TABLE id=table1 cellSpacing=0 cellPadding=0>

    <TD align=left colSpan=2>
    <DIV class=ErrorStyle id=div1><FONT size=2><SPAN>Value cannot be null. Parameter name: value.RangeGroupModel </SPAN>
    </FONT><FONT size=2>Hide</FONT><FONT color=#0000ff size=2>    </FONT></DIV></TD></TR>
    <TD align=left colSpan=2>
    <DIV class=StackStyleVisible id=div20>
    <FONT size=2>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)</FONT></DIV>
    <DIV class=StackStyleVisible><FONT size=2></FONT> </DIV>
    <DIV class=StackStyleVisible><FONT size=2>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 
    <DIV class=StackStyleVisible>

    <FONT color=#008000><FONT size=2>below are the lines of code where the line error is reported from, line 768.</FONT></FONT>

    <FONT color=#0000ff size=2>

    <FONT color=#000000>767</FONT>       Me</FONT><FONT size=2>.CaCl_Spread.Models = </FONT><FONT color=#0000ff size=2>CType</FONT><FONT size=2>(resources.GetObject(</FONT><FONT color=#800000 size=2>"CaCl_Spread.Models"</FONT><FONT size=2>),  FarPoint.Win.Spread.SheetView.DocumentModels)

    </FONT><FONT color=#0000ff size=2><FONT color=#000000>768</FONT>       Me</FONT><FONT size=2>.CaCl_Table.SetViewportTopRow(0, 0, 3)

    </FONT><FONT color=#0000ff size=2><FONT color=#000000>769</FONT>       Me</FONT><FONT size=2>.CaCl_Table.SetActiveViewport(0, -1, 0)


    <FONT color=#008000><FONT size=2>full list of all lines of code associated with the Spread view i am trying to show.</FONT>


    <FONT color=#008000><FONT size=2>'CaCl_Spread</FONT>


    <FONT color=#008000><FONT size=2>'</FONT>


    <FONT size=2><FONT color=#0000ff>Me</FONT>.CaCl_Spread.Reset()</FONT>

    <FONT size=2><FONT color=#0000ff>Me</FONT>.CaCl_Spread.SheetName = <FONT color=#800000>"CaCl"


    <FONT size=2><FONT color=#0000ff>Me</FONT>.CaCl_Spread.ColumnCount = 13</FONT>

    <FONT size=2><FONT color=#0000ff>Me</FONT>.CaCl_Spread.ColumnHeader.RowCount = 0</FONT>

    <FONT size=2><FONT color=#0000ff>Me</FONT>.CaCl_Spread.RowCount = 43</FONT>

    <FONT size=2><FONT color=#0000ff>Me</FONT>.CaCl_Spread.RowHeader.ColumnCount = 0</FONT>

    <FONT size=2><FONT color=#0000ff>Me</FONT>.CaCl_Spread.ActiveSkin = FarPoint.Win.Spread.DefaultSkins.Simple1</FONT>

    <FONT size=2><FONT color=#0000ff>Me</FONT>.CaCl_Spread.FrozenRowCount = 3</FONT>

    <FONT size=2><FONT color=#0000ff>Me</FONT>.CaCl_Spread.Models = <FONT color=#0000ff>CType</FONT>(resources.GetObject(<FONT color=#800000>"CaCl_Spread.Models"</FONT>), FarPoint.Win.Spread.SheetView.DocumentModels)</FONT>

    <FONT size=2><FONT color=#0000ff>Me</FONT>.CaCl_Table.SetViewportTopRow(0, 0, 3)</FONT>

    <FONT size=2><FONT color=#0000ff>Me</FONT>.CaCl_Table.SetActiveViewport(0, -1, 0)</FONT>

    <FONT size=2></FONT> 

    <FONT size=2>it talks about a value cannot be null but when i look at the line of code, there is no null value.</FONT>

    <FONT size=2>

    </FONT><FONT color=#0000ff size=2>Me</FONT><FONT size=2>.CaCl_Spread.Models = </FONT><FONT color=#0000ff size=2>CType</FONT><FONT size=2>(resources.GetObject(</FONT><FONT color=#800000 size=2>"CaCl_Spread.Models"</FONT><FONT size=2>), FarPoint.Win.Spread.SheetView.DocumentModels)</FONT>

    <FONT size=2></FONT> 

    <FONT size=2>i have tried to compose this same VB form and application 3 times and each time i run into this error.

    </FONT></DIV></TD></TR></TABLE><FONT size=2> </FONT>

  • 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