dtjohnson / xlsx-populate

Excel XLSX parser/generator written in JavaScript with Node.js and browser support, jQuery/d3-style method chaining, encryption, and a focus on keeping existing workbook features and styles in tact.
MIT License
955 stars 182 forks source link

Exported number format with commas appears as dots #332

Open romucci opened 2 years ago

romucci commented 2 years ago

When using the numberFormat '#,###', the result export gets transformed to '.'

Example:

30000 should be exported as '30,000' and gets exported as '30.000'

ryansalatti commented 2 years ago

Seems like it could be unrelated to this package. I would double check in excel File -> Options -> Advanced and then under "Editing options" there's a setting called "Use system separators", make sure that is set with commas for the Thousands separator and dots for the decimal separator. Excel system separators are globally stored in your document preferences.