<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Vlookup issues with wizard"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=72440#c10">Comment # 10</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Vlookup issues with wizard"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=72440">bug 72440</a>
from <span class="vcard"><a class="email" href="mailto:ggkramer@gmail.com" title="Gert <ggkramer@gmail.com>"> <span class="fn">Gert</span></a>
</span></b>
<pre>LO 5.4.3.2
In reply to Jacques Guilleron <a href="show_bug.cgi?id=72440#c6">comment 6</a>
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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>