Use dot as thousands separator for integer value in Qweb reports

Question

Dear all,
I am using Odoo 12 and have a report that shows integer values without thousands separator. For instance: 1000.
What I need to do is to show this value with the thousands separator, like: 1.000 (using "." - dot)
I was able to do it for "," as the separator, but not the "." (dot), and I really need the "." - dot as the separator.
For the "," I have used (achieved 1,000):
<t t-esc="'{0:,.0f}'.format(int(line['my_value']))" Can anyone help me achieve the same result with the "." (dot) tho

Paulo Matos · Accepted Answer

Dear all,
For those having the same problem, I have found a solution for Odoo 12 and qweb reports.
I just had to use ".replace(',', '.')"" on the code above, replacing the "," for the ".".
With "replace", we can use anything we need as a thousand separator, like  a space for instance, " " (1 000).
So the final code I have used is:
<t t-esc="'{0:,.0f}'.format(int(line['my_value'])).replace(',', '.')" /> Thank you once again
Best regards
Paulo

Lars Aam · Answer

Or you find the settings for 1000 separator in the setting for language.

المنشورات ذات الصلة	الردود	أدوات العرض
Company Logos not shown in qweb reports generated in batch and send by email schedule_task qweb-report Odoo12.0	0 سبتمبر 21	2779
Custom Dashboard using js Odoo12.0	1 أبريل 25	3437
How to Limit Pos Category in Odoo 12 Shop? Odoo12.0	0 مارس 24	1285
How to create a report with a custom chart and use the chart in the QWEB report? qweb-report	0 يناير 24	1535
Curious to know how the same variable show different values under the same loop in Qweb. qweb-report	0 يناير 24	1234

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!