Hi, 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. Strange.
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.
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.