DataValidation - Unable to set attar to show dropdown.
Created originally on Bitbucket by rh0dium (Steven Klass)
Hi there,
Perhaps it's just me but I would like to be able to show the drop down on a list data validation. It appears as though I should be able to set the attr_map to showDropDown:1 and it should work but I'm speculating.
formula = u'"{choices}"'.format(choices=u",".join(item.choices))
attr_map = default_attr_map.copy()
attr_map['showDropDown'] = 1
data_validation = DataValidation(
ValidationType.LIST, formula1=str(formula), allow_blank=True,
attr_map=attr_map)
data_validation.add_cell(self.sheet.cell(item.cell))
Unfortuntatly this is now working :( If I understood where this actually gets tied in I'd whip up the patch as this looks pretty trivial. I'd also figure out a proper way to handle this when "," are in the list of strings..