When loading the workbook that contains cells with multiple conditional formatting conditions, only the last one seems to be loaded.
How to replicate
- Download attached xlsx file that has a cell with 2 conditional formatting conditions.
- Load and save workbook using openpyxl.
Newly saved file has the same conditions as the original.
Newly saved file contains only last condition.
Minimal example that demonstrates the issue
import openpyxl wb = openpyxl.load_workbook("test.xlsx") wb.save("newtest.xlsx")
This same procedure works with latest openpyxl 2.5.x.