[Bug 64423] New: Formula evaluation containing a named range with relative address produces incorrect result

[bu...@apache.org]

https://bz.apache.org/bugzilla/show_bug.cgi?id=64423

            Bug ID: 64423
           Summary: Formula evaluation containing a named range with
                    relative address produces incorrect result
           Product: POI
           Version: 4.1.2-FINAL
          Hardware: All
                OS: All
            Status: NEW
          Severity: major
          Priority: P2
         Component: SS Common
          Assignee: dev@poi.apache.org
          Reporter: lrx@lrx.it
  Target Milestone: ---

Created attachment 37226
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=37226&action=edit
source code for generating described issue

In Excel you can generate a name with relative addressing even by using A1
reference style

For example:

1) Select cell A1

2) Define a name CURRENT_ROW_COLUMN_A as =Sheet1!$A1

3) In column A insert some numbers

   | A 
---+----
 1 | 1
 2 | 2
 3 | 3
 4 | 4
 5 | 5

4) In B1 insert formula CURRENT_ROW_COLUMN_A+1000

   | A | B
---+---+---
 1 | 1 | =CURRENT_ROW_COLUMN_A+1000
 2 | 2 | 
 3 | 3 | 
 4 | 4 | 
 5 | 5 | 

5) Then double click B1 bottom right corner to auto expand and view the result:

   | A | B
---+---+---
 1 | 1 | 1001
 2 | 2 | 1002
 3 | 3 | 1003
 4 | 4 | 1004
 5 | 5 | 1005

Attached code generate a test workbook with additional columns showing
incorrect evaluation behavior, relative address is always pointing @ row 1.

Column C is POI evaluation result:

   | A | B    | C (issue)
---+---+------+-----
 1 | 1 | 1001 | 1001
 2 | 2 | 1002 | 1001
 3 | 3 | 1003 | 1001
 4 | 4 | 1004 | 1001
 5 | 5 | 1005 | 1001

-- 
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

[Bug 64423] Formula evaluation containing a named range with relative address produces incorrect result

[bu...@apache.org]

https://bz.apache.org/bugzilla/show_bug.cgi?id=64423

lrx <lr...@lrx.it> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |lrx@lrx.it

-- 
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