Download it now!
Bug 89013 - Regular expressions doesn't work with MATCH and VLOOKUP when searched range is in other file.
Summary: Regular expressions doesn't work with MATCH and VLOOKUP when searched range i...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 127487 (view as bug list)
Depends on:
Blocks: Calc-Function
  Show dependency treegraph
 
Reported: 2015-02-01 14:27 UTC by m.a.riosv
Modified: 2019-10-10 16:52 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Source data file (10.58 KB, application/x-vnd.oasis.opendocument.spreadsheet)
2015-02-01 14:27 UTC, m.a.riosv
Details
Sample file to test (11.79 KB, application/x-vnd.oasis.opendocument.spreadsheet)
2015-02-01 14:27 UTC, m.a.riosv
Details

Note You need to log in before you can comment on or make changes to this bug.
Description m.a.riosv 2015-02-01 14:27:03 UTC
Created attachment 113022 [details]
Source data file

MATCH and VLOOKUP don't work when the look up array is in other file. It works without regular expression, and seems doesn't matter how the options for regular expression are in Menu/Tools/Options/LibreOffice calc/Calculate.

Attached source data file, and in the next comment target file.

All versions affected and Aoo 4.1

Strange this issue hasn't been reported. At least I can find it.
Comment 1 m.a.riosv 2015-02-01 14:27:47 UTC
Created attachment 113023 [details]
Sample file to test
Comment 2 raal 2015-02-02 13:21:59 UTC
I can confirm with LO 4.4, win7.
Comment 3 QA Administrators 2017-01-03 19:41:51 UTC Comment hidden (obsolete)
Comment 4 m.a.riosv 2017-03-05 22:56:38 UTC
*** Bug 106334 has been marked as a duplicate of this bug. ***
Comment 5 QA Administrators 2018-03-06 03:43:59 UTC Comment hidden (obsolete)
Comment 6 m.a.riosv 2018-03-06 09:59:42 UTC
Still with:
Version: 6.0.2.1 (x64)
Build ID: f7f06a8f319e4b62f9bc5095aa112a65d2f3ac89
CPU threads: 4; OS: Windows 10.0; UI render: default; 
Locale: es-ES (es_ES); Calc: CL
Comment 7 m.a.riosv 2018-04-01 14:39:40 UTC
Still with:
Version: 6.1.0.0.alpha0+
Build ID: 83204c1fbf2cb85f3a22a922411ed8291cfb3fe8
CPU threads: 4; OS: Windows 10.0; UI render: GL; 
TinderBox: Win-x86@42, Branch:master, Time: 2018-03-28_23:56:15
Comment 8 QA Administrators 2019-04-02 02:49:33 UTC Comment hidden (obsolete)
Comment 9 m.a.riosv 2019-04-02 07:29:12 UTC
Strill
Version: 6.3.0.0.alpha0+ (x64)
Build ID: f42d729e41da918bc496d5feb5861a09737c438a
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2019-03-31_01:39:38
Locale: es-ES (es_ES); UI-Language: en-US
Calc: CL
Comment 10 Alex Thurgood 2019-09-16 07:44:36 UTC
*** Bug 127487 has been marked as a duplicate of this bug. ***