İçereği Atla
Menü
Bu soru işaretlendi
1 Cevapla
7866 Görünümler

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
Vazgeç

Hi 

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

En İyi Yanıt

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
Vazgeç
İlgili Gönderiler Cevaplar Görünümler Aktivite
2
Mar 15
10054
2
Haz 25
3037
4
Ağu 24
78829
1
Nis 22
1728
0
Oca 22
2273