<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 - Calc, HLOOKUP function doesn't report correct value in column 20 of 20 columns"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=118973">118973</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Calc, HLOOKUP function doesn't report correct value in column 20 of 20 columns
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>4.4.0.3 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (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>bert.robbins@yahoo.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
HLOOKUP reports value in next to last column and not the last column. Tried to
extend table to 22 columns and all values reported correctly expect column 20.
Steps to Reproduce:
1. Cell contents:B1 is 88F6X378V+MQ,
G1 is "=MID($B1,5,1)" displayed "X", G2 is "=VALUE(G1) dispalyed "Error:502",
G3 is "=ISERROR(G2)" displayed "TRUE", G4 is
"=IF(G3=0,HLOOKUP(G2,$B17:$U18,2),HLOOKUP(G1,$B17:$U18,2))" displayed "18"
2.Table is Google "Plus Code" lookup table and is rows 17 & 18, columns B
through U
Actual Results:
HLOOKUP reports "18" (in column T).
Expected Results:
Should be "19" (in column U).
Reproducible: Always
User Profile Reset: Yes
OpenGL enabled: Yes
Additional Info:
Reported value in cell U18 which is "19".
OpenGL vendor string: nouveau
OpenGL renderer string: NV4C
OpenGL version string: 2.1 Mesa 18.0.5
OpenGL shading language version string: 1.20
OpenGL extensions:
OpenGL ES profile version string: OpenGL ES 2.0 Mesa 18.0.5
OpenGL ES profile shading language version string: OpenGL ES GLSL ES 1.0.16
OpenGL ES profile extensions:
Version: 5.1.6.2
Build ID: 1:5.1.6~rc2-0ubuntu1~xenial3
CPU Threads: 2; OS Version: Linux 4.4; UI Render: default;
Locale: en-US (en_US.UTF-8); Calc: group</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>