https://bugs.freedesktop.org/show_bug.cgi?id=87524
--- Comment #5 from Óvári <ov...@hotmail.com> --- (In reply to GerardF from comment #3) > 0 result is due to the IF function. VLOOKUP alone returns empty string. If you delete 'cash' and re-type 'cash' then the result is a blank (different to when the file was opened). The output value of the function is different even though the input values are the same. The value a function outputs should be the same for given input values; however, the output of the function is different based on if the file is opened or if it is entered once the file is opened. -- 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