https://bugs.freedesktop.org/show_bug.cgi?id=45134
GerardF <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEW CC| |[email protected] Ever Confirmed|0 |1 --- Comment #1 from GerardF <[email protected]> 2012-01-23 09:49:20 PST --- (In reply to comment #0) > If INDIRECT is replaced by its result (here "FRANCE") > =IF(ISNUMBER($A17);VLOOKUP($A17;France;B$15;FALSE());"") > the formula computes properly. When i hit Ctrl+F3, i saw the name "France". In K17 you write "FRANCE". If i change "FRANCE" for "France" in K17 (same case as defined name) it works. -- 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
