<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 - Array formula with COLUMN() function evaluates to #VALUE error"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123477">123477</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Array formula with COLUMN() function evaluates to #VALUE error
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.2.0.3 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (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>ehorch@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=149305" name="attach_149305" title="Example of bad evaluation of array formula containing COLUMN() function">attachment 149305</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=149305&action=edit" title="Example of bad evaluation of array formula containing COLUMN() function">[details]</a></span>
Example of bad evaluation of array formula containing COLUMN() function
The attached workbook has an example of an array formula that contains the
FIND() function which takes as one of its arguments the output of the OFFSET()
function which in turn takes the COLUMN() function as one of its arguments.
This formula used to return a number (the index of the search substring) in 5.4
but with 6.2, it returns #VALUE.</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>