| Summary: | [PATCH] XSSFDataValidation ignores "allow blank" read from sheet, assumes true | ||
|---|---|---|---|
| Product: | POI | Reporter: | Chris Boyle <cmb-apache> |
| Component: | XSSF | Assignee: | POI Developers List <dev> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | Keywords: | PatchAvailable |
| Priority: | P2 | ||
| Version: | unspecified | ||
| Target Milestone: | --- | ||
| Hardware: | PC | ||
| OS: | Linux | ||
| Attachments: | Patch to not overwrite allow blank value | ||
Created attachment 31943 [details] Patch to not overwrite allow blank value XSSFDataValidation.XSSFDataValidation(CellRangeAddressList, CTDataValidation) calls ctDdataValidation.setAllowBlank(true), overwriting the original value read from the sheet. That value is therefore unavailable. Attached is a patch from a colleague, with tests, to call setAllowBlank(true) in the DataValidationHelper instead, so it still defaults to true for write, but allows reading the actual value from the sheet.