<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 - CELL function does not work as described."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138070">138070</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>CELL function does not work as described.
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.7.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</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>yestok@yestok.pl
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=167097" name="attach_167097" title="Result of using the CELL function with a range reference">attachment 167097</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=167097&action=edit" title="Result of using the CELL function with a range reference">[details]</a></span>
Result of using the CELL function with a range reference
The function description is as follows:Returns information on a cell such as
its address, formatting (...). Reference is the address of the cell to be
examined. If Reference is a range, the cell reference moves to the top left of
the range. If Reference is missing, Calc uses the position of the cell in which
this formula is located.
This description is discordant for 2D range and vector's range.
When reference is a 2D range, result is allways #VALUE!. When reference is a
vector, the result is displayed only when the formula is stored in the rows or
columns corresponding to the range.
An example is attached</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>