https://bugs.documentfoundation.org/show_bug.cgi?id=154075
--- Comment #4 from Justin L <[email protected]> --- (In reply to ady from comment #3) I cannot reproduce your sequence. If I just type in the formula area "=$Sheet1.$A$1" and then cycle with F4 I get: -$Sheet1.B$2 = sheet + row (aka 6) -$Sheet1.$B2 = sheet + col (aka 5) -$Sheet1.B2 = sheet (aka 4) - you said this would become Sheet.B2 (aka 0) -Sheet1.$B$2 = cell (aka 3) -Sheet1.B$2 = row (aka 2) -Sheet1.$B2 = col (aka 1) -Sheet1.B2 = relative (aka 0) - you said this would become $Sheet.B2 (aka 4) I'm pretty sure you are mistaken because the code path I found is a very simple "subtract by 1" formula. If you are not mistaken, please provide the exact formula/steps that you are following to trigger this cycle. -- You are receiving this mail because: You are the assignee for the bug.
