https://bz.apache.org/bugzilla/show_bug.cgi?id=54662
--- Comment #1 from Michael van der Gulik <m.vandergu...@gns.cri.nz> --- Just been caught out by this bug. My opinion is that it's a bug in Excel and that Apache POI needs to work around it... It also applies to XSSFDataValidation. The symptom is (for people Googling this) when Excel opens the spreadsheet: "We found a problem with some content in <spreadsheet>. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes." and then: <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><logFileName>error104200_01.xml</logFileName><summary>Errors were detected in file 'C:\Users\<snip>.xlsm'</summary><repairedRecords><repairedRecord>Repaired Records: Data validation from /xl/worksheets/sheet2.xml part</repairedRecord></repairedRecords></recoveryLog> Thanks, Excel. That's a useless error message and I spent an hour hunting this down. -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org