From mboxrd@z Thu Jan  1 00:00:00 1970
From: Carsten Dominik <carsten.dominik@gmail.com>
Subject: Re: Precision setting for spreadsheet calculation
Date: Fri, 26 Feb 2010 21:34:29 +0100
Message-ID: <0AEABCAD-CA2E-4F84-99E1-B5670FEC1E8D@gmail.com>
References: <4B882C11.90406@alumni.ethz.ch>
Mime-Version: 1.0 (Apple Message framework v936)
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit
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 1Nl6tT-0003or-5p
	for emacs-orgmode@gnu.org; Fri, 26 Feb 2010 15:34:39 -0500
Received: from [140.186.70.92] (port=39197 helo=eggs.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1Nl6tS-0003oK-D9
	for emacs-orgmode@gnu.org; Fri, 26 Feb 2010 15:34:38 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69)
	(envelope-from <carsten.dominik@gmail.com>) id 1Nl6tM-000287-Ar
	for emacs-orgmode@gnu.org; Fri, 26 Feb 2010 15:34:38 -0500
Received: from mail-ew0-f222.google.com ([209.85.219.222]:55158)
	by eggs.gnu.org with esmtp (Exim 4.69)
	(envelope-from <carsten.dominik@gmail.com>) id 1Nl6tM-00027y-5l
	for emacs-orgmode@gnu.org; Fri, 26 Feb 2010 15:34:32 -0500
Received: by ewy22 with SMTP id 22so225511ewy.26
	for <emacs-orgmode@gnu.org>; Fri, 26 Feb 2010 12:34:31 -0800 (PST)
In-Reply-To: <4B882C11.90406@alumni.ethz.ch>
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: Michael Brand <michael.brand@alumni.ethz.ch>
Cc: emacs-orgmode@gnu.org


On Feb 26, 2010, at 9:16 PM, Michael Brand wrote:

> Hi all,
>
>
> 1) I tried to set the precision for the spreadsheet calculation to  
> p20 like mentioned in the Org info manual "3.5.2 Formula syntax for  
> Calc":
> I got
>
> | 0.1666666700000000 |
> #+TBLFM: $1 = 1 / 2 * 3; %.16f p20
>
> but I expect
>
> | 0.1666666666666667 |
> #+TBLFM: $1 = 1 / 2 * 3; %.16f p20

You need p20f20

p20 is for internal computation, f20 for youput, and the table
gets the value through output.  Confusing, yes....


HTH

- Carsten

>
> What am I missing? org-version is the current 6.34c, GNU Emacs  
> version is 21.1.1
>
>
> Thanks,
> Michael
>
>
> _______________________________________________
> Emacs-orgmode mailing list
> Please use `Reply All' to send replies to the list.
> Emacs-orgmode@gnu.org
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode

- Carsten