[Libreoffice-bugs] [Bug 109254] New: [FEATURE] VLOOKUP is using dynamic array when created with Function Wizard

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: realitix at gmail.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170721/ff704492/attachment.html>