From mboxrd@z Thu Jan 1 00:00:00 1970 From: Darlan Cavalcante Moreira Subject: Re: Spreadsheet FR Date: Fri, 02 Apr 2010 15:00:01 +0200 Message-ID: <4bb5ea4a.0d67f10a.60fe.ffff810c@mx.google.com> References: <20100401214648.GL7262@thinkpad.adamsinfoserv.com> <49A58658-88AF-4A88-93E9-1CDB710B08A2@gmail.com> <20100402081658.GO7262@thinkpad.adamsinfoserv.com> Mime-Version: 1.0 (generated by SEMI 1.14.6 - "Maruoka") Content-Type: text/plain; charset=US-ASCII Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1NxgTg-0006DV-EA for emacs-orgmode@gnu.org; Fri, 02 Apr 2010 09:00:00 -0400 Received: from [140.186.70.92] (port=41009 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1NxgTf-0006C0-1p for emacs-orgmode@gnu.org; Fri, 02 Apr 2010 08:59:59 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69) (envelope-from ) id 1NxgTd-0005yf-5i for emacs-orgmode@gnu.org; Fri, 02 Apr 2010 08:59:58 -0400 Received: from mail-ew0-f218.google.com ([209.85.219.218]:61595) by eggs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1NxgTd-0005yU-1F for emacs-orgmode@gnu.org; Fri, 02 Apr 2010 08:59:57 -0400 Received: by ewy10 with SMTP id 10so637614ewy.32 for ; Fri, 02 Apr 2010 05:59:55 -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: emacs-orgmode How can you expand/narrow the disabled lines if you want to show/hide them? This will probably interfere with normal TAB use inside a table. I think that the ability to "disable" some lines based on data in a column, such as in your example, can be very useful. But maybe we don't need to really collapse the lines. Only changing the face could be enough. - Darlan At Fri, 2 Apr 2010 03:16:58 -0500, 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? > > >> 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 > > > _______________________________________________ > Emacs-orgmode mailing list > Please use `Reply All' to send replies to the list. > Emacs-orgmode@gnu.org > http://lists.gnu.org/mailman/listinfo/emacs-orgmode