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

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Thu Jul 25 02:35:28 UTC 2019


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

--- Comment #2 from alex at patternjugglers.co.nz ---
Created attachment 152972
  --> https://bugs.documentfoundation.org/attachment.cgi?id=152972&action=edit
Copy of sample problem spreadsheet, with unnecessary extra data removed

    • the yellow highlighted cells in column C contain the same value
    • the green hightlighted cell in column J has calculated correctly from the
VLOOKUP
    • the red highlighted cells in column J are displaying 0.00, which is
incorrect

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


More information about the Libreoffice-bugs mailing list