<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED NOTABUG - Correct VLOOKUP Formula - Incorrect Value shown. Shows correct value if formula reapplied / changes made in other sheets" href="https://bugs.documentfoundation.org/show_bug.cgi?id=106575#c17">Comment # 17</a> on <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED NOTABUG - Correct VLOOKUP Formula - Incorrect Value shown. Shows correct value if formula reapplied / changes made in other sheets" href="https://bugs.documentfoundation.org/show_bug.cgi?id=106575">bug 106575</a> from <a class="email" href="mailto:lordamit@gmail.com" title="Amit Seal Ami <lordamit@gmail.com>"> Amit Seal Ami</a> <pre>Dear Buovjaga, Sorry to revive this dead thread again; but this bug hit me again. Since I am in academia, this is a issue that affects the grade of students if the values are not hard recalculated every time. I have went through #82135, and the statement was: "The mentioned behaviour here is not a bug. We are using cached values and if the file contains wrong values there is nothing we can do." However, I have to disagree. For a file that was created, edited and maintained only using LibreOffice Calc, if the cached values are wrong - it should be a problem of LibreOffice, and not the file itself. At least the "Always Recalculate" should be turned on by default in LibreOffice Calc.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>