https://bz.apache.org/bugzilla/show_bug.cgi?id=60870

            Bug ID: 60870
           Summary: [PATCH] in XSSF files getErrorStyle() and
                    setErrorStyle() have mismatching enum values -> #60803
           Product: POI
           Version: 3.15-dev
          Hardware: PC
                OS: Linux
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
          Assignee: [email protected]
          Reporter: [email protected]
  Target Milestone: ---

Created attachment 34834
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=34834&action=edit
file containing diffs between patched class and the original one

the problem is explained in the bug report 60803.

the solution i promote is to use a map into XSSFDataValidation to convert the
Enums, which come from STDataValidation (range 1-3), into the ints exposed in
DataValidation (range 0-2) so getErrorStyle returns values between 0-2.
This adjustment is required when we want to copy the errorstyle of a cell, or a
group of cells, into another one : 

(working example with patch)
    newDataValidation.setErrorStyle(anotherDataValidation.getErrorStyle());


(working example without patch)
    newDataValidation.setErrorStyle(anotherDataValidation.getErrorStyle() - 1);

-- 
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]

Reply via email to