https://bugs.freedesktop.org/show_bug.cgi?id=88581
Kevin Suo <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Hardware|x86 (IA32) |All Version|4.4.0.2 rc |3.4.4 release See Also| |https://bugs.freedesktop.or | |g/show_bug.cgi?id=49711 OS|Windows (All) |All --- Comment #1 from Kevin Suo <[email protected]> --- This issue seems the same as described in bug 49711. That bug was closed as NOTABUG per the following comment: https://bugs.freedesktop.org/show_bug.cgi?id=49711#c2 Which says disable "Allow regular expressions in formulas" solves the proble. 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". If the devs insists that "Allow regular expressions in formulas" = "Allow regular expressions in formulas, including regular expressions in values returned by cell references", then the option "Allow regular expressions in formulas" should be disabled by default in Calc. Enabling this option will cause confuse for users (Who knows what special chars are regular expressions? and how many people know that we can use regular expressions in formulas?) -- 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
