<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 - Iteration not only bug-laden, but neglected and misunderstood"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=126866">126866</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Iteration not only bug-laden, but neglected and misunderstood
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.2.5.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>URL</th>
<td>https://wiki.documentfoundation.org/Faq/Calc/125
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Keywords</th>
<td>implementationError, topicDebug, topicQA
</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>hecho@live.co.uk
</td>
</tr>
<tr>
<th>Depends on</th>
<td>46845, 54022, 114482
</td>
</tr>
<tr>
<th>Blocks</th>
<td>33330, 117049
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=153333" name="attach_153333" title="Modest action game, comparable to music or dance games.">attachment 153333</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=153333&action=edit" title="Modest action game, comparable to music or dance games.">[details]</a></span>
Modest action game, comparable to music or dance games.
There are several bugs implicated with iteration/iterative calculation in Calc,
including several unreported bugs. But reading more about this feature in
LibreOffice help and Bugzilla, I soon began to see how that feature wasn't even
understood by the LibreOffice team.
Part of the problem exists because of the uneducated assumption that what you
call "convergence" is a necessary concern every time iteration is used. If
"only" you understood how unnecessary (also narrow-minded) that is (also note
that other spreadsheet apps don't work with such assumption). Later, I may post
an additional report with objective details on that, if you don't see what I
mean.
I know I'll have to eventually write other bug reports to elaborate specifics
on this set of problems (which will take time). But if you want one bug per
report, the original intention with this one is not just a preface, but to
report the bug staff and dev team attitude as a bug in itself -- one that
causes and sustains other bugs, so I'd give above-average importance.
While I haven't written more, I attached a little something for you. I made
this game inspired by Calc's feature to auto-refresh when there's a (dummy)
link to external data, but the game was hindered by the many iteration bugs, to
the point I saw I wouldn't be able to make it work on Calc (without macros,
which I usually reject). If the bugs are fixed, the game will probably start
working with no changes.</pre>
</div>
</p>
<div id="referenced">
<hr style="border: 1px dashed #969696">
<b>Referenced Bugs:</b>
<ul>
<li>
[<a class="bz_bug_link
bz_status_NEW "
title="NEW - Iteration causes error 522 after closing and reopening"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=33330">Bug 33330</a>] Iteration causes error 522 after closing and reopening
</li>
<li>
[<a class="bz_bug_link
bz_status_NEW "
title="NEW - Iterations not converging in Calc"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=46845">Bug 46845</a>] Iterations not converging in Calc
</li>
<li>
[<a class="bz_bug_link
bz_status_NEW "
title="NEW - Iteration Default Minimum (0.001) Causes Error 523"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=54022">Bug 54022</a>] Iteration Default Minimum (0.001) Causes Error 523
</li>
<li>
[<a class="bz_bug_link
bz_status_NEW "
title="NEW - Circular reference accumulator, err:523 or miscalculation"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=114482">Bug 114482</a>] Circular reference accumulator, err:523 or miscalculation
</li>
<li>
[<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED FIXED - Self-referencing circular reference iteration executes twice"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=117049">Bug 117049</a>] Self-referencing circular reference iteration executes twice
</li>
</ul>
</div>
<br>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>