Bug 155548 - VLOOKUP and MATCH - random results
Summary: VLOOKUP and MATCH - random results
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.4.6.2 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-05-29 15:34 UTC by litihome
Modified: 2023-06-16 18:19 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
ods file where it happens (column D, sheet 'Etude') (65.55 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-05-29 15:37 UTC, litihome 		Details
screenshot on my LibO 7.4.6.2 (49.09 KB, image/png)
2023-05-29 15:38 UTC, litihome 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description litihome 2023-05-29 15:34:00 UTC 
Description:
Under LibO 7.4.6 (problem not seen since 3.x, not tested above),
VLOOKUP(lookup value 1; table_array 1; MATCH(lookup_value 2; table_array 2;0);0) seems to work randomly.

Sometimes, it's OK and sometimes, though the solution exists, it returns "#N/D".

Removing lines in table array can change the result.

Windows 10 pro (x64) / LibO 7.4.6.2 (x64)

Steps to Reproduce:
1.use VLOOKUP
2.use MATCH, as col_index_num in VLOOKUP
3.

Actual Results:
I don't really know

Expected Results:
Sometimes works, sometimes returns "#N/D"


Reproducible: Sometimes


User Profile Reset: No

Additional Info:
A value from a sheet
Comment 1 litihome 2023-05-29 15:37:01 UTC 
Created attachment 187586 [details]
ods file where it happens (column D, sheet 'Etude')
Comment 2 litihome 2023-05-29 15:38:53 UTC 
Created attachment 187587 [details]
screenshot on my LibO 7.4.6.2
Comment 3 ady 2023-05-29 20:25:28 UTC 
Problem not seen in 7.3.

Please test with 7.4.7.

Possibly solved by patch posted for bug 151958 comment 21.
Comment 4 itagure 2023-06-06 18:44:19 UTC 
the attached worksheet works correctly under:

Version: 7.5.3.2 (X86_64)
Build ID: 50(Build:2)
CPU threads: 12; OS: Linux 6.3; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 5 litihome 2023-06-16 06:20:25 UTC 
(In reply to ady from comment #3)
> Problem not seen in 7.3.
> 
> Please test with 7.4.7.
> 
> Possibly solved by patch posted for bug 151958 comment 21.

No problem with 7.4.7