Merged Cell's formatting is lost when 'update' the file

Issue #400 duplicate
Jianjun Ma created an issue

openpyxl version:2.1.4

ori.png

=>

updated.png

##-------------------------------

import openpyxl
xls_book = openpyxl.load_workbook(filename='test01.xlsx')
sheet_names = xls_book.get_sheet_names()
xls_sheet = xls_book.get_sheet_by_name(sheet_names[0])
xls_sheet["B2"] = 0.52
xls_sheet["C3"] = 0.756
xls_book.save('test02.xlsx')

Comments (3)

  1. Log in to comment