Decimal separator in Calc (mac OsX 10.7)

Hi,
in my locale (italian) the default decimal separator is comma (,) both for numeric and currency formats.
In the preference pane I changed numeric separator to point (.) since this setting is a standard in the scientific community and kept the comma (,) for currency.
Unfortunately Calc is not able to seemly accept this setting (…like MSExcel does!)
In fact it seems that in Calc one is “forced” to use locale settings “as a whole” without customizations.
In there a way to work this around?
Thanks.
Andrea

I have the same problem in Portuguese :wink: You can select cells for currency and select menu Format, Cells, tab Numbers, Language Italian (Italy)

The only limitation is that when you type currency values you must not forget to use the comma from the text keyboard instead of the point from the numeric keyboard.

(This works under Windows XP Pro x86, but I assume it should work in a Mac since it is a general configuration)

You need to set Italian (Swiss) as you language in Libre Office.

Hi @Andrea1,

Sounds like you may want to file an enhancement bug and provide as much information about this new feature as possible. Don’t forget to mark your bug as an ‘enhancement’. The QA team will be happy to help you triage your feature request in the bugtracker.

Please post a link to any bugs you file in a comment below using the format “fdo#123456”.

Thanks!