https://issues.apache.org/bugzilla/show_bug.cgi?id=46979
Summary: Cell reference in Data validation does not update in
Excel
Product: POI
Version: 3.5-dev
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
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.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
