[Libreoffice-bugs] [Bug 117016] Formula to Get value of last non-empty cell does not return expected result (lookup function)

[bugzilla-daemon at bugs.documentfoundation.org]

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

raal <raal at post.cz> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |erack at redhat.com,
                   |                            |raal at post.cz,
                   |                            |winfrieddonkers at libreoffice
                   |                            |.org
            Summary|Formula to Get value of     |Formula to Get value of
                   |last non-empty cell does    |last non-empty cell does
                   |not return expected result  |not return expected result
                   |                            |(lookup function)

--- Comment #2 from raal <raal at post.cz> ---
It works in excel, not in LO. Confirm with Version: 6.1.0.0.alpha0+
Build ID: 5289441ffa227f5f358ca4dc28df416be922aa66
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk3; 


https://www.excelforum.com/excel-formulas-and-functions/1043140-explain-lookup-2-1-a2-a10-d2-b2-b10.html
https://exceljet.net/formula/get-value-of-last-non-empty-cell

Not sure if it's bug or not. Adding cc to devs.

-- 
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/20180422/6948706b/attachment.html>