https://bugs.documentfoundation.org/show_bug.cgi?id=150655
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #1 from Mike Kaganski <[email protected]> --- IMO, this is not a bug. Calc has no idea how the underlying algorithm changes. Its engine does not care about sudden change of an algorithm, and it's /this sudden change/ that you did that made your results unreliable. If Calc was to assume that at any minute, a formula could change its meaning, it would have to re-calculate the whole sheet at every user action. In reality, for most formulas, Calc only cares about the *links* (references) that a cell has, and it only recalculates any cell when *its* formula changed, *or* its dependencies (direct or indirect) have changed. (There are so-called *volatile* functions, that recalculate at every change in the document, but making all user functions volatile would make most of sheets making heavy use of such functions slow.) And there is Data->Calculate->Recalculate Hard for unusual cases like yours, when one needs everything recalculated. It has a shortcut, too: Ctrl+Shift+F9. -- You are receiving this mail because: You are the assignee for the bug.
