<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:yestok@yestok.pl" title="Jerzy Moruś <yestok@yestok.pl>"> <span class="fn">Jerzy Moruś</span></a>
</span> changed
<a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - CELL function does not work as described."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138070">bug 138070</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>1
</td>
<td>
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>NEEDINFO
</td>
<td>UNCONFIRMED
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - CELL function does not work as described."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138070#c2">Comment # 2</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - CELL function does not work as described."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138070">bug 138070</a>
from <span class="vcard"><a class="email" href="mailto:yestok@yestok.pl" title="Jerzy Moruś <yestok@yestok.pl>"> <span class="fn">Jerzy Moruś</span></a>
</span></b>
<pre>Function CELL have a 2 arguments. First is "type of information" and must be
written in quotation marks, but only when is written directly like text. In my
example this arguments are written in first row (from column F to I) and are
passed as a cell reference.
The ranges are colored cells. They have names Opel, Opel2 and Opel3 (look at
Sheet -> Names cells adnd references).
Reproduce the problem. In cell e.g. E12, write formula =CELL("address";A1:B2)
The description of the function says that the result should be the address of
cell A1 (upper left corner of the range). However, this is not the case and we
get #VALUE !
The results (but incorrect, not the top right corner) appear only for a vector
region, only in cells that match the rows or columns of the vector (see
attatchment).</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>