From mboxrd@z Thu Jan 1 00:00:00 1970 From: Michael Brand Subject: Re: Precision setting for spreadsheet calculation Date: Fri, 26 Feb 2010 22:12:58 +0100 Message-ID: <4B88395A.3040501@alumni.ethz.ch> References: <4B882C11.90406@alumni.ethz.ch> <0AEABCAD-CA2E-4F84-99E1-B5670FEC1E8D@gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1Nl7Ud-0006kF-EV for emacs-orgmode@gnu.org; Fri, 26 Feb 2010 16:13:03 -0500 Received: from [140.186.70.92] (port=36846 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1Nl7Uc-0006k7-Mc for emacs-orgmode@gnu.org; Fri, 26 Feb 2010 16:13:03 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69) (envelope-from ) id 1Nl7Ub-0005IJ-U4 for emacs-orgmode@gnu.org; Fri, 26 Feb 2010 16:13:02 -0500 Received: from mail01.solnet.ch ([212.101.4.135]:64570) by eggs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1Nl7Ub-0005I9-M5 for emacs-orgmode@gnu.org; Fri, 26 Feb 2010 16:13:01 -0500 In-Reply-To: <0AEABCAD-CA2E-4F84-99E1-B5670FEC1E8D@gmail.com> List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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: Carsten Dominik Cc: emacs-orgmode@gnu.org Carsten Dominik wrote: > You need p20f20 > > p20 is for internal computation, f20 for youput, and the table > gets the value through output. Confusing, yes.... | 0.1666666666666667 | #+TBLFM: $1 = 1 / 2 * 3; %.16f p20 f20 like expected. But instead of | 0.166666666666666660 | #+TBLFM: $1 = 1 / 2 * 3; %.18f p20 f20 which I get I would expect | 0.166666666666666667 | #+TBLFM: $1 = 1 / 2 * 3; %.18f p20 f20