https://bugs.documentfoundation.org/show_bug.cgi?id=106575
Bug ID: 106575
Summary: Correct Formula - Incorrect Value shown. Shows correct
value if formula reapplied / changes made in other
sheets
Product: LibreOffice
Version: 5.3.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I used vlookup to copy values from other sheets. Although the same formula is
applied throughout the column, some values are not correct.
If I reapply the same formula, it shows the correct value. If I make some
changes in the sheet being used by vlookup, it changes the incorrect value to
correct ones.
The file exhibiting this behavior contains sensitive information. If those
information are removed(change data), the formula calculation is triggered by
changes and incorrect values are replaced by correct values. However, if I do
not save and close the file and reopen it, the incorrect values are shown
every.single.time.
I have screencasted this behavior and it is available here for viewing for
getting a clearer idea.
https://www.youtube.com/watch?v=4oakCHd6FOQ&feature=youtu.be
I am really sorry that I can not share this file due to the information it
contains.
I am stating it as severe, since such errors in data calculation completely
throwsthe usefulness of libreoffice out of the window.
Please do not think that I am not happy with LibreOffice. I really am, and I
will provide any information necessary so that you can fix it.
Steps to Reproduce:
Only a few values are incorrect, and I am not sure what triggers it.
Actual Results:
Incorrect result from formula.
Expected Results:
Correct value taken from other sheets using vlookup.
Reproducible: Couldn't Reproduce
User Profile Reset: No
Additional Info:
Kubuntu: 16.10, 64 bit.
User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like
Gecko) Chrome/57.0.2987.98 Safari/537.36
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
