Rows be 2 digits

Rows be 2 digits

Posted by: patrik on 30 July 2023, 5:03 pm EST

• 

  patrik

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 30 July 2023, 5:03 pm EST

  rows counter on the spread are like.

  1
  
  2
  
  3
  
  9
  
  10

  is it possible to have like this:

  01
  
  02
  
  03
  
  10

• 

  aastha.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 31 July 2023, 7:53 pm EST

  Hi Patrik,

  You can change the labels of row headers having single digit as shown in the following lines of code:

  for(int i=1; i<=9; i++)
  {
      fpSpread1.Sheets[0].RowHeader.Rows[i-1].Label = "0" + i.ToString();
  }

  Kindly refer to the attached sample for full implementation. See RowHeaderLabel.zip

  Thanks & Regards,
  
  Aastha