Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


Hi,

Presently I'm looking at bug fdo 37341, which reports calc to hang when Goal Seek 
(sc/source/core/tool/interpr2.cxx, ScInterpreter::ScBackSolver()) is used.
The cause of the problem is not that too many iterations are needed, but that MAXRECURSION in 
sc/source/core/data/formulacell.cxx, ScFormulaCell::Interpret() is reached.
Increasing MAXRECURSION 'solves' the problem.

I think increasing MAXRECURSION from its present value (400) to 800 is no problem. 10 years ago its 
value was 500 and in the past 1 years the available memory has been more than doubled.
But that does not really solve the problem, it only shifts the point where the problem will show.
Shouldn't a global error (or at least warning)  be generated when MAXRECURSION is reached? After 
all, the result of ScFormulaCell::Interpret() is not correct in that case.
Unfortunately, I can't quite grasp the recursion/interation process in ScFormulaCell::Interpret(), 
so I can't generate the appropiate error.

Do you have any suggestions about how to properly solve this?
To me just increasing MAXRECURSION to 800 is a dirty hack.



Winfried


Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.