From mboxrd@z Thu Jan 1 00:00:00 1970 From: Carsten Dominik Subject: Re: Saving column views in agenda Date: Fri, 12 Dec 2008 12:00:00 +0100 Message-ID: <6F75D17D-48FD-4013-B53F-493D0331B30C@uva.nl> 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> <87wse69z1a.fsf@fastmail.fm> Mime-Version: 1.0 (Apple Message framework v929.2) 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 1LB5kk-00052R-Oq for emacs-orgmode@gnu.org; Fri, 12 Dec 2008 06:00:14 -0500 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1LB5kj-00051l-8J for emacs-orgmode@gnu.org; Fri, 12 Dec 2008 06:00:13 -0500 Received: from [199.232.76.173] (port=58865 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1LB5ki-00051U-HQ for emacs-orgmode@gnu.org; Fri, 12 Dec 2008 06:00:12 -0500 Received: from ey-out-1920.google.com ([74.125.78.147]:12936) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1LB5kh-0003Mq-7q for emacs-orgmode@gnu.org; Fri, 12 Dec 2008 06:00:11 -0500 Received: by ey-out-1920.google.com with SMTP id 4so194134eyg.24 for ; Fri, 12 Dec 2008 03:00:07 -0800 (PST) In-Reply-To: <87wse69z1a.fsf@fastmail.fm> 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: mdl@imapmail.org Cc: Org-mode On Dec 11, 2008, at 10:34 PM, mdl@imapmail.org wrote: > "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.) One more remark to this last statement. For interactive use, if you add lines to a table using the correct commands like S-M-down, the formulas will be automatically adjusted so that a pointer to a field below this inserted line will still reference that same field. Ah, I would like to rewrite the entire table code to make this spreadsheet stuff easier to maintain and improve...... > 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 > > > _______________________________________________ > Emacs-orgmode mailing list > Remember: use `Reply All' to send replies to the list. > Emacs-orgmode@gnu.org > http://lists.gnu.org/mailman/listinfo/emacs-orgmode