[Libreoffice-bugs] [Bug 118973] New: Calc, HLOOKUP function doesn't report correct value in column 20 of 20 columns

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 118973
           Summary: Calc, HLOOKUP function doesn't report correct value in
                    column 20 of 20 columns
           Product: LibreOffice
           Version: 4.4.0.3 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: bert.robbins at yahoo.com

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

-- 
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/20180727/a3116175/attachment-0001.html>