Hot to have different currencies coexisting?

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

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:

€1.234,56
$1,111.11

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

Comments

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 +0200 )edit