Bug 64423 - Formula evaluation containing a named range with relative address produces incorrect result
Formula evaluation containing a named range with relative address produces in...
 Status: NEW None POI Unclassified SS Common (show other bugs) 4.1.2-FINAL All All P2 major (vote) --- POI Developers List

 Reported: 2020-05-11 20:12 UTC by lrx 2020-05-11 20:13 UTC (History) 1 user (show) lrx

Attachments
source code for generating described issue (1.81 KB, application/x-zip-compressed)
2020-05-11 20:12 UTC, lrx
Details

 Note You need to log in before you can comment on or make changes to this bug.
 lrx 2020-05-11 20:12:42 UTC ```Created attachment 37226 [details] 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```