Translate data report xlsx Odoo v11.0

Question

I am using module "Base report xlsx" and xlsxwriter to write a report xlsx. But i have a problem about translate data. I alr use _() method and translate it in my language (vi.po -vietnamese) like:
title_line_format = workbook.add_format({'bold': True, 'font_size': 20, 'align': 'center'})
data = _("Procurement List Report")
sheet.merge_range('A1:N3', data, title_line_format)
But when i export, my file still be written by english . Am i wrong? Can anyone explain why it didin't work?
Thanks and Re

Nomadic Coding · Accepted Answer

It seems the lang context is lost when using report_xlsx
You can force the language on the report.py

e.g.
def  generate_xlsx_report ( self , workbook , data ,  products ):
#force language
self = self .with_context( lang = self .env.user.lang)

Verknüpfte Beiträge	Antworten	Ansichten
Translations for the top menu URL's translation	0 Dez. 24	1441
downloading the po file translation	2 Feb. 24	2959
Language translation through .po file translation	4 Nov. 23	3397
Unable to change Javascript translation translation	1 Aug. 22	3706
Change default location in update quantity on hand window Gelöst odoov11	2 Juli 22	9182

Diese Frage wurde gekennzeichnet

Diskutieren Sie gerne? Treten Sie bei, statt nur zu lesen!