<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:raal@post.cz" title="raal <raal@post.cz>"> <span class="fn">raal</span></a>
</span> changed
<a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Formula to Get value of last non-empty cell does not return expected result (lookup function)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=117016">bug 117016</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>erack@redhat.com, raal@post.cz, winfrieddonkers@libreoffice.org
</td>
</tr>
<tr>
<td style="text-align:right;">Summary</td>
<td>Formula to Get value of last non-empty cell does not return expected result
</td>
<td>Formula to Get value of last non-empty cell does not return expected result (lookup function)
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Formula to Get value of last non-empty cell does not return expected result (lookup function)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=117016#c2">Comment # 2</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Formula to Get value of last non-empty cell does not return expected result (lookup function)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=117016">bug 117016</a>
from <span class="vcard"><a class="email" href="mailto:raal@post.cz" title="raal <raal@post.cz>"> <span class="fn">raal</span></a>
</span></b>
<pre>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;
<a href="https://www.excelforum.com/excel-formulas-and-functions/1043140-explain-lookup-2-1-a2-a10-d2-b2-b10.html">https://www.excelforum.com/excel-formulas-and-functions/1043140-explain-lookup-2-1-a2-a10-d2-b2-b10.html</a>
<a href="https://exceljet.net/formula/get-value-of-last-non-empty-cell">https://exceljet.net/formula/get-value-of-last-non-empty-cell</a>
Not sure if it's bug or not. Adding cc to devs.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>