Ask Your Question
0

Decimal separator in Calc (mac OsX 10.7)

asked 2012-05-05 11:27:27 +0200

Andrea gravatar image Andrea flag of Italy
1 2 1

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

delete close flag offensive retag edit

3 Answers

Sort by » oldest newest most voted
0

answered 2013-02-22 09:30:51 +0200

qubit gravatar image qubit flag of United States
5721 3 48 41

Hi @Andrea,

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!

link delete flag offensive edit
0

answered 2012-08-25 10:04:44 +0200

lovecraft22 gravatar image lovecraft22
1

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

link delete flag offensive edit
0

answered 2012-05-05 12:36:14 +0200

Pedro gravatar image Pedro flag of Portugal
3218 4 23 54

I have the same problem in Portuguese ;) 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)

link delete flag offensive edit

Login/Signup to Answer

Donate

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!

Question tools

Follow

subscribe to rss feed

Stats

Asked: 2012-05-05 11:27:27 +0200

Seen: 433 times

Last updated: Feb 22