Short: Allow backwards line-numbers (current line = 0, previous line = 1) together with menu items to reference them (e.g. line above previous line = CMD+shift+2) /or/ have menu item to toggle line-number direction and keep the CMD+1 that you have!!
Long:
Already when writing my question I was thinking about the need to reference 2 lines above the current line (so the previous previous line)... about that (I can also open a new Feature request for this one if you like)
Did you ever consider in having the line numbers not statically start at the top and increase going down, but to number the lines backwards from your current input line?
Sheets are meant to grow, right? So I can see a usecase where you would store some variables / values for quick access at the beginning... but at the same time for day-to-day regular usage it is (much more) intesting to number the lines backwards.
-->
Either make the line numbering
toggable
to either be like it is currently OR to have the current input line be 0 and then number from there up going backwards in history.
Or add the option to:
* reference to the previous line
* reference to the previous line to the previous line
* reference the 3rd line above the current input
And maybe assign:
CMD+SHIFT+1 to previous line (current -1)
CMD+SHIFT+2 to 2nd line above current line (current -2)
....
I am curious:
What say you?
:)
Already when writing my question I was thinking about the need to reference 2 lines above the current line (so the previous previous line)... about that (I can also open a new Feature request for this one if you like)
Did you ever consider in having the line numbers not statically start at the top and increase going down, but to number the lines backwards from your current input line?
Sheets are meant to grow, right? So I can see a usecase where you would store some variables / values for quick access at the beginning... but at the same time for day-to-day regular usage it is (much more) intesting to number the lines backwards.
-->
Either make the line numbering
toggable
to either be like it is currently OR to have the current input line be 0 and then number from there up going backwards in history.
Or add the option to:
* reference to the previous line
* reference to the previous line to the previous line
* reference the 3rd line above the current input
And maybe assign:
CMD+SHIFT+1 to previous line (current -1)
CMD+SHIFT+2 to 2nd line above current line (current -2)
....
I am curious:
What say you?
:)
PS: This is a follow-up request to https://soulver.canny.io/feature-requests/p/variable-to-reference-the-last-result
June 4, 2020