Decimal and thousands separator - the European way

The "Format" tab allows you to change number formatting. If you can't find a preset format that works for you, you should be able to specify your own, using a syntax similar to Excel. Can you please try it and let me know?

I'll take at look at this when I get back from vacation after June 19th. Thanks for your patience!

As many have said it before: thank you very much for this amazing module Infojunkie! :)

Change thousands separator from comma to dot / change decimal separator from dot to comma:
The "Format" tab allows to change number formatting but, even with custom formats it seems you have to use a dot to specify decimal position...

#,##0.00 -> 9,999.90
# ##0.00 -> 9 999.90
# ##0,00 -> 9 99,990
#.##0,00 -> 999990.0,00

Have I missed something?

Related to that: is there a way to change/choose your decimal input format (ie commas taken into account instead of dots when editing a sheet) diretcly in Sheetnode or in combination with another module?

Thanks in advance.

Re #5: I haven't gotten around to testing this, but it looks like a bug in the formatting code.

Regarding your second question, do you mean selecting a *default* decimal format? In that case, no there's isn't but that's a good feature request. Please open a new issue and clearly explain the scenario you have in mind. Thanks!

You need to edit sheetnode/socialcalc/socialcalcconstants.js and change
FormatNumber_separatorchar: "." to "," and
FormatNumber_decimalchar: "," to "."
It worked for me only when viewing the sheet.

Anyway, if I write a number it's formatted by the old rule, I think this might be due the regexp rules in SocialCalc.DetermineValueType function in socialcalc-3.js.

Tagging for next release.

Another change:
else if (ch==",") { // decimal point
to
else if (ch==".") { // decimal point
and
else if (ch==".") {
to
else if (ch==",") {
in formatnumber2.js

Moving to D7 for fixing.

You can change the formatting, but it needs to be done in the library (SocialCalc) rather than in the module.