https://bugs.documentfoundation.org/show_bug.cgi?id=136897
Bug ID: 136897
Summary: Convergence check in iteration prevents lots of uses
of iteration (anti-feature)
Product: LibreOffice
Version: 6.4.6.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: he...@live.co.uk
Description:
Iterative calculation is an already old feature to many traditional spreadsheet
apps, but LibreOffice has something more on topic. It tries to detect whether
variation between iterations goes beyond certain limit, and tries to hide the
result of the iteration if it judges it is not converging, using a very basic
checking. IMHO this checking it otiose/superfluous and is only here to prevent
some real applications of iteration. Iteration is a really powerful feature;
you could built an emulator out of it.
Steps to Reproduce:
1. Open a new spreadsheet
2. Go to Tools > Options... > LibreOffice Calc > Calculate
3. Enable "Iterations". I recommend to bump up the "minimum change" to the
modest amount of 1E+308, to minimize your problems. Observe how many iterations
are set.
4. In cell A1, type =A1 + 1
5. Try throwing F9s (recalcs), whether or not A1 is the selected cell (results
may vary).
6. Try to rationalize why LibreOffice Calc is behaving that way (I failed at
that point).
Bonus track. In cell A2, put =A2&"a" . See if a string of a's appear, as it
would on Office for instance, at every recalc.
Actual Results:
Even though iterations is set as 100 steps here, A1 sometimes advances 2 cycles
(when selected), sometimes doesn't advance. A2 simply yields Err:523 (not
converging). Well, I'm asking for a string output to be built; who cares if it
doesn't converge?
Expected Results:
It should work more like WPS Office Free, or Office 2010+ for Windows.
Fortunately those programs have no obligatory convergence check on iterative
calculations.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 6.4.6.2 (x64)
Build ID: 0ce51a4fd21bff07a5c061082cc82c5ed232f115
CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: default; VCL: win;
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
