Bug 167439 - MATCH gives wrong result with inline array and calculation setting wildcard on, whole cell off
Summary: MATCH gives wrong result with inline array and calculation setting wildcard o...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.2.0.0 alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-07-09 14:49 UTC by Regina Henschel
Modified: 2025-07-09 21:55 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Test cases for match mode 0 wildcard (15.25 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-07-09 14:49 UTC, Regina Henschel 		Details
The same file with regular expressions. (15.65 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-07-09 21:49 UTC, m_a_riosv 		Details
Screenshot how file with wildcards looks in Excel. (63.32 KB, image/png)
2025-07-09 21:50 UTC, m_a_riosv 		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 Regina Henschel 2025-07-09 14:49:02 UTC 
Created attachment 201717 [details]
Test cases for match mode 0 wildcard

Open attached file. The calculation settings in Tools > Options > Calc > Calculate are set to "Wildcard ON" and "..must apply to whole cell OFF". [The information is contained in the file. Nevertheless you should verify, that they are as expected in Tools > Options > Calc > Calculate. If the settings are not as described, that would be a separate bug.]

The two blocks use same search vector and same query values. Only the first block has the search vector as inline array and the second block as reference to a cell range.

The cases with query value "B" and "C" are wrong in case of inline-array.

I see the error in a debug build Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 0ab2da12fb6ea515339b113f622720b11c65afca
CPU threads: 32; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win
Locale: de-DE (de_DE); UI: en-US
Calc: threaded

The build includes the fix of bug 167171.
Comment 1 Balázs Varga (allotropia) 2025-07-09 16:47:47 UTC 
Hi Regina,

Thanks a lot for the tests and reports.

Is this issue existed before the fix for bug 167171?
Comment 2 Regina Henschel 2025-07-09 18:33:04 UTC 
(In reply to Balázs Varga (allotropia) from comment #1)
> Hi Regina,
> 
> Thanks a lot for the tests and reports.
> 
> Is this issue existed before the fix for bug 167171?

Yes, I see it already in Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 2b85bceca88ab119fff5cbdc41fe913435a479ca
CPU threads: 32; OS: Windows 11 (10.0 build 26100); UI render: Skia/Vulkan; VCL: win
Locale: de-DE (de_DE); UI: en-US
Calc: threaded

Versions 24.2 do not calculate wildcards for inline-arrays at all.
Comment 3 m_a_riosv 2025-07-09 21:49:30 UTC 
Created attachment 201721 [details]
The same file with regular expressions.

Behavior seems the same with regular expressions.
Comment 4 m_a_riosv 2025-07-09 21:50:47 UTC 
Created attachment 201722 [details]
Screenshot how file with wildcards looks in Excel.
Comment 5 m_a_riosv 2025-07-09 21:52:51 UTC 
The different behavior, it's the same with wildcards or regular expressions.
Comment 6 m_a_riosv 2025-07-09 21:55:55 UTC 
Reproducible
Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 77b7799caa584a92e56d0b4ac40c9d8fde8dcd4c
CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win
Locale: en-US (es_ES); UI: en-US
Calc: CL threaded