<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - conditional formatting with formula is VLOOKUP(C14,Region,1,0) is VLOOKUP(C14,#NAME?,1,0)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=122378">122378</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>conditional formatting with formula is VLOOKUP(C14,Region,1,0) is VLOOKUP(C14,#NAME?,1,0)
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.3.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>hpadrutt@ggaweb.ch
</td>
</tr></table>
<p>
<div>
<pre>Hi
In my short Excel I use conditional formatting with formula. Using Excel it
works, using LibreOffice Calc it doesn’t work.
The problem seems to be in the conditional formatting as the Name “Region” is
not valid after the value in the name “Region” changes.
Conditional formatting Formula is VLOOKUP(C14,Region,1,0)
as soon as the value in the “Region” changes it get this error
Conditional formatting Formula is VLOOKUP(C14,#NAME?,1,0)
This formula is used in Range D14:D44 with ConditionlaStyle_1 which also does
not work
LibreOffice Version 6.1.3.2 (x64) same in Version 6.2
If it helps I can attached the full Excel
Regards, Heinrich</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>