From mboxrd@z Thu Jan  1 00:00:00 1970
From: Russell Adams <rladams@adamsinfoserv.com>
Subject: Spreadsheet FR
Date: Thu, 1 Apr 2010 16:46:48 -0500
Message-ID: <20100401214648.GL7262@thinkpad.adamsinfoserv.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43)
	id 1NxSEJ-0006zL-9l
	for emacs-orgmode@gnu.org; Thu, 01 Apr 2010 17:47:11 -0400
Received: from [140.186.70.92] (port=35074 helo=eggs.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1NxSEH-0006xZ-P8
	for emacs-orgmode@gnu.org; Thu, 01 Apr 2010 17:47:10 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69)
	(envelope-from <rladams@adamsinfoserv.com>) id 1NxSEF-0002oQ-Ph
	for emacs-orgmode@gnu.org; Thu, 01 Apr 2010 17:47:09 -0400
Received: from squirtle.drak.net ([72.52.144.201]:52526)
	by eggs.gnu.org with esmtp (Exim 4.69)
	(envelope-from <rladams@adamsinfoserv.com>) id 1NxSEF-0002oG-Lj
	for emacs-orgmode@gnu.org; Thu, 01 Apr 2010 17:47:07 -0400
Received: from 206.180.155.43.adsl.hal-pc.org ([206.180.155.43] helo=localhost)
	by squirtle.drak.net with esmtpsa (TLSv1:AES128-SHA:128) (Exim 4.69)
	(envelope-from <rladams@adamsinfoserv.com>) id 1NxSDu-0007Pz-C4
	for emacs-orgmode@gnu.org; Thu, 01 Apr 2010 16:46:46 -0500
Content-Disposition: inline
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/pipermail/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=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: emacs-orgmode <emacs-orgmode@gnu.org>

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!".

A nice feature would be updating the totals at the bottom with only
the visible data.

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.