https://bugs.documentfoundation.org/show_bug.cgi?id=149081
Bug ID: 149081
Summary: Match function in 'Calc' error with tilde
Product: LibreOffice
Version: 7.2.5.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
The MATCH() function in LibreOffice Calc does not work with entries that have
tildes (~) (except if it is the last character), returning #N/A rather than the
expected location.
Steps to Reproduce:
1. Use the MATCH() function in Calc to search for match of a character with a
tilde in the middle (not the last character in the cell, which works ok)
1a. Example: MATCH("Test~Middle",A1:A3,0) will never find a cell with the entry
"Test~Middle"
Actual Results:
A Test!! =MATCH(A1,A1:A3,0) 1
TestEnd~ =MATCH(A2,A1:A3,0) 2
Test~Middle =MATCH(A3,A1:A3,0) #N/A
=MATCH("Test~Middle",A1:A3,0) #N/A
Expected Results:
A Test!! =MATCH(A1,A1:A3,0) 1
TestEnd~ =MATCH(A2,A1:A3,0) 2
Test~Middle =MATCH(A3,A1:A3,0) 3
=MATCH("Test~Middle",A1:A3,0) 3
Reproducible: Always
User Profile Reset: No
Additional Info:
The similar functions SUBSTITUTE() and FIND() both work as expected.
--
You are receiving this mail because:
You are the assignee for the bug.
