Apache OpenOffice (AOO) Bugzilla – Issue 32571
Automatic filtering
Last modified: 2017-05-20 09:55:40 UTC
I have spreadsheet to generate analisis. Then I have several spreadsheets that do further computations based on the part of this analisis. To do computation I have to apply filter to analisis and take filtered data as the input for commputation. You might advice me to use "Keep filter criteria" and Data->RefreshRange to do automatic filtering. But I have to change filter criteria as many times as I have additional spreadsheets that need filtered data. I have also searched Database functions but they are not array functions (just DCOUNT or something). I would suggest to add array function FILTEROUT that will take data in the same manner as AdvancedFilter and will filter out data and show as array. Let's take example for OOHelp (go Index and search for "functions; database"). If array on cells A16:E27 contained formula =FilterOut(A1:E10; A13:E14) and in cell D14 one enetered "> 1000" then: -- row 16 will look the same as row 5 -- row 17 will look the same as row 9 -- row 18 will look the same as row 10 and rows 19-27 would be empty.
*** Issue 32572 has been marked as a duplicate of this issue. ***
Hi Bettina, one for you. Frank
To grep the issues easier via "requirements" I put the issues currently lying on my owner to the owner "requirements".
No Idea what we are talking about, so back to UNCONFIRMED for now. @dubiel Can your please - attach a sample document - and a more idiot proof step by step instruction - and additional info due to <http://wiki.openoffice.org/wiki/QA/HowToFileIssue#Reporting%20a%20New%20Bug> (for example a meaningful summary)
No info from author.