From mboxrd@z Thu Jan  1 00:00:00 1970
From: Matt Lundin <mdl@imapmail.org>
Subject: Re: Spreadsheet FR
Date: Fri, 02 Apr 2010 16:43:17 -0400
Message-ID: <87ljd5twka.fsf@fastmail.fm>
References: <20100401214648.GL7262@thinkpad.adamsinfoserv.com>
	<49A58658-88AF-4A88-93E9-1CDB710B08A2@gmail.com>
	<878w95sym0.fsf@stats.ox.ac.uk>
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 1NxnhV-0002h4-Tl
	for emacs-orgmode@gnu.org; Fri, 02 Apr 2010 16:42:45 -0400
Received: from [140.186.70.92] (port=50859 helo=eggs.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1NxnhT-0002ff-Mr
	for emacs-orgmode@gnu.org; Fri, 02 Apr 2010 16:42:44 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69)
	(envelope-from <lundin@fastmail.fm>) id 1NxnhR-0006bz-0t
	for emacs-orgmode@gnu.org; Fri, 02 Apr 2010 16:42:43 -0400
Received: from out3.smtp.messagingengine.com ([66.111.4.27]:52592)
	by eggs.gnu.org with esmtp (Exim 4.69)
	(envelope-from <lundin@fastmail.fm>) id 1NxnhQ-0006bW-Uy
	for emacs-orgmode@gnu.org; Fri, 02 Apr 2010 16:42:40 -0400
In-Reply-To: <878w95sym0.fsf@stats.ox.ac.uk> (Dan Davison's message of "Fri,
	02 Apr 2010 10:44:23 -0400")
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: Dan Davison <davison@stats.ox.ac.uk>
Cc: Russell Adams <RLAdams@adamsinfoserv.com>, emacs-orgmode <emacs-orgmode@gnu.org>, Carsten Dominik <carsten.dominik@gmail.com>

Dan Davison <davison@stats.ox.ac.uk> writes:

> Hi Russell,
>
> Carsten Dominik <carsten.dominik@gmail.com> writes:
>
>> 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!".
>
> How about keeping a master table containing all the information, and
> then generating narrowed views as separate tables? The babel way to do
> this would be to have a block function "filter-table" (provided below)
> and then call it where needed:

This is fantastic. Thanks, Dan!

- Matt