Excel sheet format issue

Posted by: shubham on 14 September 2021, 8:12 pm EST

  • Posted 14 September 2021, 8:12 pm 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.
    [url][/url]
    Thanks,
    Shubhamreport.zip
  • Replied 20 September 2021, 5:17 pm EST

    Hello,

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

    Thanks,
    Mohit
  • Replied 20 September 2021, 5:21 pm EST

    I have already tried all possible options of Format property.
    Thanks
  • Replied 21 September 2021, 6:02 pm 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
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels