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.

Reply via email to