Add config option for number format in excel export (decimal separator)

[mauthi]

This is a feature request.

Prerequisites

• Are you running the latest version?
• Are you reporting to the correct repository?
• Did you check the documentation?
• Did you perform a cursory search?

Description

It would be nice to get a config option to set the decimal separator for excel export.
At the moment it's "." (dot) and if comma is used in local settings the numbers are rendered as date in excel.

[mauthi]

Any update here? Maybe you give me a small advice where this can be done and I will try it.

[aocneanu]

@mauthi with the latest version (pushed now) we improves numbers handling.

We will deprecate money soon.

Using number instead of money will allow formatting numbers using user's locale.

the current supported attrs for the number object are:

"number": {
    "precision": 2,
    "symbol": "pcs",
    "template": "%s %v"
}

@gandesc please update the docs.

@vmcvlad, @raftx24. @GITmanuela fyi

[mauthi]

I just tested this - looks fine. Thx.

[mauthi]

Question: Is the same improvement for forms also done or is this replacement of money with number only done for tables?

[aocneanu]

it's only for tables, but would be a good addition for forms as well. Feel free to do a PR ;)