https://bugs.documentfoundation.org/show_bug.cgi?id=109254
Bug ID: 109254
Summary: [FEATURE] VLOOKUP is using dynamic array when created
with Function Wizard
Product: LibreOffice
Version: 5.2.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Hello,
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).
Example:
Currently: =VLOOKUP(A1;C1:D10;2;0)
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 ?
Sincerely,
Jean-Sébastien Bevilacqua
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
