<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - After cut/paste, cells with absolute references are not recalculated; displayed results are wrong until manual recalc performed" href="https://bugs.documentfoundation.org/show_bug.cgi?id=120013#c15">Comment # 15</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - After cut/paste, cells with absolute references are not recalculated; displayed results are wrong until manual recalc performed" href="https://bugs.documentfoundation.org/show_bug.cgi?id=120013">bug 120013</a> from <a class="email" href="mailto:thatseattleguy@gmail.com" title="David Ruggiero <thatseattleguy@gmail.com>"> David Ruggiero</a> <pre>(Original submitter) I am now seeing, in Calc sheets with similar formulas, that even a manual recalc (Fn-Shift-F9) does not always give the correct results in some cases. I will try to make a simple reproducible example. If I can do so, I think the severity should be raised to "major" because the incorrect results are persistent (at least until a save/restore). I say this especially in light of bug reports like <a class="bz_bug_link bz_status_ASSIGNED " title="ASSIGNED - Moving (Cut&Paste, Drag&Drop) a column range within the same row into a shared formula group's reference may not recalculate the first affected formula cell (procedure in comment 11)." href="show_bug.cgi?id=123714">https://bugs.documentfoundation.org/show_bug.cgi?id=123714</a> ...which point at a potentially deeper and more fundamental flaws in Calc's handling of formula absolute references.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>