https://bugs.documentfoundation.org/show_bug.cgi?id=96476
m.a.riosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED CC| |[email protected] | |rg Resolution|--- |NOTABUG --- Comment #2 from m.a.riosv <[email protected]> --- Hi, >From a VLOOKUP it's not possible to get an empty cell at most you can get a cell with an empty string. List.B2 =IF(VLOOKUP(A2;Inventory.$A$1:$B$7;2;0);VLOOKUP(A2;Inventory.$A$1:$B$7;2;0);"") Dates in calc are stored as integers being the zero 31/12/1899. https://help.libreoffice.org/Calc/Date_and_Time_Functions -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
