Decimal separator according to locale

[budda85]

For tracking I open another ticket here, even if I have already written in December with Alwin.
Maybe someone else has a suitable solution.

If you want to create invoices and then offset the amounts with VAT via Libreoffice, it unfortunately no longer works. 2021 it worked once.
This is due to the decimal separator. If you want to calculate the values by formulas in Libreoffice, wrong values come out, because OO outputs a point as decimal separator.

In Germany we use the comma as decimal separator.
All my attempts to set Libreoffice to English or Swiss to work around the problem have failed.
Alwin had already reproduced the problem with himself if I understood it correctly.
The problem is, as far as I have found out, with the server container. Here it doesn't help if I set the appropriate "locale".

My Linux server and e.g. the pdf-tools container convert the dot to a comma. The server container unfortunately does not

However, the server container is missing the matching locale as I see it.

Here it would be nice if there is a solution so that you can use the invoicing and I don't have to go the detour via a mail merge.

[budda85]

Is there anything new here?
We have to create invoices for this year.

[mcmpp]

Hi @budda85 ,

I am having a look at this right now. I would like to have more information about it.

• Can you explain me more about your workflow: it seems that your template adds the TVA. Every invoice has the same percentage?
• could I have the template that you are using for the invoice?
• Is this issue only reflected while creating the invoices?

[budda85]

Hi @mcmpp

• You had to translate TVA for me, that I don't know. :-) We have two percentages. Once 7% and once 19%. But the problem occurs with both values.
• The template which I used is this one here, I have also tried a new one. Alwin has also created a template which also does not work. See this file: Rechnungsvorlage-neu_Alwin2.odt
• Elsewhere, I have not encountered the problem until now. However, we used the tax calculation only in the invoices.

[budda85]

Hey @mcmpp is that for me? :-D
https://github.com/OpenOlitor/openolitor-server/releases/tag/2.6.23_test

[mcmpp]

Yes, it was but I am not sure this will change anything... you can try and let me know .