DataValidation showDropDown not working

[ana-stankovic]

I am using pandas and openpyxl to generate a excell sheet. Everything works except:

validation = DataValidation(
    type="list",
    formula1='"Keep,Delete,Production"',
    allow_blank=True,
    showDropDown=True
)

Validation to the cells is added, but the dropdown is not shown and it has to be added manually.

[alexcolemandata]

This caught me out a while ago, you have to set showDropDown=False to get the dropdown to show

[ana-stankovic]

This is amazing, it actually works xD