Description: It would be nice to shift-click on a cell and have it entered as an absolute reference, vs. going back and changing them by typing in the $ sign. ctrl-click does a similar function where it inserts the cell with a comma before it. Steps to Reproduce: 1. click cell, type equals 2. select desired cell with mouse click Actual Results: relative reference Expected Results: absolute reference Reproducible: Always User Profile Reset: No Additional Info:
Created attachment 151181 [details] just a picture of what I mean
Created attachment 151182 [details] better picture - ignore first
I personally think that it would be a useful feature. adding UX team to the CC list.
Yes, great idea. However, shift+click selects a range, eg. B1:C2, whereas ctrl+click adds a single cell to the selection and thereby the semicolon, eg. B1;C2. Alt+click is occupied by the window manager on many desktop environments. So how about modifying the ctrl/shift+click behavior with alt in order to get the same as before but with absolute references?
You mean Alt+Shift+Click like Shift+Click but with absolute references, and Alt+Ctrl+Click like Ctrl+Click but with absolute references? Might be doable, but IMHO too cumbersome to type and hold button down as well, I wouldn't use it. Much easier is to use existing functionality, select the cell/range and before moving on hit F4, which "absolutes" the currently selected cell/range in the formula expression. One can even toggle through.
DV, A1 -> $A$1 -> A$1 -> $A1 (it's not selective so A1:B2 toggles completely). Is that sufficient for you?
Heiko, Eike, ty. Your suggestion is sufficient. I've made a donation to the TDF, I'm really amazed at the development in LibreOffice! On a laptop with no native F keys I think it would be easier to Alt+Shift+Click due to the natural position of the fingers. If possible, could someone link me to the file in github and line where I'd be able to play with this in the source? it seems like a fun little project.
Glad you are happy with LibreOffice. Take a look at Tools > Customize > Keyboard about changing the default key bindings. See also https://help.libreoffice.org/6.2/en-US/text/shared/01/06140200.html?&DbPAR=SHARED&System=UNIX