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

[bugzilla-daemon]

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
   |desktop.org |

-- 
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 99613] optional Paramaters for IF is optional

[bugzilla-daemon]

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 bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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 empty null
arguments.

See also ODFF 6.15.4 IF
https://docs.oasis-open.org/office/OpenDocument/v1.3/cs01/part4-formula/OpenDocument-v1.3-cs01-part4-formula.html#IF

-- 
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 99613] optional Paramaters for IF is optional

[bugzilla-daemon]

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

himajin100...@gmail.com changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=10
   ||2381

-- 
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 99613] optional Paramaters for IF is optional

[bugzilla-daemon]

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

himajin100...@gmail.com changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=11
   ||9035

-- 
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 99613] optional Paramaters for IF is optional

[bugzilla-daemon]

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 bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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
(https://help.libreoffice.org/7.0/en-US/text/scalc/01/04060105.html?=WRITER=UNIX)
talks about optional parameters using a hypothetical 4 parameter function.

"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
parameters, where the last two parameters are marked as "optional", you can
leave out parameter 4 or parameters 3 and 4, but you cannot leave out parameter
3 alone."

By applying this example to the IF function, where parameters 2 and 3 are
optional, you can use it with all 3 parameters included or with parameters 1
and 2 only, but you can't use it with parameters 1 and 3 with 2 left out.

This is the expected behaviour:
=IF(A1>5,100,"too small") is valid. If A1 <= 5 it returns "too small" otherwise
it returns 100.
=IF(A1>5,100) is also valid. It returns 100 if A1 > 5 is TRUE, and FALSE
otherwise. Parameter 3 is left out, but that's okay because no parameter
follows it.
=IF(A1>5, , "too small") is invalid because you can only leave out optional
parameters if no parameters follow. But in this case, the optional parameter 2
is left out and followed by a parameter. You'd expect an error, it shouldn't
work based on the statement in the documentation.

But you can leave out parameter 2 and it still does something, even though the
documentation says it can't be left out.
=IF(A1>5, , "too small"), A1 > 5 it returns 0, if it is <= 5, it returns "too
small"

If the documentation is correct, it should not interpret an empty parameter as
a 0 and use that as the ThenValue. If the documentation is wrong, then how it
handles empty parameters needs to be discussed in the documentation.

-- 
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 99613] optional Paramaters for IF is optional

[bugzilla-daemon]

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

Buovjaga  changed:

   What|Removed |Added

 Blocks|80430   |


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=80430
[Bug 80430] [META] LOCALHELP: Features x Documentation gap
-- 
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 99613] optional Paramaters for IF is optional

[bugzilla-daemon]

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

Buovjaga  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||todven...@suomi24.fi
 Ever confirmed|0   |1

--- Comment #7 from Buovjaga  ---
Let's set to NEW.

-- 
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 99613] optional Paramaters for IF is optional

[bugzilla-daemon]

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
parameters, where the last two parameters are marked as "optional", you can
leave out parameter 4 or parameters 3 and 4, but you cannot leave out parameter
3 alone."

is wrong. Parameter 2 and 3 can omitted - this paragraph indicates something
different!

-- 
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 99613] optional Paramaters for IF is optional

[bugzilla-daemon]

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

m.a.riosv  changed:

   What|Removed |Added

 Status|NEEDINFO|UNCONFIRMED
 Ever confirmed|1   |0

--- Comment #5 from m.a.riosv  ---
Sorry I can't understand what it's exactly bad in the help, sure my non
English.

-- 
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 99613] optional Paramaters for IF is optional

[bugzilla-daemon]

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 mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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.

-- 
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 99613] optional Paramaters for IF is optional

[bugzilla-daemon]

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

Dennis Roczek  changed:

   What|Removed |Added

 CC||dennisroc...@libreoffice.or
   ||g

--- Comment #2 from Dennis Roczek  ---
Hi miguel,
well it doesn't matter if it return 0 or FALSE (depending on the ; or the
formatting of the cell): the complete sentence is wrong: the sentence imply
that an ERR:501 appear similar to =ACOS()

so, simplest "solution" would be to remove the complete sentence as it is
untrue.

-- 
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 99613] optional Paramaters for IF is optional

[bugzilla-daemon]

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

m.a.riosv  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEEDINFO
 CC||miguelangelrv@libreoffice.o
   ||rg
 Ever confirmed|0   |1

--- Comment #1 from m.a.riosv  ---
Hi @Dennis, it returns zero, it's not right?

The only thing could be that the cell is not auto-formatted as Boolean, but
there is not calculation in the parameters to forces it, and an IF can returns
any type of result not necessarily a Boolean.

Suppressing both parameters =IF("a"="b") then returns FALSE, inheriting from
the comparison inside the function.

-- 
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