Minor correction to DataValidation usage documentation

Issue #211 resolved
created an issue

DataValidation usage documentation has a small error: ValidationType.LIST needs list choices passed into 'formula1' argument. If passed as an unnamed argument it goes into the 'operator' argument (and doesn't work).

In openpyxl / doc / source / usage.rst lines 106-107:

# Create a data-validation object with list validation
dv = DataValidation(ValidationType.LIST, '"Dog,Cat,Bat"', allow_blank=True)

107 should be:

dv = DataValidation(ValidationType.LIST, formula1='"Dog,Cat,Bat"', allow_blank=True)

Comments (2)

  1. Log in to comment