emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: Carsten Dominik <dominik@science.uva.nl>
To: mdl@imapmail.org
Cc: Org-mode <emacs-orgmode@gnu.org>
Subject: Re: Saving column views in agenda
Date: Fri, 12 Dec 2008 12:00:00 +0100	[thread overview]
Message-ID: <6F75D17D-48FD-4013-B53F-493D0331B30C@uva.nl> (raw)
In-Reply-To: <87wse69z1a.fsf@fastmail.fm>


On Dec 11, 2008, at 10:34 PM, mdl@imapmail.org wrote:

> "Eric Schulte" <schulte.eric@gmail.com> 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

  parent reply	other threads:[~2008-12-12 11:00 UTC|newest]

Thread overview: 14+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2008-12-08  5:52 Saving column views in agenda Matthew Lundin
2008-12-08  9:40 ` Carsten Dominik
2008-12-08 15:51   ` mdl
2008-12-09  7:27     ` Carsten Dominik
2008-12-09 21:55       ` Matthew Lundin
2008-12-11 15:45         ` Eric Schulte
     [not found]           ` <87y6ymirmv.fsf@fastmail.fm>
2008-12-11 19:09             ` Eric Schulte
2008-12-11 21:34               ` mdl
2008-12-12  8:40                 ` Carsten Dominik
2008-12-12 13:21                   ` Matthew Lundin
2008-12-12 11:00                 ` Carsten Dominik [this message]
2008-12-12 11:01                 ` Carsten Dominik
2008-12-12  0:25               ` Matthew Lundin
2008-12-12  7:55               ` Carsten Dominik

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=6F75D17D-48FD-4013-B53F-493D0331B30C@uva.nl \
    --to=dominik@science.uva.nl \
    --cc=emacs-orgmode@gnu.org \
    --cc=mdl@imapmail.org \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).