Summary: | Userdefined Data Validation Formula breaks after saveing with hssf | ||
---|---|---|---|
Product: | POI | Reporter: | Bernhard <bernhard.schwager> |
Component: | HSSF | Assignee: | POI Developers List <dev> |
Status: | RESOLVED DUPLICATE | ||
Severity: | major | ||
Priority: | P2 | ||
Version: | 3.0-dev | ||
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | Windows XP | ||
Attachments: | cell reference from the data validation formula is set to a1 after saving |
This looks very similar to bug 45091 Please re-test with latest svn trunk / nightly build (for example: http://encore.torchbox.com/poi-svn-build/poi-3.1-beta3-20080619.jar) Reopen this bugzilla if the problem still occurs. *** This bug has been marked as a duplicate of bug 45091 *** |
Created attachment 22140 [details] cell reference from the data validation formula is set to a1 after saving If a user defined data validation uses cell-references in the formula, the reference points to the cell a1 after saving the excel file with poi. Look at the attachment: After saving the file with poi the data validation from cell B4 changed from =TAG(B4)=1 to =TAG(A1)=1