Accounting Format like Excel support

Accounting Format like Excel support

Posted by: nagavardhan on 8 September 2017, 9:59 am EST

• 

  nagavardhan

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 8 September 2017, 9:59 am EST

  Is SpreadJS supports “Accounting Format” like excel do? Please check the attached screenshot.

  Thanks.
  
  

• 

  reeva

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 9:59 am EST

  Hello,

  You can set format of the cells as per your needs as given in documentation link below:-

  http://sphelp.grapecity.com/webhelp/SpreadJSWeb/webframe.html#cellformat.html

  Hope it helps.

  Thanks,
  
  Reeva

• 

  nagavardhan

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 9:59 am EST

  Reeva,

  With accounting format the ‘$’ symbol will go to extreme left in cell. How to that in SpreadJS? Please refer attachment in my question.

  Thanks.

• 

  ginadan

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 9:59 am EST

  I was able to add some spaces with this:

  var dvalue= 123.89;
  
  activeSheet.setValue(0,0,dvalue);
  
  activeSheet.getCell(0, 0).formatter(new GcSpread.Sheets.GeneralFormatter(“$* ##.##”, GcSpread.Sheets.FormatMode.CustomMode));

  SpreadJS does not appear to completely support this format. I have sent this to the developer as an enhancement request.