Bug 161066 - [enhancement] When moving locked ranges, add a key that can be unlocked temprorily
Summary: [enhancement] When moving locked ranges, add a key that can be unlocked tempr...
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All Linux (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard: QA:needsComment
Keywords:
Depends on:
Blocks:
 
Reported: 2024-05-14 00:46 UTC by elias estatistics
Modified: 2024-05-29 03:15 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description elias estatistics 2024-05-14 00:46:28 UTC 
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