localization: thousands and decimal separators #2563

New Issue

2018-09-24T10:04:06Z

Dfred commented

2018-09-24 10:04:06 +00:00

(Migrated from github.com)

SSF seems to only support English-based number formatting.
Some foreign-language requires numbers to be formatted inverting thousands and decimal separators, such as French:
1234.56 would be displayed as : 1 234,56
SSF demo fails to format numbers using a French formatCode (e.g: # ##0,00) whereas Excel has no problem with it.

In effect ssf.md mentions localization for dates and currency, but nothing about it with numbers.
Am I missing something or is that limitation by design?

SSF seems to only support English-based number formatting. Some foreign-language requires numbers to be formatted inverting thousands and decimal separators, such as French: `1234.56` would be displayed as : `1 234,56` SSF demo fails to format numbers using a French formatCode (e.g: `# ##0,00`) whereas Excel has no problem with it. In effect [ssf.md](https://github.com/SheetJS/ssf/blob/master/ssf.md) mentions localization for dates and currency, but nothing about it with numbers. Am I missing something or is that limitation by design?

Sign in to join this conversation.