[Bug 161066] [enhancement] add command to make (some) absolute references relative when moving / cut + pasting formula
https://bugs.documentfoundation.org/show_bug.cgi?id=161066 Stéphane Guillou (stragu) changed: What|Removed |Added Keywords|needsUXEval | Resolution|FIXED |WONTFIX -- You are receiving this mail because: You are on the CC list for the bug.
[Bug 161066] [enhancement] add command to make (some) absolute references relative when moving / cut + pasting formula
https://bugs.documentfoundation.org/show_bug.cgi?id=161066 elias estatistics changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |FIXED --- Comment #9 from elias estatistics --- ok, please close the issue. thanks -- You are receiving this mail because: You are on the CC list for the bug.
[Bug 161066] [enhancement] add command to make (some) absolute references relative when moving / cut + pasting formula
https://bugs.documentfoundation.org/show_bug.cgi?id=161066 --- Comment #8 from Heiko Tietze --- 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.
[Bug 161066] [enhancement] add command to make (some) absolute references relative when moving / cut + pasting formula
https://bugs.documentfoundation.org/show_bug.cgi?id=161066 Stéphane Guillou (stragu) changed: What|Removed |Added Keywords||needsUXEval CC||libreoffice-ux-advise@lists ||.freedesktop.org Version|unspecified |Inherited From OOo Summary|[enhancement] When moving |[enhancement] add command |locked ranges, add a key|to make (some) absolute |that can be unlocked|references relative when |temprorily |moving / cut + pasting ||formula OS|Linux (All) |All --- Comment #7 from Stéphane Guillou (stragu) --- That sounds to me like way too much effort and over-engineering, for something that can already be solved by using F4 in the pasted formula. I vote -1 but let's see what the UX/Design team thinks. -- You are receiving this mail because: You are on the CC list for the bug.