Flexsheet shows different cell format from Excel

Posted by: kris on 27 November 2020, 12:57 am EST

  • Posted 27 November 2020, 12:57 am EST

    Hi,

    I am trying to use Flexsheet to load an excel file, it appears showing different cell formats then open it via Excel, cell B12 shuold be a percentage and B13 should be a currency when open the file in Excel, while it shows only the numbers when I load it in your Flexsheet react demo.



    These 2 cells are formula cells, attach is my test file, I am wondering if there is a way can make it exactly same behavior like in Excel?

    Cheers.
  • Replied 30 November 2020, 9:23 pm EST

    Hi Kris,

    Can you please reattach the test excel file so that we can investigate the issue? It seems that the file is not attached.

    Regards,
    Ashwin
  • Replied 1 December 2020, 9:18 am EST

    Hi Ashwin,

    Thanks for looking into this, just realized only zip file is allowed, here is the file.

    test_file.xlsx.zip

    Regards,
    Kris
  • Replied 2 December 2020, 6:23 pm EST

    Hello Kris,

    Thank you for the excel file. I was able to replicate this and have forwarded the issue to the developers with internal tracking id 469631. I will update you once this issue is fixed.

    ~regards
  • Replied 14 January 2021, 7:23 pm EST

    Hi Kris,

    Sorry for the delay in response.

    There is some issue with your excel file which is why the formatting issue occurs in FlexSheet.

    The reason is that cells B6, O15, and O16 do not store numbers, but strings, and if you open the file in an environment with a non-EN locale, the formulas in cells B12 and B13 will produce errors because of the decimal point separator.

    ~regards
  • Replied 17 January 2021, 9:57 am EST

    Thanks Ashwin for the response, is there a workaround for this? for example set the default locale to EN etc.
  • Replied 18 January 2021, 12:40 am EST

    Hi kris,

    I am attaching the updated test_xlsx file. In the cell B6, O15, and O16, I have resolved the errors by converting these cells to numbers instead of a string. Now, if you will import this file to FlexSheet, the format will be correctly displayed.

    ~regards

    test_file_updated.zip
Need extra support?

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

Learn More

Forum Channels