Bind to RowHeader Columns

Bind to RowHeader Columns

Posted by: kbj on 14 December 2019, 1:24 pm EST

• 

  kbj

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 14 December 2019, 1:24 pm EST

  Is it possible to bind a BindingSource to a RowHeader.column.DataField?
  
  as in:

  FpSpread1_Sheet1.RowHeader.Columns(0).DataField = "Title"
  
  

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 16 December 2019, 6:55 am EST

  Hello,

  Spread does not support binding the cells in the row or column header areas.
  
  So you cannot use the Column.DataField property in the row header columns.
  
  If you need to populate cells in the row header area with data from a data source, then you need to iterate over the data source and populate the cells individually using RowHeader.Cells[row,column].Value (or .Text).

  Thanks,
  
  Mohit