[Libreoffice-bugs] [Bug 126866] New: Iteration not only bug-laden, but neglected and misunderstood

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=126866

            Bug ID: 126866
           Summary: Iteration not only bug-laden, but neglected and
                    misunderstood
           Product: LibreOffice
           Version: 6.2.5.2 release
          Hardware: x86-64 (AMD64)
               URL: https://wiki.documentfoundation.org/Faq/Calc/125
                OS: Windows (All)
            Status: UNCONFIRMED
          Keywords: implementationError, topicDebug, topicQA
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: hecho at live.co.uk
        Depends on: 46845, 54022, 114482
            Blocks: 33330, 117049

Created attachment 153333
  --> https://bugs.documentfoundation.org/attachment.cgi?id=153333&action=edit
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.


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=33330
[Bug 33330] Iteration causes error 522 after closing and reopening
https://bugs.documentfoundation.org/show_bug.cgi?id=46845
[Bug 46845] Iterations not converging in Calc
https://bugs.documentfoundation.org/show_bug.cgi?id=54022
[Bug 54022] Iteration Default Minimum (0.001) Causes Error 523
https://bugs.documentfoundation.org/show_bug.cgi?id=114482
[Bug 114482] Circular reference accumulator, err:523 or miscalculation
https://bugs.documentfoundation.org/show_bug.cgi?id=117049
[Bug 117049] Self-referencing circular reference iteration executes twice
-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190813/e81f312b/attachment-0001.html>