If i have row with cells containing data validation list constraint which source range is defined in the same sheet, calling sheet.shiftRows doesn't updates constraint source range automatically, and manually updating formulas with following code doesn't work:
List<? extends DataValidation> dataValidations = sheet.getDataValidations();
for (DataValidation v : dataValidations) {
DataValidationConstraint validationConstraint = v.getValidationConstraint();
validationConstraint.setFormula1("<new formula>");
}
If i have row with cells containing data validation list constraint which source range is defined in the same sheet, calling sheet.shiftRows doesn't updates constraint source range automatically, and manually updating formulas with following code doesn't work: List<? extends DataValidation> dataValidations = sheet.getDataValidations(); for (DataValidation v : dataValidations) { DataValidationConstraint validationConstraint = v.getValidationConstraint(); validationConstraint.setFormula1("<new formula>"); }