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
Created attachment 184226 [details] file
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)