From mboxrd@z Thu Jan  1 00:00:00 1970
From: Martin Halder <martin.halder@gmail.com>
Subject: table spreadsheet problem
Date: Mon, 19 Mar 2012 16:01:42 +0100
Message-ID: <A7030D27-A96B-41DD-8BF3-A88A10F231A2@gmail.com>
Mime-Version: 1.0 (Apple Message framework v1257)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([208.118.235.92]:46684)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <martin.halder@gmail.com>) id 1S9e5m-0005I1-3Z
	for emacs-orgmode@gnu.org; Mon, 19 Mar 2012 11:01:51 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <martin.halder@gmail.com>) id 1S9e5k-0007Lj-9J
	for emacs-orgmode@gnu.org; Mon, 19 Mar 2012 11:01:49 -0400
Received: from mail-lb0-f169.google.com ([209.85.217.169]:34383)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <martin.halder@gmail.com>) id 1S9e5j-0007LV-Ve
	for emacs-orgmode@gnu.org; Mon, 19 Mar 2012 11:01:48 -0400
Received: by lbbgf7 with SMTP id gf7so4183654lbb.0
	for <emacs-orgmode@gnu.org>; Mon, 19 Mar 2012 08:01:45 -0700 (PDT)
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: emacs-orgmode@gnu.org

Hi all,

question about table calculation. Found in the documentation that I =
could refer to e.g. first line after second hline with @II+2.

Would like to calculate sum =3D vsum(@I..@II) and tax =3D sum * 0.08

Am I doing sth wrong ?

Thanks for help,
Martin

| article |  price |
|---------+--------|
| item1   | 100.00 |
| item2   | 200.00 |
|---------+--------|
| sum     |        |
| tax     |        |
|---------+--------|
| sum     |      0 |
#+TBLFM: =
@II+1$2=3Dvsum(@I..@II);f2N::@II+2$2=3D@II+1$2*0.08;f2N::@>$2=3Dvsum(@II..=
@III);f2N