How to set flex sheet row header value manually

How to set flex sheet row header value manually

Posted by: syed.mahmud on 3 April 2023, 7:03 pm EST

• 

  syed.mahmud

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 3 April 2023, 7:03 pm EST

  I want to set each row’s row header manually according to my need . How can i do that ?

• 

  vivek.pannu

  

  • Post Options:
  • Link
    Copy

  Posted 4 April 2023, 3:48 pm EST

  Hi,

  FlexSheet’s row headers are set to ‘1,2,3…’ by default, as this is the expected behavior. In order to change the default row headers, you’ll have to handle the ‘formatItem’ event of the flexSheet and specify the new row headers value as per your requirements, like this -

  // add custom row header values
  flexSheet.formatItem.addHandler((s,e) => {
    if(e.panel == s.rowHeaders) {
      e.cell.innerText = 'Header ' + e.row;
    }
  })

  
  
  Please refer to the following sample for the same - https://stackblitz.com/edit/js-8vygs7?file=index.js

  Regards