<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - LOOKUP function stopped working"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=135718">135718</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>LOOKUP function stopped working
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.3.6.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>lkp1957@hotmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
Had a list of LOOKUP functions referencing a table to report values as they
updated. Worked great for months until yesterday when it suddenly started
reporting wrong values mostly the same one. Checked the formulas and all good.
Steps to Reproduce:
1.Set up a two column table of text in one and values in the other
2.Set up second list of text with LOOKUP functions to report the corresponding
values
3. Update the values in the first table
Actual Results:
Mostly a single number randomly returned with a few others. All incorrect
Expected Results:
The correct values every update
Reproducible: Always
User Profile Reset: No
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-GB
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no</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>