poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 46979] New: Cell reference in Data validation does not update in Excel
Date Tue, 07 Apr 2009 09:26:53 GMT

           Summary: Cell reference in Data validation does not update in
           Product: POI
           Version: 3.5-dev
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: tibor.sandor@indgroup.eu

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.

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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

View raw message