Apache OpenOffice (AOO) Bugzilla – Issue 37653
OOo needs the ability to copy rows by filter from the cell
Last modified: 2014-01-13 07:29:18 UTC
Currently, if a user wants to copy a subset of data from a spreadsheet to a new cell, he must do so using the Filter GUI (Data>Filter>Standard filter then select copy to location). This functionality would be incredibly usful were it avaialbe from the cell itself. That is to say, the user should be able to use the Filter options from within the spreadsheet itself. Here is an example of its use (and hopefully its utility): A user has a list of Work items on Sheet1. The list of Work items are for all work performed: Invoice Work Units Rate 123 Installed OOo 5 50 123 Installed Linux 5 80 234 Fixed MoBo 1 120 234 Added New HDD 1 40 123 Patched Fedora 5 80 345 Installed Apache 2 80 345 Installed Tomcat 2 80 And an Invoice Template on Sheet2. The user should be able to say something like: =FILTER(Sheet1.A1:D8,"Invoice",234) And get the same result as if he used the Filter GUI to copy those cells to the current location. Ideally, he should also be able to substitute Named ranges for the first parameter and a reference for the last parameter so that he could instead say: =FILTER(ListOfWork,"Invoice",B22) Where ListOfWork is a Named Range for the Sheet1 list and B22 is a reference to a cell that contains the current invoice number. Seems like a pretty useful feature (one I should could use right now!) :)
Hi, I'm sorry, but I think there is no chance for this Feature request as this task could easily achieved by Validity settings and / or Form Controls. Nevertheless I re-assign it to the feature department. Frank
OpenOffice.org Issue Tracker - Feedback Request. The Issue you raised is currently 'Unconfirmed' pending review, but has not been updated within the last 3 years. Please consider re-testing with one of the latest versions of OOo, as the problem(s) may have already been addressed. Either use the recent stable version: http://download.openoffice.org/index.html or consider trying the new OOo 3 BETA (still in testing): http://download.openoffice.org/3.0beta/ Please report back the outcome so this Issue may be Closed or Progressed as necessary - otherwise it may be Resolved as Invalid in the future. You may also wish to search for (and note) any duplicates of this Issue that may have advanced further by checking the Issue Tracker: http://www.openoffice.org/issues/query.cgi Many thanks, Andrew Cleaning-up and Closing old Issues as part of: ~ The Grand Bug Squash, pre v3 ~ http://marketing.openoffice.org/3.0/announcementbeta.html
To grep the issues easier via "requirements" I put the issues currently lying on my owner to the owner "requirements".
IMHO good idea.