Bug 45519

Summary: POI does not keep Data Validation records together
Product: POI Reporter: Josh Micich <josh>
Component: HSSFAssignee: POI Developers List <dev>
Severity: critical    
Priority: P3    
Version: 3.0-dev   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   

Description Josh Micich 2008-07-31 15:43:02 UTC
The DataValidation records of any given sheet must be written together (with no intervening records).  POI 3.1 does not enforce this - new DVRecords are added just before the EOFRecord, which is not quite the right place.

One way to observe this bug: Create a workbook in Excel.  Add data validation to one cell.  Delete the row containing that cell.  Save.  Open with POI, add data validation to a cell. Save.  Open in Excel. An error will be reported.
Comment 1 Josh Micich 2008-07-31 15:51:25 UTC
Fixed in svn r681530