Default currency per worksheet

Is there such a feature in LibreOffice Calc: Default currency for all money cells in Worksheet?

If yes, then:

A) how to set default currency for cells with money format?

If no then:

B) could you add this functionality to software?


Many people work in international companies, where some reports should be with different currency.
Sometimes there is only one currency per sheet.
It gets quite long time to set appropriate currency format for all cells in worksheet.

Direct formatting is evil - with very few exceptions.

You can e.g. select a column or an entire spreadsheet.

Then choose Format > Cells...

In the “Format Cells” dialog box, select Currency and the desired format (e.g. “USD $ English (USA)” or others.

Is that what you are looking for?


Once you’ve formatted a spreadsheet, you can save it as a document template. When you open the document template you always have your settings.


If my answer has solved your problem, please click on the checkmark in the circle Bildbeschreibung to the left of the answer for upvote. This will tell the community that the question has been answered correctly.

With me Windows 10 Home; Version 1909; 64-Bit | LibreOffice, Version: (x64).