https://bugs.documentfoundation.org/show_bug.cgi?id=173608
--- Comment #12 from ady <[email protected]> --- (In reply to Xisco Faulí from comment #9) > Could you provide a minimal testcase where the issue is > reproducible, latter I can use it for adding a unittest as well. Minimal sample (for Unit test too): On worksheet "Sheet1": Sheet1.A1: 1 Sheet1.A2: 2 On worksheet "Sheet2": Sheet2.A1: =$Sheet1.A1+1 -> Absolute reference to worksheet "Sheet1", relative reference to its cell A1 Sheet2.A2: =Sheet1.A2+1 -> Relative reference to "immediately-prior" worksheet "Sheet1", relative reference to its cell A2 STR: 1._ Duplicate "Sheet2" The new "Sheet2_2" is created "next" to "Sheet2". Actual result: On new Sheet2_2.A1: =$Sheet1.A1+1 -> result: 2 -> ok On new Sheet2_2.A2: =Sheet1.A2+1 -> result: 3 -> ko Expected result: On new Sheet2_2.A1: =$Sheet1.A1+1 -> result: 2 On new Sheet2_2.A2: =Sheet2.A2+1 -> result: 4 -> Relative reference to "immediately-prior" worksheet "Sheet2", relative reference to its cell A2 Note on new Sheet2_2.A2, Expected in formula: "Sheet2" vs Actual in formula: "Sheet1". Problem: Relative references to worksheets are treated as absolute references to worksheets. This is a minimal test, using "Duplicate worksheet". Other cases might be relevant (not yet tested by me ATM), introduced by the same commit: 5cefed66bccab3757793686e9402b2faf37fcb8a sc: Fix backward reference when copying a sheet. XLS(X) does not support relative references to worksheets, but ODS does. -- You are receiving this mail because: You are the assignee for the bug.
