<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - calc autocalculate reproducibly fails on cell with formula after editing a copy! of that cell"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123736#c5">Comment # 5</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - calc autocalculate reproducibly fails on cell with formula after editing a copy! of that cell"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123736">bug 123736</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>narrowing down:
fails looks dependent on placing the copy above or below the original,
(maybe that's the situation where 'shared formulas' are created)
fails looks dependent on formulas calculating a range,
('=SUM(A1:B1)' and '=MAX(A1:B1)' will fail, while '=A1+B1' and '=SUM(A1;B1)'
will work),
there must be some sort of 'property' with a cell that can lock it from being
'autocalculated'?,
or some sort of label attached to its 'place in the sheet' saying
'autocalculate unneccessary'?,
this property is hidden, out of view and access by the user,
it violates the statement what autocalculate should do
('All cells are recalculated after a sheet cell has been modified.')
i'd like to yell 'alarm!!!' in capitals but don't know if that's appropriate in
the community,
it's 'nice' that this error disappears after save - load,
other similar problems don't!,
this fault is trapping users and waisting time of programmers and debuggers,
the problem is still present in Version: 6.2.2.0.0+ (x64)
Build ID: 5f9104ef6f42d9d42ce3ec564affcba88889e76c
CPU threads: 8; OS: Windows 6.1; UI render: default; VCL: win;
TinderBox: Win-x86_64@42, Branch:libreoffice-6-2, Time: 2019-02-27_17:10:55
Locale: de-DE (de_DE); UI-Language: en-US
Calc: threaded</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>