https://bugs.documentfoundation.org/show_bug.cgi?id=161066
Bug ID: 161066 Summary: [enhancement] When moving locked ranges, add a key that can be unlocked temprorily Product: LibreOffice Version: unspecified Hardware: All OS: Linux (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: elias_0000_0...@yahoo.com Lets say you have some data to "a1:a10". a11:a20, a21:a30, etc. You would like to run "index, match" combinations on these (separate) ranges to B columns . This require that the ranges will be locked eg. index(a$1:a$10, ....). There is no quick way to unlock them as you move them with mouse, then to lock them automatically to these new (separate) ranges. steps: 1) ctrl+x (cut) with some additional key to unlock ranges (eg. +u) 2) ctrl+v (paste) with some additional key (if needed) to lock them again. It may be the same key eg. (+u). This will expand usability, and user friendliness of calc. Version: 24.2.0.3 (X86_64) / LibreOffice Community Build ID: 420(Build:3) CPU threads: 24; OS: Linux 6.7; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Debian package version: 4:24.2.0-1 Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.