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