This question has been flagged
1 Reply
4094 Views
translationxls_reportsodoov11
Avatar
Minh Nguyen

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 Regards,

Minh


Avatar
Discard
Avatar
Nomadic Coding
Best 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)
Avatar
Discard