From mboxrd@z Thu Jan  1 00:00:00 1970
From: Eric S Fraga <e.fraga@ucl.ac.uk>
Subject: Re: Precision in the spreadsheet
Date: Tue, 1 Mar 2016 17:08:34 +0000
Message-ID: <87twkqunvx.fsf@ucl.ac.uk>
References: <87vb56w31l.fsf@mbork.pl>
	<87k2lm2ky5.fsf@alphaville.usersys.redhat.com>
Mime-Version: 1.0
Content-Type: text/plain
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:45068)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <e.fraga@ucl.ac.uk>) id 1aapFm-0003Vu-Ke
	for emacs-orgmode@gnu.org; Tue, 01 Mar 2016 13:42:39 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <e.fraga@ucl.ac.uk>) id 1aapFj-00017W-8b
	for emacs-orgmode@gnu.org; Tue, 01 Mar 2016 13:42:38 -0500
Received: from mail-am1on0108.outbound.protection.outlook.com
	([157.56.112.108]:27004
	helo=emea01-am1-obe.outbound.protection.outlook.com)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <e.fraga@ucl.ac.uk>) id 1aapFj-00016w-0B
	for emacs-orgmode@gnu.org; Tue, 01 Mar 2016 13:42:35 -0500
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: Nick Dokos <ndokos@gmail.com>
Cc: emacs-orgmode@gnu.org

On Tuesday,  1 Mar 2016 at 11:59, Nick Dokos wrote:
> Marcin Borkowski <mbork@mbork.pl> writes:
>
>> Hi all,
>>
>> is it at all possible to set different precision for display and
>> calculations in Org's spreadsheet?  I mean, things like $1+$2;%.2f (as
>> in the manual) mean (IIUC) that (1) Org should show 2 decimal figures
>> and (2) further calculations which use this value also use this
>> approximation.  Am I right?  If yes, is there a way to change this
>> behavior?  (I suspect not, but I wanted to make sure.)
>>
>
> I believe that internally, calculations are done in 12-decimal place
> precision: the %.2f is for display only.

Actually, surprisingly (to me), it appears not.  This simple example
gives different results depending on the formatting of the first entry:

#+begin_src org
  ,* table
  | 0.1 |
  |  1. |
  | 10. |
  ,#+TBLFM: @1$1=1/8;%.1f::@2$1=@-1*10::@3$1=@-1*10
#+end_src

-- 
: Eric S Fraga (0xFFFCF67D), Emacs 25.0.91.1, Org release_8.3.4-626-gb62d55