i've created an xls report in odoo 13 and all of its styles are working well in ubuntu excel, but all of the styles are not working in windows excel sheet.
the code is given below;
cell_format = workbook.add_format({'align': 'center','font_size': '12px','bold': True,'border': 2})
head = workbook.add_format({'align': 'center', 'bold': True,'font_size':'16px','border': 2})
col_head = workbook.add_format({'align': 'center', 'font_size': '11px', 'bold': True,'border': 2})
col_bot = workbook.add_format({'font_size': '11px', 'bold': True})
txt = workbook.add_format({'align': 'center', 'font_size': '10px','border': 2})
sheet.merge_range('B2:K3', 'METAL INDUSTRIES', head)
monthinteger = int(data['month'])
month = date(int(data['year']), monthinteger, 1).strftime('%B')
sheet.merge_range('E4:H4', "SALARY"+ "-" + month + "-" + data['year'],cell_format)
sheet.write('A6', 'S.No:', col_head)
sheet.write('B6', 'EMPLOYEE NAME', col_head)
Hi
Did you please find solution to this issue I have the same?