https://bugs.documentfoundation.org/show_bug.cgi?id=99986
--- Comment #11 from Eike Rathke <[email protected]> --- Code errors are evaluated during run time, not resulting in overall formula errors during compile time (with a few exceptions), hence if the faulty code is not executed in an IF() path no error occurs. Reason is that any error condition can be further evaluated using IFERROR() or ERROR.TYPE() or similar. If we stopped and set an error during compilation already that would not be possible or yield different results. What we maybe could do is catching the name error during formula cell input already, like is done for missing operators and operands and such. -- You are receiving this mail because: You are the assignee for the bug.
