https://bugs.documentfoundation.org/show_bug.cgi?id=161066
--- Comment #8 from Heiko Tietze <heiko.tie...@documentfoundation.org> --- Sheet > Cycle Cell Reference Type assigned to F4 cycles between col/row, col, row, none. =A1 -> =$A$1 -> =A$1 -> =$A1 -> =A1... Works pretty well and tinkering something so "IF(D6=1,ROW($A$1:$A$10), "...") toggles only D6 sounds inflexible and very special. What you can do is to put the single references into extra cells, something like M1: =D6 and M2: ROW($A$1:$A$10) and use "IF(M1=1, M2, "..."). => WF/NAB (for "F4 behavior must change" or to introduce some other mode) -- You are receiving this mail because: You are on the CC list for the bug.