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

            Bug ID: 64750
           Summary: getDataValidations relies on the count attribute being
                    present
           Product: POI
           Version: 4.1.2-FINAL
          Hardware: PC
                OS: All
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
          Assignee: [email protected]
          Reporter: [email protected]
  Target Milestone: ---

This problem was discovered when having problems processing spreadsheets
exported from Google Sheets.

Through some testing, it has been found that if the count attribute isn't
present on the dataValidations element within the sheet.xml then the
validations cannot be found by POI.

Manually inserting this attribute, and then repackaging the .xlsx file, and the
validations can be found and processed successfully. 

Validating the xml against the schema suggests this attribute is optional.

A set of test cases and files confirming and demonstrating the problem can be
found at https://github.com/stuzart/poi-google-export-testcase

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