https://bugs.documentfoundation.org/show_bug.cgi?id=167439
Bug ID: 167439
Summary: MATCH gives wrong result with inline array and
calculation setting wildcard on, whole cell off
Product: LibreOffice
Version: 26.2.0.0 alpha0+ master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 201717
--> https://bugs.documentfoundation.org/attachment.cgi?id=201717&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the bug.
