You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2016/03/27 12:24:31 UTC

[Bug 59239] New: Update existing DataValidations formulas

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: dev@poi.apache.org
          Reporter: db43974@gmail.com

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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 59239] Update existing DataValidations formulas

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59239

Dominik Stadler <do...@gmx.at> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|                            |All

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org