Bug 64750 - getDataValidations relies on the count attribute being present
Summary: getDataValidations relies on the count attribute being present
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 4.1.2-FINAL
Hardware: PC All
: P2 normal with 1 vote (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2020-09-18 10:17 UTC by Stuart Owen
Modified: 2020-09-18 10:17 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description Stuart Owen 2020-09-18 10:17:42 UTC
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