Bug 152582

Summary: The autofilter outputs several values 0 and empty if data is the result of VLOOKUP function
Product: LibreOffice Reporter: Bigor <bigorq>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: 79045_79045
Priority: medium    
Version: 4.0.6.2 release   
Hardware: x86-64 (AMD64)   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 103512    
Attachments: file

Description Bigor 2022-12-18 19:07:54 UTC 
Description:
The problem of the autofilter. There is an ods file, on List 1 column A indexes and column B values: empty cells, cells with zeros, numbers. On List2, the formula =VLOOKUP(A2;List 1.$A$2:$B$11;2;0), which returns empty cells , cells with zeros, numbers. The autofilter by column B List2 returns several rows of zeros and empty 

Steps to Reproduce:
1.Creating is an ods file, on List 1 column A indexes (1 to 9)  and column B values: empty cells, cells with zeros, numbers.
2.Creating List2 column A indexes (1 to 9), column B formula =VLOOKUP(A2;List 1.$A$2:$B$10;2;0)
3.apply the autofilter to List2 a1:b11. 


Actual Results:
We look at column B the autofilter outputs several 0's and is empty

Expected Results:
one 0 and one empty


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.4.3.2 / LibreOffice Community
Build ID: 40(Build:2)
CPU threads: 4; OS: Linux 5.10; UI render: default; VCL: kf5 (cairo+xcb)
Locale: ru-RU (ru_RU.UTF-8); UI: ru-RU
7.4.3-1
Calc: threaded
Comment 1 Bigor 2022-12-18 19:09:07 UTC 
Created attachment 184226 [details]
file
Comment 2 Roman Kuznetsov 2022-12-18 21:13:50 UTC 
Confirm in

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 68809ffde7d50a5f47afa5a1235025513762df8c
CPU threads: 16; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: ru-RU
Calc: CL threaded

and in

Версия 4.0.6.2 (ID сборки: 2e2573268451a50806fcd60ae2d9fe01dd0ce24)