Bug ID: 111675
           Summary: UI: Functions IFS does not work together with function
           Product: LibreOffice
           Version: release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc

Using Function IFS and CURRENT within Test expressions leads to not
comprehensible results.

Target/background: A cell (referencing whatever, e.g. COUNTIF etc.) should have
a STYLE() applied, depending on another cell's value, e.g. a treshold in a real
life example

Works with nested if, does NOT WORK with IFS. Example uploaded.

Steps to Reproduce:
All in uploaded "SampleSTYLE.ods":

Both ref value B2 and Treshold value B3 are the same, e.g. 4

Actual Results:  
(B5) =B2+STYLE(IFS(CURRENT()<B3;"Grün";CURRENT()=B3;"Gelb";CURRENT()>B3;"Rot")) 
leads to 4 with "Rot" = RED, wrong as CURRENT()=B3 is TRUE!

leads to 4 with "Gelb" = YELLOW, correct.

Expected Results:
IFS should be able to work in combination with CURRENT

Reproducible: Always

User Profile Reset: No

Additional Info:

User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101

You are receiving this mail because:
You are the assignee for the bug.
Libreoffice-bugs mailing list

Reply via email to