https://bugs.freedesktop.org/show_bug.cgi?id=77990
--- Comment #14 from Laurent BP <[email protected]> --- The bug occurs with the following conditions: - MATCH function with type=0 (exact match) - search criterion is formatted as date - search criterion is a formula Create a test case from scratch (see attached file): - create a new spreadsheet - format cell A1 as date - insert formula in A1 "=B1" - insert a text in B1 such as "test2" - in C1:C3 insert text "test1" "test2" "test3" - in A2 insert formula "=MATCH(A1;C1:C3;0)" Result is 2 as expected - save file - File > Reload => MATCH function returns #N/A Ctrl+Shift+F9 calculates correctly -- 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
