https://bz.apache.org/bugzilla/show_bug.cgi?id=59239
Bug ID: 59239
Summary: Update existing DataValidations formulas
Product: POI
Version: 3.14-FINAL
Hardware: PC
Status: NEW
Severity: minor
Priority: P2
Component: HSSF
Assignee: [email protected]
Reporter: [email protected]
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>");
}
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
