[Libreoffice-bugs] [Bug 123746] New: Allow VLOOKUP function to work on the left specifying a negative index

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=123746

            Bug ID: 123746
           Summary: Allow VLOOKUP function to work on the left specifying
                    a negative index
           Product: LibreOffice
           Version: 3.3.0 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: blackhole at lobianco.org

Description:
The VLOOKUP() function works specifying a value to look-up in a column X and
the number of columns on the right where to retrieve the desired output on the
same raw of the founded value.

Often however I find myself to have the value to look-up on the right, and the
return value on the left.

My suggestion is to allow specifying a negative index of number of column and
this would have to be interpreted to lookup the value on the rightmost column
of the interval given and return the value on the specified column on the left.

Steps to Reproduce:
VLOOKUP(A1:D10,"car",2,0) (current implementation) returns the value in the B
column at the row where on column A the word "car" is found. 

VLOOKUP(A1:D10,"car",-2,0) (proposed implementation) should return the value in
the C column at the row where on column D the word "car" is found. 


Actual Results:
Negative index results in an error

Expected Results:
Negative index should mirror the request and look at the left of the rightmost
column.


Reproducible: Always


User Profile Reset: No



Additional Info:
I never use it, but the same thing could possibly apply also to HLOOKUP()

-- 
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/20190227/f6dd0627/attachment-0001.html>