[Bug 161066] [enhancement] add command to make (some) absolute references relative when moving / cut + pasting formula

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=161066

--- Comment #8 from Heiko Tietze <heiko.tietze at 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.