Posted 25 October 2021, 12:31 pm EST
I would like to prepare SpreadJS sheets that could be distributed to several countries and would display, in each country, numbers in correct format according to user’s region. It means, it will use display
123 456,78 € in Germany,
123’456.78 CHF in Switzerland and, say
123,456.75 £ in GB.
The formats are defined by system and can be read from it. I would like to avoid necessity to define specific report for each country. I checked it and, when I define format “###'##0.00” it will display correct format in Switzerland, but this in my case would not work.
I can run a script before displaying report, so I could run script that would loop through all cells, read in format and map it to proper region’s format, but it seems to me that there should (and probably is) a way how to tell SpreadJS to use current region’s formatting.
