https://bugs.documentfoundation.org/show_bug.cgi?id=149624

Eike Rathke <er...@redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #6 from Eike Rathke <er...@redhat.com> ---
That is exactly what that commit was about to fix bug 146377. Error values in
the IF() condition are to be propagated and not ignored taking the ELSE path.
In the past the expression worked by chance, but is not correct.
See also
https://wiki.documentfoundation.org/ReleaseNotes/7.3#Changed_spreadsheet_functions

This should work:

=IFERROR(IF(SEARCH($D$1;$B4);"x");"")

In the success case SEARCH() returns a value >=1 so the condition would be TRUE
(for any value <>0) and the THEN path of "x" would be executed. Otherwise if
SEARCH() returns an error value propagated by IF() the IFERROR() catches that
and returns "".

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to