Auto Comma formattting for Number On Unbound Grid

Auto Comma formattting for Number On Unbound Grid

Posted by: ryan on 1 April 2026, 2:17 pm EST

• 

  ryan

  • Post Options:
  • Link
    Copy

  Posted 1 April 2026, 2:17 pm EST

  Hello, I am using Wijmo’s Unbound Grid and when I purposefully leave the cells as numbers there is an extremely inconsistent comma formatting only applied to numbers with decimals and not to integers. I need to leave them as Numbers in order for the exported data to have cell number types and the added commas are messing up our CSV files. We have a setting to turn them into strings and add custom formatting but we really need the unformatted cells to be displayed/exported/copied without commas.

  "@grapecity/wijmo.angular2.all": "^5.20251.40",
  "@grapecity/wijmo.angular2.input": "^5.20251.40",
  "@grapecity/wijmo.grid": "^5.20251.40",
  "@grapecity/wijmo.undo": "^5.20251.40",
  

  Thank you,
  
  Jackson

• 

  vivek.pannu

  

  • Post Options:
  • Link
    Copy

  Posted 2 April 2026, 2:56 am EST

  Hi Jackson,
  
  We are assuming that you are using the FlexSheet control. You can set the format property on the required columns in the flexSheet to avoid this issue. You can try setting the column format to ‘g5’, which will remove the commas from the numbers and allow up to 5 decimal digits to be displayed in the number. You can increase the decimal limit as per your needs, like ‘g7’ or ‘g9’, etc.
  
  Please refer to the following sample demonstrating the same - https://jscodemine.mescius.io/share/kbx-ZDLK_UmRDuw8OteLYg/
  
  In case, you still face any issues, or if there is something we missed, please let us know.
  
  Regards