https://bugs.documentfoundation.org/show_bug.cgi?id=160739
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #9 from ady <[email protected]> --- I am CC'ing Rafael Lima, just in case he happens to be somewhat interested in this kind of issues; apologies if this is not the case. * The samples provided are indeed using iteration, but without convergence. * ATM, Calc indeed lacks the possibility of solving iterations without convergence. * There might be a chance that using some Solver or Goal Seek models would workaround the lack of the aforementioned feature, in some cases. * The specific samples attached to this report seem to be using over-complicated formulas in more than one range. There are simpler, more-efficient equivalent formulas that could replace them, unless the attached sample files actually represent much more complicated cases (which we cannot deduce from those sample files). * The MMULT() function does not seem to be related to the issue in any way; it just happens to be used in one array formula, but the same could had happened with any other function in its place. * I would suggest going to <https://ask.libreoffice.org> and ask there for alternative solutions and possible improvements, with particular focus on what exactly is the goal (i.e. what you want to achieve), rather than focusing on the method/formula that is in use in the attached sample files. -- You are receiving this mail because: You are the assignee for the bug.
