Spreadsheet: FIND() doesn't find """" whereas SEARCH does

[roydenyates]

This issue is unique.

• I have used the search tool and did not find an issue describing my bug.

Operating System

Linux (DEB package)

Version information

version 8.0.1.31 (deb)

Expected Behavior

=FIND() should be able to locate a string with " that is found by SEARCH()

Actual Behavior

FIND() results in #VALUE!

Reproduction Steps

Reference cell (A1) content "31° 57' 14.6" S BT 3 18° 54' 20.3" E"

=FIND(""" S",A1,1) gives #VALUE!
=SEARCH(""" S",A1,1) gives 13

Additional information

LibreOffice Calc gives 13 with both functions when searching for "

Issue is specific to " as,

Reference cell (A1) content "31° 52.746' S BDW 1 18° 58.667' E"

=FIND("' S",A1,1) gives 11
=SEARCH("' S",A1,1) gives 11

[VladimirProkofiev52]

Hello! @roydenyates
I can confirm - this is bug, issue #68343.

Problem can be reproduced in DocumentServer.

Thanks for your report!