[Libreoffice-bugs] [Bug 149624] Fonction sierreur
https://bugs.documentfoundation.org/show_bug.cgi?id=149624 Eike Rathke changed: What|Removed |Added Keywords|regression | -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149624] Fonction sierreur
https://bugs.documentfoundation.org/show_bug.cgi?id=149624 Eike Rathke changed: What|Removed |Added Resolution|FIXED |NOTABUG Status|RESOLVED|CLOSED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149624] Fonction sierreur
https://bugs.documentfoundation.org/show_bug.cgi?id=149624 Patrice Morel changed: What|Removed |Added Resolution|--- |FIXED Status|NEEDINFO|RESOLVED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149624] Fonction sierreur
https://bugs.documentfoundation.org/show_bug.cgi?id=149624 --- Comment #9 from Patrice Morel --- 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");"") -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149624] Fonction sierreur
https://bugs.documentfoundation.org/show_bug.cgi?id=149624 Eike Rathke changed: What|Removed |Added Regression By|Eike Rathke | -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149624] Fonction sierreur
https://bugs.documentfoundation.org/show_bug.cgi?id=149624 Eike Rathke changed: What|Removed |Added Status|REOPENED|NEEDINFO --- Comment #8 from Eike Rathke --- What is not good? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149624] Fonction sierreur
https://bugs.documentfoundation.org/show_bug.cgi?id=149624 Patrice Morel changed: What|Removed |Added Status|CLOSED |REOPENED Resolution|NOTABUG |--- --- Comment #7 from Patrice Morel --- Thank Sorry, it's not good : =IFERROR(IF(SEARCH($D$1;$B4);"x");"") -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149624] Fonction sierreur
https://bugs.documentfoundation.org/show_bug.cgi?id=149624 Eike Rathke changed: What|Removed |Added Status|RESOLVED|CLOSED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149624] Fonction sierreur
https://bugs.documentfoundation.org/show_bug.cgi?id=149624 Eike Rathke changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |NOTABUG --- Comment #6 from Eike Rathke --- 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.
[Libreoffice-bugs] [Bug 149624] Fonction sierreur
https://bugs.documentfoundation.org/show_bug.cgi?id=149624 --- Comment #5 from Eike Rathke --- 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. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149624] Fonction sierreur
https://bugs.documentfoundation.org/show_bug.cgi?id=149624 raal changed: What|Removed |Added Ever confirmed|0 |1 OS|Windows (All) |All Status|UNCONFIRMED |NEW CC||er...@redhat.com Keywords||bibisected, bisected, ||regression Regression By||Eike Rathke --- Comment #4 from raal --- 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 Date: Sun Dec 26 16:28:07 2021 +0100 source sha:1c14b9efb0677dea65ff220222fbb8d5c2aa6973 https://git.libreoffice.org/core/+/1c14b9efb0677dea65ff220222fbb8d5c2aa6973 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149624] Fonction sierreur
https://bugs.documentfoundation.org/show_bug.cgi?id=149624 QA Administrators changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149624] Fonction sierreur
https://bugs.documentfoundation.org/show_bug.cgi?id=149624 --- Comment #3 from QA Administrators --- [Automated Action] NeedInfo-To-Unconfirmed -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149624] Fonction sierreur
https://bugs.documentfoundation.org/show_bug.cgi?id=149624 Patrice Morel changed: What|Removed |Added CC||patr...@patcatnats.fr --- Comment #2 from Patrice Morel --- Created attachment 180912 --> https://bugs.documentfoundation.org/attachment.cgi?id=180912=edit 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. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 149624] Fonction sierreur
https://bugs.documentfoundation.org/show_bug.cgi?id=149624 raal changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 CC||r...@post.cz --- Comment #1 from raal --- Your link doesn't work. Please attach test file to the bug. Thank you -- You are receiving this mail because: You are the assignee for the bug.