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:
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
C1 shows #VALUE
C1 should show 2
User Profile Reset: No
Please add info from Help->About dialog
Build ID: 18.104.22.168-19.el7
CPU Threads: 4; OS Version: Linux 3.10; UI Render: default; VCL: gtk3; Layout Engine: new;
Locale: en-US (en_US.UTF-8); Calc: group
(In reply to Garrett Goebel from comment #2)
> Version: 22.214.171.124
> Build ID: 126.96.36.199-19.el7
> CPU Threads: 4; OS Version: Linux 3.10; UI Render: default; VCL: gtk3;
> Layout Engine: new;
> Locale: en-US (en_US.UTF-8); Calc: group
Please update your libreoffice to more modern version, like 6.2.8 or 6.3.3
Yiu can download an installer (rpm or deb packages) from libreoffice.org/download page
Then try retest your problem
I don't know how but there is a different apostrophe in A1 than in the formulas.
The first one in A1 is a ASCII code 146, in the formulas is an ASCII code 39.
Using the same apostrophe works fine.