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: bibisectRequest
: 127487 147685 (view as bug list)
Depends on:
Blocks: Calc-Function
  Show dependency treegraph
 
Reported: 2015-02-01 14:27 UTC by m_a_riosv
Modified: 2024-07-30 05:54 UTC (History)
6 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. ***
Comment 11 [REDACTED] 2021-02-08 13:35:18 UTC
Still in 

Version: 7.0.4.2
Build ID: dcf040e67528d9187c66b2379df5ea4407429775
CPU threads: 8; OS: Linux 5.3; UI render: GL; VCL: kf5
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded
Comment 12 [REDACTED] 2021-02-08 13:43:40 UTC
Still repro in

Version: 7.1.0.3 / LibreOffice Community
Build ID: f6099ecf3d29644b5008cc8f48f42f4a40986e4c
CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: kf5
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 13 Don Anderson 2021-02-08 14:38:01 UTC
These operations seem to work if the other array source files are pre-loaded into memory before executing the MATCH and VLOOKUP operations.
Comment 14 raal 2022-07-30 23:03:30 UTC
*** Bug 147685 has been marked as a duplicate of this bug. ***
Comment 15 QA Administrators 2024-07-30 03:13:44 UTC Comment hidden (obsolete)
Comment 16 m_a_riosv 2024-07-30 05:52:03 UTC
With
Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 46f7dcc5f499892ef093147b3f739c258bbf6b81
CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded

MATCH() works now.
VLOOKUP() still doesn't work.


First version that MATCH() works and VLOOKUP() fails on the ones I have installed.
Version: 24.8.0.1.0+ (X86_64) / LibreOffice Community
Build ID: 9bba9dede3def626e3adab6696a911762e25b7ff
CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded

Last version with both functions MATCH() and VLOOKUP() fails on the ones I have installed.
Version: 24.2.5.2 (X86_64) / LibreOffice Community
Build ID: bffef4ea93e59bebbeaf7f431bb02b1a39ee8a59
CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded
Comment 17 m_a_riosv 2024-07-30 05:54:10 UTC
Bibisect where MATCH() is now working, could help to solve the issue also to VLOOKUP()