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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
