Openpyxl disable {ignore_blank} in all cell validator in Workbook

Created originally on Bitbucket by tgh101

in excel i create a cell validator with ‘ignore Blank’ option checked

wb = load_workbook(filename='DataValidationErrorExample.XLSX')
ws = wb.worksheets[0]
print(ws.data_validations)

it shows all IgnoreBlank as False. and after saving back my workbook, ‘ignore Blank’ option is unchecked for all my validators.

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information