Bug 49711 - VLOOKUP error. Returns false #N/A
Summary: VLOOKUP error. Returns false #N/A
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.4.4 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-05-09 18:18 UTC by Héctor Guerra
Modified: 2015-01-19 12:21 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Spreadsheet used to document bug. Contains de same list in Page Libros_1 and Libros_2 (51.83 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-05-09 18:18 UTC, Héctor Guerra
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Héctor Guerra 2012-05-09 18:18:20 UTC
Created attachment 61316 [details]
Spreadsheet used to document bug. Contains de same list in Page Libros_1 and Libros_2

When using VLOOKUP(), it returns false #N/A. 

Apparently occurs when there are special characters. In this case "(" and "[".
In the spreadsheet I created for test, column A in page Libros_1 are equal to column A in page Libros_2.

I use Ubuntu 11.10
Comment 1 Juan Rey 2012-05-21 01:35:26 UTC
Same here with Windows 7 and 3.5.3 or 3.5.4rc1
Comment 2 Héctor Guerra 2012-05-21 16:55:09 UTC
Apparently it is a configuration problem.

I go through Tools/Options/LibreOffice Calc/Calc. Then uncheck the "Allow regular expressions in formulas" option and it works. 
(My system is in Spanish so they may not be the exact words.)

However, the next time I start the program, I have to repeat the steps.
Comment 3 GerardF 2013-03-02 10:36:04 UTC
(In reply to comment #2)
> Apparently it is a configuration problem.
> 
> I go through Tools/Options/LibreOffice Calc/Calc. Then uncheck the "Allow
> regular expressions in formulas" option and it works. 
> (My system is in Spanish so they may not be the exact words.)
> 
> However, the next time I start the program, I have to repeat the steps.

This option is a "per document" setting. The option is stored within the doc, so you don't have to repeat when reopening the same doc.
Changing only affect the document in use and new created documents, not alredy created docs.