search

theorchard / openpyxl

Other
58 stars 21 forks source link

DataValidation showDropDown not working #33

Open ana-stankovic opened 1 year ago

ana-stankovic commented 1 year ago

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 commented 9 months ago

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

ana-stankovic commented 9 months ago

This is amazing, it actually works xD