Bug 129023 - FIND will match apostrophe in string constant but not cell reference
Summary: FIND will match apostrophe in string constant but not cell reference
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.3.6.1 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Function
  Show dependency tree / graph
 
Reported: 2019-11-25 19:31 UTC by Garrett Goebel
Modified: 2019-11-26 22:01 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Garrett Goebel 2019-11-25 19:31:54 UTC 
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:
Comment 1 Roman Kuznetsov 2019-11-26 10:41:27 UTC 
Please add info from Help->About dialog
Comment 2 Garrett Goebel 2019-11-26 12:40:50 UTC 
Version: 5.3.6.1
Build ID: 5.3.6.1-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
Comment 3 Roman Kuznetsov 2019-11-26 13:03:58 UTC 
(In reply to Garrett Goebel from comment #2)
> Version: 5.3.6.1
> Build ID: 5.3.6.1-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
Comment 4 m_a_riosv 2019-11-26 22:01:56 UTC 
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.