openpyxl 2.6 does not preserve conditional formatting
*Created originally on Bitbucket by [tadeboro (Tadej Borovšak)](https://bitbucket.org/%7B5115b682-a1a2-4c3e-ab20-c99b413b8c9b%7D/)* # Summary # When loading the workbook that contains cells with multiple conditional formatting conditions, only the last one seems to be loaded. # How to replicate # 1. Download attached xlsx file that has a cell with 2 conditional formatting conditions. 2. Load and save workbook using openpyxl. # Expected outcome # Newly saved file has the same conditions as the original. # Actual outcome # Newly saved file contains only last condition. # Minimal example that demonstrates the issue # ``` #!python import openpyxl wb = openpyxl.load_workbook("test.xlsx") wb.save("newtest.xlsx") ``` # Notes # This same procedure works with latest openpyxl 2.5.x. *Attachments:* [test.xlsx](/uploads/c83e085407c49800b8e70905ca7b2732/test.xlsx)
issue