From mboxrd@z Thu Jan  1 00:00:00 1970
From: Uwe Brauer <oub@mat.ucm.es>
Subject: rounding vs cutting
Date: Mon, 25 Jun 2018 17:34:17 +0200
Message-ID: <87k1qmkhhi.fsf@mat.ucm.es>
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:45368)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1fXTVg-0008UF-CZ
	for emacs-orgmode@gnu.org; Mon, 25 Jun 2018 11:34:33 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1fXTVb-0002NI-H0
	for emacs-orgmode@gnu.org; Mon, 25 Jun 2018 11:34:32 -0400
Received: from [195.159.176.226] (port=60251 helo=blaine.gmane.org)
	by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16)
	(Exim 4.71) (envelope-from <geo-emacs-orgmode@m.gmane.org>)
	id 1fXTVb-0002Mr-Ah
	for emacs-orgmode@gnu.org; Mon, 25 Jun 2018 11:34:27 -0400
Received: from list by blaine.gmane.org with local (Exim 4.84_2)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1fXTTR-0002Tr-Aa
	for emacs-orgmode@gnu.org; Mon, 25 Jun 2018 17:32:13 +0200
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"
	<emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
To: emacs-orgmode@gnu.org

 
Hi   Please look at the following examples:  |  org1 |  org2 | 
org1 + org2 | org1 + org2 | org1 | org2 | result2 | 
|-------+-------+-------------+-------------+------+------+---------| 
| 1.253 | 1.453 |       2.706 |         2.7 |  1.3 |  1.5 | 2.8 
| #+TBLFM: $3=$1+$2::$4=$1+$2; E f-1::$5=$1;E f-1::$6=$2; E 
f-1::$7=$5+$6  | <>    | <>    | <>    | <>    |           | 
|     | | org1  | org2  | res1  | round | orground1 | orground2 | 
| |-------+-------+-------+-------+-----------+-----------+-----| 
| 1.253 | 1.453 | 2.706 | 2.7   |       1.3 |       1.5 | 2.8 | 
#+TBLFM: $3=$1+$2::$4=$3;%.1f::$5=$1;%.1f::$6=$2;%.1f::$7=$5+$6 
(BTW, what is the difference between E f-1 and ;%.1f?)

In any case it seems that the rounding in calc is more a cutting 
that is the actual value of column 1 and 2 are not saved somewhere 
but instead are cut since the result in column 4 and 7 do not 
coincide (but they do so in other spreadsheets as in libreoffice 
and others).

Or is there something I miss here?

Uwe Brauer