[Libreoffice-ux-advise] [Bug 88581] Set 'Enable regular expression' off by default

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=88581

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           See Also|https://bugs.freedesktop.or |
                   |g/show_bug.cgi?id=67633     |

--- Comment #9 from Eike Rathke <erack at redhat.com> ---
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 on the CC list for the bug.