Spreadjs verision "14.0.4" work with Reactjs Set default formatter Currency

Spreadjs verision "14.0.4" work with Reactjs Set default formatter Currency

Posted by: phamnhantong on 12 January 2023, 6:37 am EST

• 

  phamnhantong

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 12 January 2023, 6:37 am EST

  Dear support team,

  I would like to set default formatter for cell (Currency or Percentage) I have tried a lot of format but in the UI always show Custom like below:
  
  https://freeimage.host/i/HYz1Bvn
  
  Expected:
  
  https://freeimage.host/i/HYz1MGV
  
  sheet.getCell(headerIndex, col).formatter(“some value”)
  
  some value like: “0.0%” or “$0.0” but it not working for me.
  
  Please help me in that case. Thank a lot!

  Regards,
  
  Light

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 13 January 2023, 8:04 am EST

  Hi Light,

  The mentioned issue has been fixed in the latest version of SpreadJS. Please upgrade to the latest version of SpreadJS.

  You can test it out on the hosted SpreadJS Designer: https://www.grapecity.com/spreadjs/designer/index.html

  Download SpreadJS V16.0.2(Latest version): http://cdn.grapecity.com/spreadjs/16.0.2/Files/SpreadJS.Release.16.0.2.zip

  Please try with the latest version and let us know if you face any issues.

  Regards,
  
  Ankit