https://bugs.freedesktop.org/show_bug.cgi?id=31577
--- Comment #19 from Phil Hibbs <sna...@gmail.com> --- Created attachment 108349 --> https://bugs.freedesktop.org/attachment.cgi?id=108349&action=edit Step 1 for incorrect result demonstration I have isolated a set of steps that result in the WRONG value being returned, which I consider much more serious than a blank value (it would be embarrassing to send out an invoice with a blank value, but if I invoice a customer with an incorrect value then that would be much worse). 1. Load the attached file 2. Delete row 5 3. Observe that the result in B3 for the VLOOKUP of "g" changes from 7 to 8, which is the value that "h" would have returned As with the earlier symptoms, saving the file after the delete and re-loading does not exhibit the problem. It occurs to me that the root cause of the problem appears to be that the results of the VLOOKUP are being held in the form of a cell reference, i.e. the VLOOKUP of "g" is stored in the form of "The contents of Cell D7", and the deletion of the row is not causing this cell reference to be re-assessed. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs