Hot to have different currencies coexisting?

asked 2017-12-21 10:44:59 +0100

Mark Jeronimus gravatar image

How can I have multiple currencies in a single sheet, where some use comma/period as separators and others use period/comma as separators?

For example, I want to have them look like this:


I'm currently unable to achieve this as the locale setting and Decimal separator setting appears to be global to libreoffice and not even to a single sheet! It seems to me like a bug that when I select a different currency in Format that the separators of that currency are not respected.

edit retag flag offensive close merge delete


That's a property of cell format; and possibly best served as cell style.

Mike Kaganski gravatar imageMike Kaganski ( 2017-12-21 11:07:58 +0100 )edit