https://bugs.documentfoundation.org/show_bug.cgi?id=162600
Bug ID: 162600
Summary: A Function in Calc meant for filtering data from
tables is working incorrectly
Product: LibreOffice
Version: 24.8.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
The new filter function in LibreOffice 24.8 is producing the wrong output that
is desired from the data table.
Steps to Reproduce:
1. Enter the value "Name" into cell B2
2. Enter the value "Number into cell C2
3. Enter the name "Jerry" into Cells B3 and B4
4. Enter the names Sam, Larry and John into cells B5:B7
5. Enter numbers from 1-5 in cells C3:C7
6. Enter Data validation in the cell E2 for cell range B3:B7
7. Enter filter function formula in Cell F2; =filter(C3:C7,B3:B7=E2," ")
8.
Actual Results:
When selecting the Names from the data validation the filter function is giving
the correct numbers for every name found in the table however only for the name
Jerry(since it appears twice in the table) is gives the first number that
appearing in the table. When the formula is dragged down the reverse situation
occurs, the correct numbers will be outputted for the name Jerry but for every
other name in the data validation the function will output the same number
twice instead of once.
Expected Results:
Giving the same output(as well as numbers of outputs) as the appearances in the
data table.
Reproducible: Always
User Profile Reset: No
Additional Info:
In Microsoft Excel the filter function formula is able to automatically detect
the number of appearances of inputs and outputs in the data table.
--
You are receiving this mail because:
You are the assignee for the bug.
