https://bugs.documentfoundation.org/show_bug.cgi?id=149081
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #1 from Eike Rathke <[email protected]> --- You most likely have Wildcards enabled (which is the default as in Excel), in which the tilde character is a meta character that "Escapes the special meaning of a question mark, asterisk, or tilde character that follows immediately after the tilde character." See https://help.libreoffice.org/7.3/en-GB/text/scalc/guide/wildcards.html With Wildcards enabled you have to double the tilde character to search for a literal tilde character, like "Test~~Middle". Or switch off using wildcards and regular expressions in formulas, under Tools - Options - LibreOffice Calc - Calculate. -- You are receiving this mail because: You are the assignee for the bug.
