Bug 118973 - Calc, HLOOKUP function doesn't report correct value in column 20 of 20 columns
Summary: Calc, HLOOKUP function doesn't report correct value in column 20 of 20 columns
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Calc-Function
  Show dependency treegraph
Reported: 2018-07-27 17:31 UTC by Paul
Modified: 2019-02-26 09:52 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Paul 2018-07-27 17:31:19 UTC
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:

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
Comment 1 Jean-Baptiste Faure 2018-07-27 18:54:20 UTC
Thank you for your bug report. Please attach a test file so that other contributors can try to confirm it.

Status set to NEEDINFO, please set it back to UNCONFIRMED once requested
informations are provided.

Best regards. JBF