From mboxrd@z Thu Jan 1 00:00:00 1970 From: mdl@imapmail.org Subject: Re: Saving column views in agenda Date: Thu, 11 Dec 2008 15:34:25 -0600 Message-ID: <87wse69z1a.fsf@fastmail.fm> References: <06D0017E-5568-42C0-9AA2-4777F558D23E@uva.nl> <87k5aau0lh.fsf@fastmail.fm> <87ej0hypx4.fsf@fastmail.fm> <87vdtq67i0.fsf@gmail.com> <87y6ymirmv.fsf@fastmail.fm> <877i664jhe.fsf@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 1LAtAy-0007yP-5o for emacs-orgmode@gnu.org; Thu, 11 Dec 2008 16:34:28 -0500 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1LAtAx-0007xZ-4q for emacs-orgmode@gnu.org; Thu, 11 Dec 2008 16:34:27 -0500 Received: from [199.232.76.173] (port=35039 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1LAtAw-0007xT-W2 for emacs-orgmode@gnu.org; Thu, 11 Dec 2008 16:34:27 -0500 Received: from out1.smtp.messagingengine.com ([66.111.4.25]:36367) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1LAtAw-00038b-Hi for emacs-orgmode@gnu.org; Thu, 11 Dec 2008 16:34:26 -0500 In-Reply-To: <877i664jhe.fsf@gmail.com> (Eric Schulte's message of "Thu\, 11 Dec 2008 11\:09\:17 -0800") 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: Eric Schulte Cc: Org-mode "Eric Schulte" writes: > Hi Matthew, > > Good idea. I've added a :conds parameter which can do just that, see > the example below. Notice that :conds should be a list of tests, not > just one single test, if this proves awkward it would be easy to add > a :cond parameter which doesn't require a list. > Thanks for the update. This is fantastic! It makes it very easy to put a subset of property data in a nice, clean table and thus adds powerful spreadsheet functionality to org-mode. > One issue with this setup, is that it's not clear what a stable way > would be to specify the #+TBLFM line. Since the size of the table could > vary the field in which the sum should be placed could move around. > With the table below a #+TBLFM line like this > > #+TBLFM: @II+1$2=vsum(@I+1..@II-1) > > would work, but currently org-table does not allow the @I style > references before the = sign in the table formula. I wonder if this > would be hard difficult to change? > I considered the same thing when I inquired about selecting for a particular condition--namely, that it would interfere the #+TBLFM formula. If allowing for the @I reference before the equal is not possible, I wonder whether another notation could be added to org-table that would designate the last field in a column (or row)---since such fields are often used to show the results of calculations. That would enable one to create a stable formula that would survive changes to the number of rows in a table. (In other words, one could add rows to the table and still ensure that the formula is attached to the last row.) I'd agree, however, that begin able to use @I before the equal would be preferable, because then (as far as I understand it) one could designate arbitrary "fixed" positions in tables with hlines. Thanks, Matt