Bug 59239

Summary: Update existing DataValidations formulas
Product: POI Reporter: Damir <db43974>
Component: HSSFAssignee: POI Developers List <dev>
Status: NEW ---    
Severity: minor    
Priority: P2    
Version: 3.14-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: All   

Description Damir 2016-03-27 10:24:31 UTC
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>");
}