# Odt template invoice - wrong number formats **URL:** \ **Category:** Using my Dolibarr\ **Created:** [January 16, 2020, 10:02pm UTC](https://www.dolibarr.org/forum/t/odt-template-invoice-wrong-number-formats/18398 "2020-01-16T22:02:55Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![herrdeh](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/h/c2a13f/32.png) [@herrdeh](https://www.dolibarr.org/forum/u/herrdeh)\ **Post date:** [January 16, 2020, 10:02pm UTC](https://www.dolibarr.org/forum/t/odt-template-invoice-wrong-number-formats/18398/1 "2020-01-16T22:02:55Z")
Hello, new to doli I’m struggeling with odt template invoices. After some success, now I have these problems: - I defined invoice numbers as RE {yy}-{0000} - but always get just the figure - “4” (instead of "RE 20-0004 - my invoice sums show up without decimal digits - “20” instead of “20,00” - decimal separator is . instead of , - as it’s in the German localisation This looks like a problem which may be interconnected… - Thanks lot in advance, Wolf ---
**Author:** ![ksar](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ksar/32/514_2.png) [@ksar](https://www.dolibarr.org/forum/u/ksar)\ **Post date:** [January 17, 2020, 9:38am UTC](https://www.dolibarr.org/forum/t/odt-template-invoice-wrong-number-formats/18398/2 "2020-01-17T09:38:10Z")
HI, Normally, to solve point 2 & 3, you need to use the tag xxx\_local, instead of the normal one. For exemple the total invoice, instead of using > {object\_total\_ttc} use > {object\_total\_ttc\_locale} ---
**Author:** ![herrdeh](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/h/c2a13f/32.png) [@herrdeh](https://www.dolibarr.org/forum/u/herrdeh)\ **Post date:** [January 17, 2020, 3:48pm UTC](https://www.dolibarr.org/forum/t/odt-template-invoice-wrong-number-formats/18398/3 "2020-01-17T15:48:58Z")
Yesss, this works. Great! But some explanation in the wiki page… - just to have mention it and to be a little more verbose. Cheers, Wolf ---
**Author:** ![JimDoliFan](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/j/ebca7d/32.png) [@JimDoliFan](https://www.dolibarr.org/forum/u/JimDoliFan)\ **Post date:** [February 7, 2021, 12:53pm UTC](https://www.dolibarr.org/forum/t/odt-template-invoice-wrong-number-formats/18398/4 "2021-02-07T12:53:48Z")
Hello The locale {object\_total\_ttc\_locale} tag works, but if over 999,99 the number printed is in the format N(space)NNN,NN, so as an example, the number is printed as 1 000,00 instead of 1000,00 This is not a problem until one need that number as simple text, but if one want to have that number printed in a table cell to be used for further calculations in the ODT template that becomes a odd problem. In writer in both libreoffice or openoffice the amount of oprations that can be done in a cell ina table are limite, I could not find a way to automatically tell libreoffice to read that cell and removethe space between the number digits. Best solution for this problem is to have dolibarr output the number without spaces in it, so 1945,50 and not 1(space)945,50 I searched for a switch or other configuration option to change this behaviour, but so far I could not find it. Is there a way to tell to Dolibarr to print numbers without paces in ODT templates? Of course I could dig and find where to change something to have printed without spaces, but each time that I update dolibarr then I should go to modify that file(s) all over again, that is not a good idea. Thank you Best regards ---
**Author:** ![ksar](https://www.dolibarr.org/forum/user_avatar/www.dolibarr.org/ksar/32/514_2.png) [@ksar](https://www.dolibarr.org/forum/u/ksar)\ **Post date:** [February 7, 2021, 1:39pm UTC](https://www.dolibarr.org/forum/t/odt-template-invoice-wrong-number-formats/18398/5 "2021-02-07T13:39:35Z")
Hi, if you want only digital use {object\_total\_ttc} ---
**Author:** ![JimDoliFan](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/j/ebca7d/32.png) [@JimDoliFan](https://www.dolibarr.org/forum/u/JimDoliFan)\ **Post date:** [February 7, 2021, 3:31pm UTC](https://www.dolibarr.org/forum/t/odt-template-invoice-wrong-number-formats/18398/6 "2021-02-07T15:31:37Z")
Hi Ksar Thank you That solves the problem of the space, but introduces another problem which is the dot insted of the comma. So I do get e.g. 1000.00 instead of 1000,00 , this solution thus is OK only in countries where they use the dot for the decimals (or for documents created for those countries/languages) I tried to overcome this in libreoffice writer, but seems that therei sno way to circumvent the problem. Is in Dolibarr available any way to precisely define the desired format for locale number format or maybe have the comma instread of the dot for the {object\_total\_ttc} output? Thank you J ---
**Author:** ![JimDoliFan](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/j/ebca7d/32.png) [@JimDoliFan](https://www.dolibarr.org/forum/u/JimDoliFan)\ **Post date:** [February 7, 2021, 9:56pm UTC](https://www.dolibarr.org/forum/t/odt-template-invoice-wrong-number-formats/18398/7 "2021-02-07T21:56:39Z")
Hello I solved it changing the translation of the string SeparatorThousands, by default in my locale was set to “space”, I changed it to . and that allowed me to get the datum in a form that is readable as number by libreoffice writer. Thank you Bye