Bonjour, Dans Calc, j'utilise la fonction SIERREUR dans une formule conditionnelle. Ma formule fonctionne dans des versions précédentes de Libre Office, mais plus maintenant en version 7.3.4.2. =(SI(CHERCHE($D$1;$B4)>=1;"x";SIERREUR(CHERCHE($D$1;$B4);""))) Vous trouverez mon fichier exemple à l'adresse : http://www.patcatnats.fr/IMG/ods/bretons_encuisine_recettes_recherche_ingredients_v20220619a.ods Merci de me tenir informé SVP. Amicalement, Patrice
Your link doesn't work. Please attach test file to the bug. Thank you
Created attachment 180912 [details] Fichier_Formules_Ok_Libre_Office_7.2.5.2 Fichier avec formules colonnes D et F qui bug avec Libre Office 7.3.4.2 mais fonctionne bien sous la version 7.2.5.2. J'ai changé ma formule (exemple en D4) en =SI(SIERREUR(CHERCHE($D$1;$B4);"")="";"";"x") , mais je ne trouve pas çà très propre.
[Automated Action] NeedInfo-To-Unconfirmed
This seems to have begun at the below commit. Adding Cc: to Eike Rathke; Could you possibly take a look at this one? Thanks afc8b4b5f7f2598d3183ff74f91467c97c4d1eec is the first bad commit commit afc8b4b5f7f2598d3183ff74f91467c97c4d1eec Author: Jenkins Build User <tdf@pollux.tdf> Date: Sun Dec 26 16:28:07 2021 +0100 source 1c14b9efb0677dea65ff220222fbb8d5c2aa6973 https://git.libreoffice.org/core/+/1c14b9efb0677dea65ff220222fbb8d5c2aa6973
DeepL translation: In Calc, I use the IFERROR function in a conditional formula. My formula works in previous versions of Libre Office, but not anymore in version 7.3.4.2. =(IF(SEARCH($D$1;$B4)>=1; "x";IFERROR(SEARCH($D$1;$B4);""))) File with formulas in columns D and F that bugs with Libre Office 7.3.4.2 but works fine under version 7.2.5.2. I changed my formula (example in D4) to =IF(IFERROR(SEARCH($D$1;$B4);"")="";""; "x") but I don't find it very clean.
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 "".
Thank Sorry, it's not good : =IFERROR(IF(SEARCH($D$1;$B4);"x");"")
What is not good?
Excuse me, ir's good, but Calc is french and in english its not good, also in french is : =SIERREUR(SI(CHERCHE($D$1;$B4);"x");"")