Number formatting issue when converting from excel

Number formatting issue when converting from excel

Posted by: ablsoft on 27 May 2020, 8:12 pm EST

• 

  ablsoft

  • Post Options:
  • Link
    Copy

  Posted 27 May 2020, 8:12 pm EST

  Hi Support,

  We have a document in excel where a cell has a percentage format with 6 decimal points. After converting it to spreadjs with GC.Spread.Excel.IO, if we enter a value like

  81.999999

  , spreadjs formats it to```
  
  8199.999900%

  
  Please find attached a zip file with a sample document, a video and a sample application so you can see and replicate the issue.
  
  Thanks!
  
  [zip filename="Archive.zip"]https://gccontent.blob.core.windows.net/forum-uploads/file-2bdf7329-b20f-4775-aa91-4eee4133eb25.zip[/zip]

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 29 May 2020, 10:25 am EST

  Hi,

  This was the expected behavior before version 13.1.0 and the sample in the zip file is using version 12.2.0. Please refer to the following post for more information:
  
  https://www.grapecity.com/forums/spread-sheets/update-percentage-formatte#hi-davidethe-issue-is-aris

  From version 13.1.0, we have added support to format the percentage cells like excel even in the edit mode. You may refer to the following doc for more details:
  
  https://www.grapecity.com/spreadjs/docs/v13/online/percentage-format-in-cells.html
  
  Please update to the latest build and let us know if the issue persists for you.

  Regards
  
  Sharad