[Libreoffice-bugs] [Bug 129023] New: FIND will match apostrophe in string constant but not cell reference

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 129023
           Summary: FIND will match apostrophe in string constant but not
                    cell reference
           Product: LibreOffice
           Version: 5.3.6.1 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: garrett.goebel at gmail.com

Description:
FIND produces different results which trying to match an apostrophe in a string
constant ("5'4""") vs a cell reference containing that value (A1).

Steps to Reproduce:
In the following cells type the following:
A1 5'4"
B1 =FIND("'", "5'4""") result shown = 2
B2 =FIND("4", "5'4""") result shown = 3
C1 =FIND("'", A1) result shown = #VALUE
C2 =FIND("4", A1) result shown = 3

Would expect C1 to show the same result as B1

Actual Results:
C1 shows #VALUE

Expected Results:
C1 should show 2


Reproducible: Always


User Profile Reset: No



Additional Info:

-- 
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/20191125/7d37d71e/attachment-0001.html>