emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: henry atting <nsmp_02@online.de>
To: Jonathan Leech-Pepin <jonathan.leechpepin@gmail.com>
Cc: emacs-orgmode@gnu.org
Subject: Re: delete, add new row
Date: Fri, 02 Dec 2011 10:59:01 +0100	[thread overview]
Message-ID: <8739d3mh0a.fsf@bye.fritz.box> (raw)
In-Reply-To: <CAHRqSkThdjiCvYMXmf+yNqxbUKyhNEANkb_iouqbYg0kZDq4ZQ@mail.gmail.com> (Jonathan Leech-Pepin's message of "Thu, 1 Dec 2011 15:23:39 -0500")

Jonathan Leech-Pepin <jonathan.leechpepin@gmail.com> writes:

> I'm not sure as to the reason why it does so, but based on your
> example, the formula is referencing the specific cell itself, rather
> than the relative position of the cell.  If you change your formula to
> use a relative reference, it will continue to work even when you add,
> remove and move the rows.
>
> #+TBLFM: @2$3..@>$3=vmean(@I$2..@0$2);%.1f 
> or
> #+TBLFM: @2$3..@>$3=vmean(@<<$2..@0$2);%.1f
> will both provide you with the result you seem to be looking for.  The
> former uses your (first) horizontal line as the starting point,
> whereas the latter uses the 2nd row from the top.
>
> Regards,
> Jonathan
>
> On Thu, Dec 1, 2011 at 12:42, henry atting <nsmp_02@online.de> wrote:
>
>     Suppose I have this table:
>     
>     | month | expenses | average |
>     |-------+----------+---------|
>     |     1 |       20 |         |
>     |     2 |       30 |    25.0 |
>     |     3 |       40 |    30.0 |
>     #+TBLFM: @3$3..@>$3=vmean(@2$2..@0$2);%.1f
>     
>     Then I want to delete the second row and add a new one at the
>     bottom.
>     If I do so I get `#ERROR' on every recalculation.
>     
>     | month | expenses | average |
>     |-------+----------+---------|
>     |     2 |       30 |  #ERROR |
>     |     3 |       40 |  #ERROR |
>     |     4 | 50       |  #ERROR |
>     #+TBLFM: @2$3..@>$3=vmean(@INVALID$2..@0$2);%.1f
>     
>     If I push the second row to the bottom the
>     result is as if the last row is still the second one.
>     
>     | month | expenses | average |
>     |-------+----------+---------|
>     |     2 |       30 |    30.0 |
>     |     3 |       40 |    30.0 |
>     |     1 |       20 |    20.0 |
>     #+TBLFM: @2$3..@>$3=vmean(@4$2..@0$2);%.1f
>     

Ah, I see the problem; and thanks, it works fine now.

henry

-- 
http://literaturlatenight.de

      reply	other threads:[~2011-12-02  9:58 UTC|newest]

Thread overview: 3+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2011-12-01 17:42 delete, add new row henry atting
2011-12-01 20:23 ` Jonathan Leech-Pepin
2011-12-02  9:59   ` henry atting [this message]

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=8739d3mh0a.fsf@bye.fritz.box \
    --to=nsmp_02@online.de \
    --cc=emacs-orgmode@gnu.org \
    --cc=jonathan.leechpepin@gmail.com \
    /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).