Bind to a range of cells

Posted by: croquignol on 8 September 2017, 1:01 pm EST

  • Posted 8 September 2017, 1:01 pm EST

    <P>Hello,</P>
    <P>Among the new features in Spread 4, I've seen : "Bind Data Source to Range".</P>
    <P>Where is this feature commented and explained in the help file ? I can't find anything about it in the Developer's Guide ("Managing Data binding"). It explains only how to bind a whole sheet to a data source, not a particular range.</P>
    <P>Thanks !</P>
  • Replied 8 September 2017, 1:01 pm EST

    <P>Hello,</P>
    <P>This is something I will pass along to documentation to get written up. For now, here is code to take a DataTable and bind it to a range of 1 column, 1 row of cells in Spread.</P> <PRE class=coloredcode> <SPAN class=kwd>Dim</SPAN> data <SPAN class=kwd>As New</SPAN> FarPoint.Win.Spread.Data.SpreadDataBindingAdapter
    data.DataSource = dt
    data.Spread = FpSpread1
    data.SheetName = <SPAN class=st>"Sheet1"</SPAN>
    data.MapperInfo = <SPAN class=kwd>New</SPAN> FarPoint.Win.Spread.Data.MapperInfo(3, 2, 1, 1)
    data.FillSpreadDataByDataSource()</PRE> 
  • Replied 8 September 2017, 1:01 pm EST

    Much thanks, Scott.
Need extra support?

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

Learn More

Forum Channels