Ask Your Question

How to setup default decimal value for currency? [closed]

asked 2020-04-01 07:44:44 +0200

PhamHoangLong gravatar image

updated 2020-04-03 10:46:20 +0200

Hi everyone,

In Libreoffice calc, When i'm using currency format, my currency (VND) always had 2 digits decimal, While my currency didn't use it (VND) anymore. So each time i'm using (Ctrl+Shift+4) to format my currency, i need to remove that decimal.

are there any ways to make it default ?

P/s : I have changed windows 10 language setting, included currency and number format to match VND currency format.

Sorry for my bad english.



This problem has been fixed :

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by PhamHoangLong
close date 2020-04-03 00:37:36.132669


Which currency in what country is that? The default currency format is taken from locale data, if that says the currency has 2 decimals then that is used in currency formats. Maybe the locale data is outdated or faulty.

erAck gravatar imageerAck ( 2020-04-01 18:45:15 +0200 )edit

My Locale is vietnam, and i have changed the locale setting in my windows 10, included number and currency format to match decimal of VND. But in Libreoffice, i can't understand that why it's still use decimal?

PhamHoangLong gravatar imagePhamHoangLong ( 2020-04-01 23:53:27 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-04-02 17:58:08 +0200

erAck gravatar image

LibreOffice for its cross-platform nature comes with its own locale data, in which the vi-VN locale for VND (added in 2005) has 2 decimal places. That is congruent with that lists 1/10 hào and 1/100 xu, but also says "both subunits have been unused in Vietnam for several years".

The vi-VN locale data needs an update for the next release.

edit flag offensive delete link more


I created tdf#131829 for this.

erAck gravatar imageerAck ( 2020-04-02 18:11:39 +0200 )edit

Question Tools

1 follower


Asked: 2020-04-01 07:44:44 +0200

Seen: 90 times

Last updated: Apr 03