[Libreoffice-bugs] [Bug 72440] Vlookup issues with wizard

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #10 from Gert <ggkramer at gmail.com> ---
LO 5.4.3.2

In reply to Jacques Guilleron comment 6

Quote:
"To make appear the bug, the formula has to be located in a sheet after the
sheet where you search, and the wizard has to be used.
Other functions, as the Sum function, produce the same result with the same
conditions."

The wizard works well when the formula is located in the sheet and the
information looked for is in an after sheet.

F.i. Sheet1 - sheet2 - sheet3 - sheet 4 - sheet 5.
The wizard works well if the f0rmula is place in sheet1 and the search is in
sheet2, sheet3, sheet4 or sheet5.
However when the formula is placed in sheet3 and the search is in sheet4 of
sheet 5, the wizard fails.

-- 
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/20171119/6d08e144/attachment.html>