DataValidation type='cellRange'?
Created originally on Bitbucket by wardi (Ian Ward)
I'd like to generate spreadsheets with cells validated against a cell range. Validation against a static list works (as shown in the docs) but I've got a really long list of values to check against.
I've tried adding 'cellRange'
to the list of accepted DataValidation type values in openpyxl and enter the cell range into formula1
. This seems like it almost works: When I open the file in Libreoffice, open the data validation window on the cell and switch "Allow: All Values" to "Allow: Cell Range" my cell range appears in the box and then works properly.
Is 'cellRange'
just not the right string to use or is making the cell range validation work more complicated than I hoped?