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

m_a_riosv <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOTABUG
                 CC|                            |[email protected]
                   |                            |rg

--- Comment #2 from m_a_riosv <[email protected]> ---
The condition is always false. A way is to verify the formula in the
spreadsheet. In this case it's easy, copy CF formula in B1 and drag down.

If I understand what is looking for, a more simple formula like:
INDEX(B:B;MATCH("X";$A:$A;0))="YES"
works just fine for me.
Don't forget to verify the option:
Menu/Tools/LibreOffice Calc/Calculate — Case sensitive.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to