https://bugs.documentfoundation.org/show_bug.cgi?id=162581
Bug ID: 162581
Summary: New Filter Function is bugged and cannot detect amount
of outputs correctly based off inputs from a table
Product: LibreOffice
Version: 24.8.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: dreadforce...@outlook.com
Description:
the newly introduced filter function in libreoffice 24.8 contains a bug where
it incorrectly filters multiple data if the input apeears twice in the table
but the output for each is different.
Steps to Reproduce:
1.In cell B3 type in "Name"
2.In cell C3 type in "Number"
3.In cell B4 and B5 type in "Jerry"
4. In cell B6 type in John
5. In cell B7 type in "Larry"
6. In cell B8 type in Sam
7. From cells C4:C8 type in numbers 1-5
8. In cell E3 right click and select data validation, select cell range for
validity.
9.) select B4:B8
10. In cell F3, enter the following function:
=filter(C4:C8,B4:B8=E3," ")
11. then press ctrl+shift+enter to enter in the array based formula
12. If you select the names John,Larry or Sam from the data validation list the
filter function is giving individual results, however if you select Jerry
you'll get only the first number that is in the table.
13. If you drag the filter function formula down you'll now have 2 cells with
the formula(extending the array), Now if you select Jerry you'll get both the
desired vales of 1 and 2 from the table, but for any of the other names your
getting the same numbers twice coming from the filter function.
Actual Results:
The filter function is only has one array set, will give one output for every 1
input, and if the filter function array is dragged down to extend the
array(such as if the data table contains the same input appearing twice)then
the filter function is able to give both different outputs for that 1 input;
however for any 1 input(from the data table) where the function should be
giving 1 output the filter function tend to produce the same output twice.
Expected Results:
The filter function producing the exact outputs shown in the table as the input
entered, and not repeating output if it only shows in the table once.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
This filter function exsists in Excel and google sheets and over there it tends
to automatically detect from the table how many times an input appears in the
data table, and if that same input appears more then once and has a different
output the filter ensures the show it.
--
You are receiving this mail because:
You are the assignee for the bug.
