From: Carsten Dominik <firstname.lastname@example.org> To: Tom <email@example.com> Cc: firstname.lastname@example.org Subject: Re: Table formula changes are not always necessary when moving rows Date: Thu, 17 Mar 2011 07:03:29 +0100 [thread overview] Message-ID: <B3DE5F6C-F4A2-45F2-A055-C8A4C6572507@gmail.com> (raw) In-Reply-To: <loom.20110228T122543email@example.com> On 28.2.2011, at 12:43, Tom wrote: > I have a table in which I sum the values of all rows in the last > row: vsum(@1..@-I-1). The problem is when move a row with M-up > before the first row (e.g. I press M-up on the second row) then > org modifies this formula to vsum(@2..@-I-1). Hi Tom, I have thought a bit more about this issue. I do agree that, in particular when specifying ranges, it may not always desirable to have the formulas automatically adapt when rows and columns are swapped. I have just pushed a change that makes $< and @< refer in a stable way to the first column and row, respectively. You can also use @<<< to mean the second row and @>> the second to last row. I hope this will prove to be useful for such cases. Regards P.S. Nick (Dokos), I also added them to get the symmetry with the @> and $> references :) > > This is not always the expected behavior, because in this case I > just want to move the data in the rows, but still want to sum the > values of all the rows from the first to the last. A similar case > is when I want to insert a row before the first row of such a > table. In that case too the formulas should be left alone, > because I still want to sum all the rows, including the newly > inserted first row. > > In such cases when the formula is modified Org should either > print warning to the echo area, so the user notices when the > formulas are changing because of the move, or it should ask the > user what to do ("do you want to modify the formulas?"). > > > > _______________________________________________ > Emacs-orgmode mailing list > Please use `Reply All' to send replies to the list. > Emacsfirstname.lastname@example.org > http://lists.gnu.org/mailman/listinfo/emacs-orgmode
next prev parent reply other threads:[~2011-03-17 6:03 UTC|newest] Thread overview: 10+ messages / expand[flat|nested] mbox.gz Atom feed top 2011-02-28 11:43 Tom 2011-03-05 22:40 ` Bastien 2011-03-07 17:53 ` Carsten Dominik 2011-03-07 18:38 ` Tom 2011-03-17 6:03 ` Carsten Dominik [this message] 2011-03-17 10:02 ` Christian Moe 2011-03-17 11:23 ` Carsten Dominik 2011-03-17 14:15 ` Nick Dokos 2011-03-20 8:48 ` Achim Gratz 2011-03-20 9:06 ` 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=B3DE5F6C-F4A2-45F2-A055-C8A4C6572507@gmail.com \ --email@example.com \ --firstname.lastname@example.org \ --email@example.com \ --subject='Re: Table formula changes are not always necessary when moving rows' \ /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
Code repositories for project(s) associated with this 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).