From mboxrd@z Thu Jan 1 00:00:00 1970 From: Russell Adams Subject: Re: Spreadsheet FR Date: Fri, 2 Apr 2010 03:16:58 -0500 Message-ID: <20100402081658.GO7262@thinkpad.adamsinfoserv.com> References: <20100401214648.GL7262@thinkpad.adamsinfoserv.com> <49A58658-88AF-4A88-93E9-1CDB710B08A2@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 1Nxc3w-000853-DB for emacs-orgmode@gnu.org; Fri, 02 Apr 2010 04:17:08 -0400 Received: from [140.186.70.92] (port=36465 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1Nxc3u-00084A-Kj for emacs-orgmode@gnu.org; Fri, 02 Apr 2010 04:17:07 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69) (envelope-from ) id 1Nxc3s-0003Z1-S7 for emacs-orgmode@gnu.org; Fri, 02 Apr 2010 04:17:06 -0400 Received: from squirtle.drak.net ([72.52.144.201]:39241) by eggs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1Nxc3s-0003Yq-M8 for emacs-orgmode@gnu.org; Fri, 02 Apr 2010 04:17:04 -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 ) id 1Nxc3p-0002Jh-Hj for emacs-orgmode@gnu.org; Fri, 02 Apr 2010 03:17:01 -0500 Content-Disposition: inline In-Reply-To: <49A58658-88AF-4A88-93E9-1CDB710B08A2@gmail.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: emacs-orgmode 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? >> 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? Absolutely. Excel 2003 and up support "lists" or in 2007 "tables", where you can do filter and summary work. I use it all the time for customer planning because its the closest thing to grep/awk for Windows. I think the real trick here is making the formulas ignore narrowed content. If you'd like I can send you a sample. Thanks. ------------------------------------------------------------------ Russell Adams RLAdams@AdamsInfoServ.com PGP Key ID: 0x1160DCB3 http://www.adamsinfoserv.com/ Fingerprint: 1723 D8CA 4280 1EC9 557F 66E8 1154 E018 1160 DCB3