[Libreoffice-bugs] [Bug 126016] falla en la ayuda de la estructura función "SI" al usar paréntesis en la zona de valor si verdadero
https://bugs.documentfoundation.org/show_bug.cgi?id=126016 Jacques Guilleron changed: What|Removed |Added Resolution|--- |NOTABUG Status|UNCONFIRMED |RESOLVED --- Comment #3 from Jacques Guilleron --- Hi jhon, Julien, "Y", "O" are the "AND" and "OR" functions. This is not obvious at first glance to read that, ahd this cannot be translated. That's why you have to write your report in English. So, you have written: =SI(Y(A1>0,B2>0),(10*20),"") in English =IF(AND(A1>0,B2>0),(10*20),"") To work, you have to change all the "," by ";" =SI(Y(A1>0B2>0),(10*20),"") in Eglish =IF(AND(A1>0;B1>0);(10*20);"") See the small attachment. Jacques -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126016] falla en la ayuda de la estructura función "SI" al usar paréntesis en la zona de valor si verdadero
https://bugs.documentfoundation.org/show_bug.cgi?id=126016 --- Comment #2 from Jacques Guilleron --- Created attachment 152335 --> https://bugs.documentfoundation.org/attachment.cgi?id=152335=edit The test file. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 126016] falla en la ayuda de la estructura función "SI" al usar paréntesis en la zona de valor si verdadero
https://bugs.documentfoundation.org/show_bug.cgi?id=126016 Julien Nabet changed: What|Removed |Added CC||serval2...@yahoo.fr --- Comment #1 from Julien Nabet --- Google translate (I don't know if it's accurate or not). Description: if I nest some comparative function like "Y" or the function "O" or "XOR" as a logical condition in the "if" function, and if I open a parenthesis in the value "if true", it re-enters the comparison function , the formula works, but it is visualized as if it were inside the comparative function, I tried with the functions "Y" "O" "XOR", I have not tried with other functions but I assume they have the same problem Steps to reproduce: 1.write for example this function = yes (y (a1> 0, b1> 0), (10 * 20), "") 2. When clicking within (10 * 20) what should be the "if true" zone in the structure of the formula appears as if it were inside the "Y" function 3. The operation is fine of the formula, but the help or the structure that appears as a help is as if it were inside the "Y" function Actual Results: the operation is fine of the formula, but the help or structure appears as if it were inside the "Y" function Expected Results: If I use parentheses in "value if true" despite using parentheses it should be kept in that part of the structure of the "yes" function, the "Y" function should not appear again because it is already closed 5.2.7 is EOL, could you give a try to a recent LO version (6.2.4)? Also, could you explain in English for the next time. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs