Can you add a new currency in libreoffice calc?

asked 2018-09-15 12:48:05 +0100

Anya492 gravatar image


I'm from Mauritius and I wanted to add my country's currency in libreoffice calc so that I can manage my finance more accurately.

Can I do that?

The currency here is the mauritian rupee. Approx: $1 = Rs 34.50


edit retag flag offensive close merge delete



What do you mean by "adding" a currency? a currency is actually only a decoration in a cell. Internally, it's just a number. You may create a dedicated format string like 0.00 " Rs" to use with money (if mentioning currency in column header isn't enough). If you want support of the locale using this currency in LibreOffice, file a bug report.

Mike Kaganski gravatar imageMike Kaganski ( 2018-09-15 13:04:01 +0100 )edit

Ok thank you for your help. I'll use format string then. It's just that now I need to add a formula to convert it to US $ or Euros, which is pretty damn complicated for me. Oh well, thx anyway.

Anya492 gravatar imageAnya492 ( 2018-09-19 09:00:02 +0100 )edit