Issue 32571 - Automatic filtering
Summary: Automatic filtering
Status: CLOSED WONT_FIX
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1.2
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2004-08-04 13:48 UTC by dubiel
Modified: 2017-05-20 09:55 UTC (History)
3 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description dubiel 2004-08-04 13:48:00 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.
Comment 1 frank 2004-08-04 14:27:01 UTC
*** Issue 32572 has been marked as a duplicate of this issue. ***
Comment 2 frank 2004-08-04 14:28:15 UTC
Hi Bettina,

one for you.

Frank
Comment 3 bettina.haberer 2010-05-21 15:06:36 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements". 
Comment 4 Rainer Bielefeld 2013-08-19 05:30:44 UTC
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)
Comment 5 Edwin Sharp 2013-12-28 18:30:32 UTC
No info from author.