https://bugs.freedesktop.org/show_bug.cgi?id=43919
GerardF <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution| |NOTABUG CC| |[email protected] --- Comment #1 from GerardF <[email protected]> 2011-12-18 00:54:42 UTC --- Hi, [ is a special character. If you want to use VLOOKUP with cells containing special characters : 1. If you don't need to use them in other formulae in the same file : Turn of "enable regular expressions in formulas" in the menu Tools > Options > LO Calc > Calculate. 2. If you used them in other cells : Place the escape character \ (backslash) before with the SUBSTITUTE function. =VLOOKUP(SUBSTITUTE(C6;"[";"\[");C4:D9;2;0) The special characters are . ^ $ * + ? \ [ ( { | Regular expressions in Calc functions : http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Regular_Expressions_in_Calc#Regular_expressions_in_Calc_functions Closed "Not a bug" -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- 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
