https://bugs.documentfoundation.org/show_bug.cgi?id=160739
--- Comment #10 from xhertan <[email protected]> --- (In reply to ady from comment #9) > 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. Thank you for your response. The example provided here is the simplest form of my calculations. I simplified the issue with the examples provided. These examples run perfectly fine in MS Excel, SoftMaker, and WPS Office. Only LO Calc is unable to compute this. If you can reproduce this case, Can we change the status of this bug to CONFIRMED? -- You are receiving this mail because: You are the assignee for the bug.
