Number formatter which was selected in ribbon

Number formatter which was selected in ribbon

Posted by: nhan.thanh.nguyen on 21 February 2023, 12:54 am EST

• 

  nhan.thanh.nguyen

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 21 February 2023, 12:54 am EST - Updated 21 February 2023, 1:00 am EST

  How can I get a default format type to be a number (With separator and negative setting) for the cell in spreadjs
  
  

  

  998×628 22.2 KB

  
  
  

  

  791×751 19.1 KB

  

  998×628 22.2 KB

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 22 February 2023, 12:53 am EST - Updated 22 February 2023, 12:59 am EST

  Dear Nhan,

  It appears that you would like to apply a specific format to a number, which includes a separator and a negative setting, as depicted in the image you provided. If this is the case, the code snippet below can be used to add the desired format to a range of cells:

  sheet.getRange(1, 1, 5, 5).formatter("#,##0.00_);(#,##0.00)");

  Sample: https://jscodemine.grapecity.com/share/FUq3Y4eB5UK0UxwFc1ArBg/?defaultOpen={"OpenedFileName"%3A["%2Findex.html"%2C"%2Fpackage.json"%2C"%2Fsrc%2Fapp.js"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.js"}

  Please note that the formatter method, as referenced in the code snippet, can be found at the following link: https://www.grapecity.com/spreadjs/api/classes/GC.Spread.Sheets.CellRange#formatter.

  Additionally, the Formatting Demo provided at this link: https://www.grapecity.com/spreadjs/demos/features/cells/formatter/basic-formatter/purejs may also be helpful in understanding the formatting options available.

  If you have a different use case or require further assistance with this query, please let us know. We are more than happy to assist you.

  Best regards,

  Ankit

  

• 

  nhan.thanh.nguyen

  • Post Options:
  • Link
    Copy

  Posted 22 February 2023, 2:38 am EST

  Hi Mr. Ankit,
  
  Thank you very much for your support, your solution has already solved my case.

  Thanks and Best Regards,
  
  Nhan Nguyen