<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Add a new CELL() function for Excel compatibility"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=106151#c5">Comment # 5</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Add a new CELL() function for Excel compatibility"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=106151">bug 106151</a>
from <span class="vcard"><a class="email" href="mailto:hecho@live.co.uk" title="hardcoder <hecho@live.co.uk>"> <span class="fn">hardcoder</span></a>
</span></b>
<pre>That said, it would be even better to _also_ have a function just for returning
the selected range reference -- and this time, it would expose the whole range,
not just one cell. Also it would return the reference, like some other
functions are able to use. (CELL, instead, can return the address only as a
string, not directly as reference.)
Together with that, there could be per-file options on when to recalc,
including when selection changes, and at fixed intervals. This last one already
can be done by adding a dummy data connection ("link to external data..."). I
guess it's better to leave this for a new bug report and replicate these
suggestions there.</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>