[Libreoffice-bugs] [Bug 106575] Correct VLOOKUP Formula - Incorrect Value shown. Shows correct value if formula reapplied / changes made in other sheets

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=106575

--- Comment #17 from Amit Seal Ami <lordamit at gmail.com> ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171215/df8e3d8b/attachment-0001.html>