Skip to Content
This question has been flagged
exportdateformatfloat_timeOdoo13
2 Replies
6127 Views
Avatar
Prakash 
odoo 13 change date format overridden controllers below class and init method,
Changes not reflected.


 from odoo.addons.web.controllers.main import ExportXlsxWriter


class ExportXlsxWriter(ExportXlsxWriter):

    def __init__(self, fields, row_count=0):
        super(ExportXlsxWriter, self).__init__(fields, row_count=row_count)
        self.date_style = self.workbook.add_format({'text_wrap': True, 'num_format': 'mm-dd-yyyy'})

Odoo old to new all versions export date format change or set in user interface feature not available.
Is any custom module available export data date format and float_time widget change from user interface? or any plan to add this feature in the latest odoo 14 version.
Avatar
Discard
Julia van Orsouw - van Lankvelt

I experience the exact same problem. Why is this format fixed and not aligned with user settings for language in Odoo or Excel ?

Avatar
Serhii Sorokin
Best Answer 
def __myinit__(self, field_names, row_count=0):
    self.field_names = field_names
    self.output = io.BytesIO()
    ...

ExportXlsxWriter.__init__ = __myinit__


Avatar
Discard
Avatar
Moaaz Gafar Ahmed
Best Answer 
just add format_date(self.env,date),'num_format': 'dd-mm-yyyy'},


Avatar
Discard
Related Posts Replies Views Activity
how can we change date view format from dd/mm/yyyy to mm/dd/yyyy Solved
date format
Avatar
Avatar
Avatar
Avatar
4
Aug 24
74829
Date format in Dashboard Solved
date format dashboard
Avatar
Avatar
2
Oct 24
1002
How to change display of a specific datetime field in a different format on list and form view?
date format datetime
Avatar
0
Oct 23
2133
Odoo 16 email template date format
date format odoo16features
Avatar
Avatar
2
Oct 23
1974
Date format not changing on follow up reports
date format reporting
Avatar
0
Sep 23
938