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

            Bug ID: 100214
           Summary: Function MATCH() ignores "+" sign in search criterium
           Product: LibreOffice
           Version: 5.1.3.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs@lists.freedesktop.org
          Reporter: themojo...@gmx.de

Here is a simple test case to reproduce the bug. Cells A1 - A3 should contain
the following text

A1: b-
A2: b
A3: b+

Now enter e.g. in cell B1:  =MATCH("b-";A1:A3;0)  ->  1  ->  correct
change it to:               =MATCH("b";A1:A3;0)   ->  2  ->  correct
change it to:               =MATCH("b+";A1:A3;0)  ->  2  ->  incorrect

The error appeared for me when I updated my system from Ubuntu 15.10 to Ubuntu
16.04 which now uses LibreOffice 5. Todays update to version 5.1.3.2 did not
fix the problem. I am using the german version of LibreOffice, the
corresponding german function reads  =VERGLEICH("b+";A1:A3;0).

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

Reply via email to