From mboxrd@z Thu Jan  1 00:00:00 1970
From: =?UTF-8?B?TWljaGHDq2w=?= Parienti <michael@parienti.name>
Subject: Calc formula with multi value and format string
Date: Wed, 10 Jun 2009 00:07:11 +0200
Message-ID: <20090610000711.10845b38@naurin.parienti.lan>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43)
	id 1MEA2a-0000Dq-Gg
	for emacs-orgmode@gnu.org; Tue, 09 Jun 2009 18:43:36 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1MEA2V-0000DQ-Q5
	for emacs-orgmode@gnu.org; Tue, 09 Jun 2009 18:43:35 -0400
Received: from [199.232.76.173] (port=53064 helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1MEA2V-0000DK-M2
	for emacs-orgmode@gnu.org; Tue, 09 Jun 2009 18:43:31 -0400
Received: from xvm-188-106.ghst.net ([217.70.188.106]:59408
	helo=willow.parienti.net)
	by monty-python.gnu.org with esmtp (Exim 4.60)
	(envelope-from <michael@parienti.name>) id 1MEA2V-0006hY-2g
	for emacs-orgmode@gnu.org; Tue, 09 Jun 2009 18:43:31 -0400
Received: from naurin.parienti.lan (cvl92-2-82-235-135-83.fbx.proxad.net
	[82.235.135.83])
	by willow.parienti.net (Postfix) with ESMTPSA id 1276331C42
	for <emacs-orgmode@gnu.org>; Wed, 10 Jun 2009 00:08:07 +0200 (CEST)
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/pipermail/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=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: emacs-orgmode@gnu.org


Hi,

I would like to put two computed values (sum and mean) into a cell of
a table. Reading the calc manual I found the following syntax:

|---------+---------------|
|         |         Title |
|---------+---------------|
| Label 1 |             0 |
| Label 2 |             1 |
|---------+---------------|
| Label 3 |             1 |
|---------+---------------|
|         | 0.66666667, 2 |
|---------+---------------|
#+TBLFM: $LR2=3Dvmean(@2..-I),vsum(@2..-I)::

Now I would like to format the meanm, but I don=E2=80=99t know where I shou=
ld
put the format string. I tried several possibilities without success:

$LR2=3Dvmean(@2..-I);%.2f,vsum(@2..-I)::  displays  0.67,vsum(@2..-I)
$LR2=3Dvmean(@2..-I),vsum(@2..-I);%.2f::  displays  0.00
$LR2=3Dvsum(@2..-I),vmean(@2..-I);%.2f::  displays  2.00=20

(I don=E2=80=99t mind which value comes first)


Has anyone any idea to help me? Can I set the org-calc-default-modes
variable for just a table?=20


--=20
Micha=C3=ABl P
gpg:        D4C8 F73D A000 71C7 44EF  27E6 8982 4991 7126 3CE3