Bug 45519 - POI does not keep Data Validation records together
Summary: POI does not keep Data Validation records together
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.0-dev
Hardware: PC Windows XP
: P3 critical (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-07-31 15:43 UTC by Josh Micich
Modified: 2008-07-31 15:51 UTC (History)
0 users


Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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