[Libreoffice-bugs] [Bug 126519] UI - Calculation incorrect with VLOOKUP function, will not correct on recalculate

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #4 from alex at patternjugglers.co.nz ---
(In reply to m.a.riosv from comment #3)
> Doing a hard recalc [Ctrl+Shift+F9] (Menu/Data/Calculate/Recalculating hard)
> the file works for me, after saving and reopening the file seems to works
> fine also.

Thanks for that - I can confirm that works here too.
I'd suggest that needing to do hard recalc, which as a long-time user I was not
aware of, is unexpected behaviour.
I raised the bug because my wife, who is a skilled user, was unable to
establish what was wrong.  
I think a normal user would expect autocalc to ALWAYS work, and a manual recalc
likewise.
Interestingly my windows install menu of Menu/Data/Calculate/ contains only
Recalculate, Formula to Value, and AutoCalculate - no option for the hard
recalc.

I always like to learn something new, so I'll teach my wife [Ctrl+Shift+F9]
too, but I'd prefer it to be more discoverable.

Thanks again for your help!

-- 
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/20190725/c72c2368/attachment.html>