How to bind a column to a datasource in the spread designer.

Posted by: meghasriv on 8 September 2017, 10:35 am EST

  • Posted 8 September 2017, 10:35 am EST

    Hi,


    My spreadsheet is bound to an object data source called Timecards. One of the columns of the spreadsheet is a ComboBox which has to be filled with values from another data source (Category). In the Spread designer, I set the celltype of the column in question to combobox. Now, I want to bind this column to a datasource to display a complete list of categories. The selected value will be the one comning in from the Timecards object source.


    I want to use the spread designer to define the cell type as a combobox and not want to do it in code. The spread designer gives access to the look and feel properties. However, I cant figure out how to bind the combobox in the spread designer to the category datasource.


    Thanks, Mala

  • Replied 8 September 2017, 10:35 am EST

    Hello Mala,


    In case you are referring to customizing Column and Field Binding using SpreadDesigner, then you may try the following steps:


    1.Create your data set.
    2.Set the FpSpread or Sheet DataSource property equal to the data set.
    3.Open the Spread Designer for the FarPoint Spread component.
    4.Select the sheet tab for the sheet for which you want to set the column fields.
    5.Set the AutoGenerateColumn property to false, because you want to override the auto-generated column and field mappings.
    6.Select the column for which you want to set the data field.
    7.Set the DataField property to the field you want to display in the selected column.
    8.Continue to select columns and set their DataField properties until you have set all the columns you want. You can leave some of the columns unbound if you want to do so.
    9.From the File menu choose Apply and Exit to apply your changes to the component and exit Spread Designer.


    Thanks

  • Replied 23 February 2021, 9:52 pm EST

    But after doing this, the sorting is not working.

    If you have any suggestions please do the needful
  • Marked as Answer

    Replied 25 February 2021, 10:32 pm EST

    Hi Nilesh,
    This issue has been fixed in the latest release of Spread v11. You can either upgrade to the latest version of Spread v11 or to the latest version of Spread which is Spread v14. We recommend you use the latest version of the Spread since every release comes with new features and bug fixes.

    Installer v11: https://cdn.grapecity.com/SpreadNET/installer/11.0.20183.0/offlineDownload_Full.zip
    Spread V14: https://www.grapecity.com/spreadnet/download

    Please let us know if you have any further queries.

    Regards,
    Manish Gupta
Need extra support?

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

Learn More

Forum Channels