excel4node icon indicating copy to clipboard operation
excel4node copied to clipboard

Published 20 hours ago • verified publisher icon natergj

DataValidation on a partial column doesn't work

Open SferaDev opened this issue 6 years ago • 2 comments

DataValidation with sqref "A3:A" produces a corrupt excel.

It works though when using sqref "A3:A5" or "A:A".

SferaDev avatar Oct 11 '18 14:10 SferaDev

"A3:A" is not a valid sqref. If you do want to add data validations starting at one row and applied to all following rows, you'll need to specify the exact range "A3:A1048576". Excel has a limitation of 1,048,576 rows, so this should accomplish what you are trying to do.

natergj avatar Oct 19 '18 12:10 natergj

Okey, anyway it shouldn't produce a corrupt excel file, right?

SferaDev avatar Oct 20 '18 16:10 SferaDev