<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Calc EDITING: Cells, containing call to Macro Function as Array doesn't update, even if press F9"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=43003#c18">Comment # 18</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Calc EDITING: Cells, containing call to Macro Function as Array doesn't update, even if press F9"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=43003">bug 43003</a>
from <span class="vcard"><a class="email" href="mailto:newbie-02@gmx.de" title="b. <newbie-02@gmx.de>"> <span class="fn">b.</span></a>
</span></b>
<pre>still buggy in 7.1.0.0.a0+,
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED DUPLICATE - CALC: UI: MACRO: array function not working from macro"
href="show_bug.cgi?id=129896">https://bugs.documentfoundation.org/show_bug.cgi?id=129896</a>
shows another flavour of this bug, a call to the function used somewhere else
on the sheet doesn't take it's own parameters but calculates with that taken
for the first instance of the function on load of file,
even if you delete everything from the sheet and put a value in a cell and try
to calculate INCDINC besides it, it doesn't take the value of the referenced
cell, but that what was loaded as parameter for the first used INCDINC on
opening the file,
resolutely persistent behaviour ...
regarding "stepping through the macro with F8 stops with 'BASIC runtime error.
Argument is not optional'?" from c#15: a function takes parameters, called by a
formula in a cell those are passed, is there a way to get them in if you want
to 'debug' the function in the 'IDE' (Basic Editor)? otherwise debugging is
blocked ... :-(</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>