Unmerged cells are still considered merged and cannot be written

Created originally on Bitbucket by DKhalaan (Guillaume)

When writing into a cell that used to belong to a merged cell, the application throws an error: AttributeError: 'MergedCell' object attribute 'value' is read-only

Sample Excel file contains a unique merged cell [A1:B2]

Error is displayed when the script tries to write into the previously merge cell 'B2' Worksheet.unmerge_cells(start_row=1, start_column=1, end_row=2, end_column=2) Worksheet.cell(2,2).value = "TOTO"

It seems that openpyxl still consider the cells as part of a merged cell.

Attachments: extract.py testUnmerge.xlsx

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information