Skip to Content
Menú
This question has been flagged
1 Respondre
7616 Vistes

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)

Avatar
Descartar

Hi 

Did you please find solution to this issue I have the same?

Best Answer

Hi Fazil 

Try this 

cell_format = workbook.add_format({'align': 'center','font_size': 12,'bold': True,'border': 2})

head = workbook.add_format({'align': 'center', 'bold': True,'font_size':16,'border': 2})

col_head = workbook.add_format({'align': 'center', 'font_size': 11, 'bold': True,'border': 2})

col_bot = workbook.add_format({'font_size': 11, 'bold': True})

txt = workbook.add_format({'align': 'center', 'font_size': 10,'border': 2})


Regards 


Avatar
Descartar
Related Posts Respostes Vistes Activitat
2
de març 15
9820
2
de juny 25
2679
4
d’ag. 24
77268
1
d’abr. 22
1541
0
de gen. 22
2026