From mboxrd@z Thu Jan 1 00:00:00 1970 From: Carsten Dominik Subject: Re: Spreadsheet FR Date: Fri, 2 Apr 2010 09:49:46 +0200 Message-ID: <49A58658-88AF-4A88-93E9-1CDB710B08A2@gmail.com> References: <20100401214648.GL7262@thinkpad.adamsinfoserv.com> Mime-Version: 1.0 (Apple Message framework v936) Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1Nxbt0-0004MQ-Ap for emacs-orgmode@gnu.org; Fri, 02 Apr 2010 04:05:50 -0400 Received: from [140.186.70.92] (port=56692 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1Nxbso-0002rf-4E for emacs-orgmode@gnu.org; Fri, 02 Apr 2010 04:05:49 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69) (envelope-from ) id 1NxbdV-0007Tf-H1 for emacs-orgmode@gnu.org; Fri, 02 Apr 2010 03:49:51 -0400 Received: from ey-out-1920.google.com ([74.125.78.147]:48078) by eggs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1NxbdV-0007Ta-9v for emacs-orgmode@gnu.org; Fri, 02 Apr 2010 03:49:49 -0400 Received: by ey-out-1920.google.com with SMTP id 4so106539eyg.34 for ; Fri, 02 Apr 2010 00:49:48 -0700 (PDT) In-Reply-To: <20100401214648.GL7262@thinkpad.adamsinfoserv.com> List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Russell Adams Cc: emacs-orgmode On Apr 1, 2010, at 11:46 PM, Russell Adams wrote: > Fellow Org'ers, > > I adore the text spreadsheet, however there's one feature Excel > provides which I don't have in org. > > I often use Excel for "lists", where I can sort or narrow the data by > specific criteria from a larger list. > > Would it be feasible to "narrow" a table by criteria on a specific > field in between separators? Ie: only display those cells in field A > if they are > 2, or if field B matches "Pick Me!". This one might be possible - but dangerous for losing data. > > A nice feature would be updating the totals at the bottom with only > the visible data. I don't think Excel works like this, does it? > > Just like the outline folding the goal would be to hide entries that > don't match, they should still remain. > > So for example: > > |--------+--------| > | *Lime* | *Cost* | > |--------+--------| > | Y | 1 | > | Y | 2 | > | Y | 2 | > | N | 3 | > | N | 4 | > | Y | 5 | > |--------+--------| > | Total | 17 | > |--------+--------| > #+TBLFM: @8$2=vsum(@-I..@-II) > > I can already sort by Lime or Cost, but if I filtered where Lime = > "Y", I would have: > > |--------+--------| > | *Lime* | *Cost* | > |--------+--------| > | Y | 1 | > | Y | 2 | > | Y | 2 |... > | Y | 5 | > |--------+--------| > | Total | 10 | > |--------+--------| > #+TBLFM: @8$2=vsum(@-I..@-II) > > No loss of the lines, on reload or changing the view they would come > back, but note that the formula at the end didn't consider > them. Ideally the cell references wouldn't change (the example above > would break if recalc was hit). > > I'm not sure whether this would be cumulative or whether the criteria > specification would need to allow for multiple logical conditions. > > Would anyone else consider this a useful feature? I'm not sure how > difficult the implementation would be. > > Thanks. > > > _______________________________________________ > Emacs-orgmode mailing list > Please use `Reply All' to send replies to the list. > Emacs-orgmode@gnu.org > http://lists.gnu.org/mailman/listinfo/emacs-orgmode - Carsten