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

    Hello,


    Among the new features in Spread 4, I've seen : "Bind Data Source to Range".


    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.


    Thanks !

  • Replied 8 September 2017, 1:01 pm EST

    Hello,


    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.

     
        <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()
     
  • 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