https://bugs.freedesktop.org/show_bug.cgi?id=79180
--- Comment #3 from pierre-yves samyn <pierre-yves.sa...@laposte.net> --- Hi (In reply to comment #2) > Hard recalc [shift+Ctrl+F9] does the calculation. > https://help.libreoffice.org/Calc/Recalculate > Set up the option in: > Menu/Tools/LibreOffice calc/Formula - Recalculation on file load - Excel > 2007 and newer - Always recalculate. > also does the job. Yes of course, but that is not the question. The cell should display #N/A before recalculating. Regards Pierre-Yves -- 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