[Libreoffice-bugs] [Bug 111675] UI: Functions IFS does not work together with function CURRENT

[bugzilla-daemon at bugs.documentfoundation.org]

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

Michael <michaelof at rocketmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|CLOSED                      |REOPENED
         Resolution|NOTABUG                     |---
     Ever confirmed|0                           |1

--- Comment #9 from Michael <michaelof at rocketmail.com> ---
(In reply to Eike Rathke from comment #8)
> IFS() evaluates conditions until it finds a matching one,
> sprinkling CURRENT() all over makes it depend on internal behaviour what
> arguments will be evaluated first, which currently may be all before IFS()
> is called and in future may be only the ones until one is matched.
> 

As I opened this bug, I would be thankful if this bug is not going to be closed
because someone else's examples or additions might be misleading or independent
of my bug. 

If you look on my example attached
(https://bugs.documentfoundation.org/attachment.cgi?id=135441), the IFS formula
in B5 is: 

=B2+STYLE(IFS(CURRENT()<B3;"Grün";CURRENT()=B3;"Gelb";CURRENT()>B3;"Rot"))

And my question is: For B3 constantly being e.g. "4", how could a value of "4"
for B2 lead to the condition "CURRENT()>B3" being selected by IFS() ??? 

--> As ONLY the condition "CURRENT()=B3" is applicable, IMHO it does not have
any impact if IFS() evaluates sub-formulas from left to right, or vice versa.

In the attached example LO shows a value of "4" for B5, so for whatever reason
CURRENT might return any other value than "4", and as B3 is also "4", how could
ever the condition "CURRENT()>B3" evaluated as true ??

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180310/904fa419/attachment.html>