From mboxrd@z Thu Jan 1 00:00:00 1970 From: Carsten Dominik Subject: Re: Spreadsheet FR Date: Sun, 4 Apr 2010 09:01:30 +0200 Message-ID: <1BB83608-9D78-439A-A5E3-7BD02E823A24@gmail.com> References: <20100401214648.GL7262@thinkpad.adamsinfoserv.com> <49A58658-88AF-4A88-93E9-1CDB710B08A2@gmail.com> <20100402081658.GO7262@thinkpad.adamsinfoserv.com> Mime-Version: 1.0 (Apple Message framework v936) Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1NyJpz-0003Mp-5x for emacs-orgmode@gnu.org; Sun, 04 Apr 2010 03:01:39 -0400 Received: from [140.186.70.92] (port=48599 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1NyJpw-0003HE-Gg for emacs-orgmode@gnu.org; Sun, 04 Apr 2010 03:01:38 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69) (envelope-from ) id 1NyJpu-0005qJ-Iv for emacs-orgmode@gnu.org; Sun, 04 Apr 2010 03:01:36 -0400 Received: from mail-ew0-f214.google.com ([209.85.219.214]:52184) by eggs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1NyJpu-0005pp-0a for emacs-orgmode@gnu.org; Sun, 04 Apr 2010 03:01:34 -0400 Received: by ewy6 with SMTP id 6so208961ewy.32 for ; Sun, 04 Apr 2010 00:01:31 -0700 (PDT) In-Reply-To: <20100402081658.GO7262@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 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. > >>> 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. OK, I did not know this. > > I think the real trick here is making the formulas ignore narrowed > content. > > If you'd like I can send you a sample. Please do - but that does not mean that I am going to implement this. This would be tricky. - Carsten