DataValidation cell range attribute changed in 2.5.3

Issue #1034 closed
Stefan Marcin
created an issue

Hi, I was using 2.4 version of openpyxl and datavalidation. Datavalidation was used for range of cells.

dv = DataValidation(type="list",formula1="{0}!$A$2:$A$4".format(quote_sheetname('Settings')))
dv.ranges.append('B13:B5000')
ws1.add_data_validation(dv)

Now after I have update to 2.5.3 I get an error AttributeError: 'MultiCellRange' object has no attribute 'append'

I tried documentation and change-log but no evidence of changing this attribute. Any help will be appreciated. Thanks.

Comments (4)

  1. Log in to comment