[Libreoffice-bugs] [Bug 99613] optional Paramaters for IF is optional

https://bugs.documentfoundation.org/show_bug.cgi?id=99613 sdc.bla...@youmail.dk changed: What|Removed |Added Assignee|libreoffice-b...@lists.free |sdc.bla...@youmail.dk

[Libreoffice-bugs] [Bug 99613] optional Paramaters for IF is optional

https://bugs.documentfoundation.org/show_bug.cgi?id=99613 --- Comment #11 from Eike Rathke --- Or rather canonical URL https://docs.oasis-open.org/office/OpenDocument/v1.3/OpenDocument-v1.3-part4-formula.html#IF -- You are receiving this mail because: You are the assignee for the

[Libreoffice-bugs] [Bug 99613] optional Paramaters for IF is optional

https://bugs.documentfoundation.org/show_bug.cgi?id=99613 --- Comment #10 from Eike Rathke --- Note that in IF(A1;;"something") the second argument *is* given, but given as empty argument. An empty argument usually evaluates to 0. Do not confuse absent (trailing optional argument omitted) and

[Libreoffice-bugs] [Bug 99613] optional Paramaters for IF is optional

https://bugs.documentfoundation.org/show_bug.cgi?id=99613 himajin100...@gmail.com changed: What|Removed |Added See Also|

[Libreoffice-bugs] [Bug 99613] optional Paramaters for IF is optional

https://bugs.documentfoundation.org/show_bug.cgi?id=99613 himajin100...@gmail.com changed: What|Removed |Added See Also|

[Libreoffice-bugs] [Bug 99613] optional Paramaters for IF is optional

https://bugs.documentfoundation.org/show_bug.cgi?id=99613 --- Comment #9 from Travis Stewart --- It is also strange because =IF(A1>5, , "too small") returns 0, the equivalent of FALSE, if A1>5 is true. -- You are receiving this mail because: You are the assignee for the

[Libreoffice-bugs] [Bug 99613] optional Paramaters for IF is optional

https://bugs.documentfoundation.org/show_bug.cgi?id=99613 --- Comment #8 from Travis Stewart --- I am not sure if I understand the original bug correctly, but I think there is an actual issue with the documentation or the IF function. The Logical Functions help page

[Libreoffice-bugs] [Bug 99613] optional Paramaters for IF is optional

https://bugs.documentfoundation.org/show_bug.cgi?id=99613 Buovjaga changed: What|Removed |Added Blocks|80430 | Referenced Bugs:

[Libreoffice-bugs] [Bug 99613] optional Paramaters for IF is optional

https://bugs.documentfoundation.org/show_bug.cgi?id=99613 Buovjaga changed: What|Removed |Added Status|UNCONFIRMED |NEW

[Libreoffice-bugs] [Bug 99613] optional Paramaters for IF is optional

https://bugs.documentfoundation.org/show_bug.cgi?id=99613 --- Comment #6 from Dennis Roczek --- The paragraph: "In the LibreOffice Calc functions, parameters marked as "optional" can be left out only when no parameter follows. For example, in a function with four

[Libreoffice-bugs] [Bug 99613] optional Paramaters for IF is optional

https://bugs.documentfoundation.org/show_bug.cgi?id=99613 m.a.riosv changed: What|Removed |Added Status|NEEDINFO

[Libreoffice-bugs] [Bug 99613] optional Paramaters for IF is optional

https://bugs.documentfoundation.org/show_bug.cgi?id=99613 --- Comment #4 from Dennis Roczek --- the problem is not the function itself, it is the documentation! -- You are receiving this mail because: You are the assignee for the bug.

[Libreoffice-bugs] [Bug 99613] optional Paramaters for IF is optional

https://bugs.documentfoundation.org/show_bug.cgi?id=99613 --- Comment #3 from m.a.riosv --- Created attachment 124773 --> https://bugs.documentfoundation.org/attachment.cgi?id=124773=edit Screenshot without error I can't see the error, perhaps I miss something.

[Libreoffice-bugs] [Bug 99613] optional Paramaters for IF is optional

https://bugs.documentfoundation.org/show_bug.cgi?id=99613 Dennis Roczek changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 99613] optional Paramaters for IF is optional

https://bugs.documentfoundation.org/show_bug.cgi?id=99613 m.a.riosv changed: What|Removed |Added Status|UNCONFIRMED