https://bugs.freedesktop.org/show_bug.cgi?id=81395
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #1 from Eike Rathke <[email protected]> --- The SEARCH function (RICERCA) understands regular expressions, where a single dot stands for "any character", so it matches the first character present in the text to be searched. If you do not want the dot to be interpreted as a regular expression meta-character, *either* escape it by a backslash so RICERCA("\.";F2), *or* switch off regular expressions altogether in all spreadsheet functions under Tools->Options->Calc->Calculate "General Calculations" -> "Enable regular expressions in formulas". Apache OO should have the same setting, it might had been disabled when you tried, MS-Excel does not know regular expressions at all. For more information on regular expressions see the LibreOffice online help term "regular expressions;list of". -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
