Bug 46979 - Cell reference in Data validation does not update in Excel
Summary: Cell reference in Data validation does not update in Excel
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.5-dev
Hardware: PC Windows XP
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2009-04-07 02:26 UTC by Tibor Sandor
Modified: 2015-05-18 20:27 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description Tibor Sandor 2009-04-07 02:26:51 UTC
I'm using the beta5 version of POI 3.5
I created a Data validation constraint that contains a cell reference (e.g =INDIRECT(A1)). I added this validation to a cell (e.g B1).
When I open it in Excel it is working fine until I try to copy and paste the cells. If I paste A1 and B1 to A2 and B2 the Data validation in B2 is =INDIRECT(A1) instead of =INDIRECT(A2).
BUT if I simply open the Data validation form in excel and then just OK it without any changes to it and try to copy-paste the cells after this procedure the Data validation in B2 will be fine.
Comment 1 Christian 2011-07-05 10:41:07 UTC
Usung HSSF (*.xls files) I noticed that using relative addresses without the $ Excel 2003 and Excel 2010 react diferrently.

This may be a bug/change in Excel rather that POI.
Comment 2 Dominik Stadler 2015-05-18 20:27:58 UTC
Based on the latest comment and the long time without much progress I am closing this for now as being more caused by Excel itself, if this is still an issue for you then please reopen this with a reproducing unit-testcase which allows us to reproduce this behaviour.