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

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

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

• 

  meghasriv

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  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

• 

  sureshd

  • Post Options:
  • Link
    Copy

  Posted 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

• 

  nilesh.raval

  • Post Options:
  • Link
    Copy

  Posted 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

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 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