[Bug 54662] HSSFDataValidation message size limit

[bu...@apache.org]

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

--- Comment #1 from Michael van der Gulik <m....@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-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org