https://bugs.documentfoundation.org/show_bug.cgi?id=88581
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also|https://bugs.freedesktop.or | |g/show_bug.cgi?id=67633 | --- Comment #9 from Eike Rathke <[email protected]> --- Might be possible to disable it per default, the actual option setting is stored with the document so existing documents using it should not be harmed. Needs to be verified. (In reply to Kevin Suo from comment #1) > However, in my opinion this is not the case, this is really a bug. > "Allow regular expressions in formulas" means regular expressions in > *FORMULAS* are allowed. > But in the formula "=VLOOKUP(A2,E1:F1,2,0)" there are no regular > expressions, only reference to cells. (The regular expressions are in cell > references, not in *FORMULAS". Not true. Affected is the lookup-value (string to be searched), it doesn't matter if the argument appears literally in the expression or is fetched through a reference or is the result of another expression. (In reply to Kevin Suo from comment #2) > Bug 67633 - EDITING: SEARCH function doesn't find text in cells containing > hyperlinks (Closed as FIXED, which is wrong status. hyperlinks contains "." > which is a regular expression, this is the real cause of the bug) Not true. Matched is the resulting cell string and that example works in more recent releases. -- 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
