[Bug 64750] New: getDataValidations relies on the count attribute being present

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

[Bug 64750] New: getDataValidations relies on the count attribute being present

Bugzilla from bugzilla@apache.org
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: [hidden email]
          Reporter: [hidden email]
  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: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 64750] getDataValidations relies on the count attribute being present

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

Dominik Stadler <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|---                         |FIXED

--- Comment #1 from Dominik Stadler <[hidden email]> ---
Thanks for the very detailed reproducer!

This is fixed now on latest trunk via r1885011, we now only look at the array
and ignore the "count" attribute to always handle elements even if count is not
set.

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]