When formatting currency in a cell in a table in Writer, there are numerous options in the list. However none of those options is the way we Europeans use it for negative amounts. Most standard options in Writer have the minus at the back, behind the amount.
We don’t do that in The Netherlands, we put the minus before the amount. The convention is to have the euro sign, then the minus, then the amount and in black. I believe most of Europe does it like that. Sometimes the minus is before the €-sign.
Example: € -1.586,75.
Oftentimes when the decimals are both 0 those are abbreviated to a minus. like this:€ 1.586,00 becomes € 1.586,-. As you can see, in Europe it could be confusing if the minus was behind the amount.
The option to have the € and the - before the amount is not available in the standard list and has to be constructed in a custom format every time I want to use it in a new file.
Is there a way to add it to the standard options or some other way I can use it in a template?