Bug 59239 - Update existing DataValidations formulas
Summary: Update existing DataValidations formulas
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.14-FINAL
Hardware: PC All
: P2 minor (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2016-03-27 10:24 UTC by Damir
Modified: 2016-03-27 11:52 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
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>");