Excel sheet format issue

Excel sheet format issue

Posted by: shubham on 15 September 2021, 5:12 am EST

• 

  shubham

  • Post Options:
  • Link
    Copy

  Posted 15 September 2021, 5:12 am EST

  Hi Team,

  Please find the attached exported xlsx sample report. As you can see, on the number field it’s showing a warning msg - “this cell is formatted as a text or preceded as apostrope”.

  Please let me know if you have a solution, how we can remove the warning msg or convert the cell into a number.

  Thanks,
  
  Shubhamreport.zip

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 21 September 2021, 2:17 am EST

  Hello,

  Can you try to set the Format property of TextBox to avoid this issue.

  Thanks,
  
  Mohit

• 

  shubham

  • Post Options:
  • Link
    Copy

  Posted 21 September 2021, 2:21 am EST

  I have already tried all possible options of Format property.
  
  Thanks

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 22 September 2021, 3:02 am EST

  Hello,

  I have forwarded this case to the development team(ARJ-3730) and will inform you once I have any update from them.

  Thanks,
  
  Mohit