Flexsheet shows different cell format from Excel

Flexsheet shows different cell format from Excel

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

• 

  kris

  • Post Options:
  • Link
    Copy

  Posted 27 November 2020, 12:57 am EST - Updated 3 October 2022, 5:48 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.

  

  770×597 31.5 KB

  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.

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 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

• 

  kris

  • Post Options:
  • Link
    Copy

  Posted 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

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 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

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 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

• 

  kris

  • Post Options:
  • Link
    Copy

  Posted 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.

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 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