final int rngLastRow = range.getLastRow();
final int rngLastCol = range.getLastColumn();
final List<? extends DataValidation> dataValidations = BookHelper.getDataValidations(srcSheet);
for(DataValidation dataValidation : dataValidations) {
CellRangeAddressList addrList = dataValidation.getRegions();
for(int j = addrList.countRanges(); --j >= 0;) {
final CellRangeAddress addr = addrList.getCellRangeAddress(j);
if (addr.isInRange(rngRow, rngCol, rngLastRow, rngLastCol)) {
//TODO: not fully mimic the scenario as excel
//have to remove the whole data validation first
range.getSheet().removeValidationData(dataValidation);
return;