From mboxrd@z Thu Jan 1 00:00:00 1970 From: Xiao-Yong Jin Subject: Re: Spreadsheet FR Date: Sun, 04 Apr 2010 12:46:28 -0400 Message-ID: <87tyrr413v.fsf@columbia.edu> References: <20100401214648.GL7262@thinkpad.adamsinfoserv.com> <49A58658-88AF-4A88-93E9-1CDB710B08A2@gmail.com> <20100402081658.GO7262@thinkpad.adamsinfoserv.com> <1BB83608-9D78-439A-A5E3-7BD02E823A24@gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1NySyM-0003GN-Mh for emacs-orgmode@gnu.org; Sun, 04 Apr 2010 12:46:54 -0400 Received: from [140.186.70.92] (port=38202 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1NySyL-0003CW-Gw for emacs-orgmode@gnu.org; Sun, 04 Apr 2010 12:46:54 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69) (envelope-from ) id 1NySyJ-00078H-KV for emacs-orgmode@gnu.org; Sun, 04 Apr 2010 12:46:53 -0400 Received: from brinza.cc.columbia.edu ([128.59.29.8]:33021) by eggs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1NySyJ-00076y-I2 for emacs-orgmode@gnu.org; Sun, 04 Apr 2010 12:46:51 -0400 In-Reply-To: <1BB83608-9D78-439A-A5E3-7BD02E823A24@gmail.com> (Carsten Dominik's message of "Sun, 4 Apr 2010 09:01:30 +0200") 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: Carsten Dominik Cc: Russell Adams , emacs-orgmode On Sun, 4 Apr 2010 09:01:30 +0200, Carsten Dominik wrote: > On Apr 2, 2010, at 10:16 AM, Russell Adams wrote: >> On Fri, Apr 02, 2010 at 09:49:46AM +0200, Carsten Dominik wrote: >>> >>>> 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. >> >> Ideally we're just narrowing away lines, collapsing a table like org >> collapses headlines. >> >> Why would that be more likely to cause data loss? > Because there would be ellipsis in unfamiliar places and the danger to > accidentally modify invisible text would be higer. I have an idea. We can leave the original table intact, while making a new dynamically generated table derived from the original one. #+tblname: myexptable | x | y | z | |---+---+--------------| | 1 | 1 | 0.36787944 | | 1 | 2 | 0.13533528 | | 2 | 3 | 0.099574137 | | 2 | 4 | 0.036631278 | | 3 | 5 | 0.020213841 | | 3 | 6 | 7.4362565e-3 | #+TBLFM: $3=$1*exp(-$2) #+DERIVEDTBL :origin myexptable :criteria $1==2 | x | y | z | |---+---+-------------| | 2 | 3 | 0.099574137 | | 2 | 4 | 0.036631278 | It is just a quick thought. I am not sure how easy it is to implement it, but at least it is unlikely to make any confusion to users. -- jxy -- J c/* __o/* X <\ * (__ Y */\ <