Bug 91787 - MATCH simple text match is not exact
Summary: MATCH simple text match is not exact
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.7.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-06-01 02:18 UTC by jmichaud02478
Modified: 2015-06-01 02:45 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description jmichaud02478 2015-06-01 02:18:10 UTC
Enter "isnotexact" and "isexact" in A1 and A2.
Enter "=MATCH("is",A1:A2,0)" in B1.

B1 displays "1" but should display "#N/A".
Comment 1 jmichaud02478 2015-06-01 02:44:46 UTC
Scratch that.  The option to "Search criteria = and <> must apply to whole cells" is advertised as providing the needed behavior.