When you use the Function Wizard in Calc, and use the function VLOOKUP, the second parameter is a range of cell to search in.
The problem is that selected cells are without $ (absolute position).
So when you drag the cell (to extend the formula), the range is updated too (static range is better generally).
After : =VLOOKUP(A1;$C$1:$D$10;2;0)
Would it be possible to change this behavior in LibreOffice with a static range by default (with $) ?
What do you think about it ?
Nice tough, but next to the function wizard there is a name box, where you can put a name for the range of cells you need in the vlookup. And so you can drag it down without changing the range array. And it is better way when the spreadsheet needs a data checkup, or upgrade.
Thanks Xavier for your answer, very interesting.
I tested it and it work great.
I would like more opinions about it to know if it's enough.
Created attachment 134768 [details]
An example where this could be useful.
Criterion can be used as name for E2:E120 and to replace the first argument.
Maybe the feature should be 'F4 Toggle reference', working insidee the wizard when selecting a range.
(In reply to m.a.riosv from comment #5)
> Maybe the feature should be 'F4 Toggle reference', working insidee the
> wizard when selecting a range.
So this: https://help.libreoffice.org/Calc/Addresses_and_References,_Absolute_and_Relative#Absolute_Addressing
It seems we have consensus this is useful, so changing summary and setting to NEW.
*** Bug 49675 has been marked as a duplicate of this bug. ***