https://bugs.documentfoundation.org/show_bug.cgi?id=107160
Bug ID: 107160
Summary: VLOOKUP gets incorrect Value | Ctrl-Shift-F9 doesn't
help
Product: LibreOffice
Version: 5.3.1.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
My problem is similar to Bug 106575.
In sheet A cell C11 must be 1400 instead of 100.
Maybe it has something to do with the search criterion in VLOOUP, because when
I change the text in column B the bug is gone.
I try to attach the affected file and the file after changing column B.
If I got it right, in Bug 106575 the problem was solved with Ctrl-Shift-F9.
But that doesn't help in my case.
Actual Results:
Wrong value in cell C11
Expected Results:
Right value in cell C11
Reproducible: Couldn't Reproduce
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like
Gecko
--
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
