From mboxrd@z Thu Jan 1 00:00:00 1970 From: Achim Gratz Subject: Re: Precision in the spreadsheet Date: Tue, 01 Mar 2016 19:39:17 +0100 Message-ID: <87twkqyre2.fsf@Rainer.invalid> References: <87vb56w31l.fsf@mbork.pl> <87k2lm2ky5.fsf@alphaville.usersys.redhat.com> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:44309) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1aapCu-0001qD-AP for emacs-orgmode@gnu.org; Tue, 01 Mar 2016 13:39:41 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1aapCr-0000Da-04 for emacs-orgmode@gnu.org; Tue, 01 Mar 2016 13:39:40 -0500 Received: from plane.gmane.org ([80.91.229.3]:59594) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1aapCq-0000Ck-OO for emacs-orgmode@gnu.org; Tue, 01 Mar 2016 13:39:36 -0500 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1aapCg-0004rA-WB for emacs-orgmode@gnu.org; Tue, 01 Mar 2016 19:39:27 +0100 Received: from p54b4660e.dip0.t-ipconnect.de ([84.180.102.14]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 01 Mar 2016 19:39:26 +0100 Received: from Stromeko by p54b4660e.dip0.t-ipconnect.de with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 01 Mar 2016 19:39:26 +0100 List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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: emacs-orgmode@gnu.org Nick Dokos writes: > Marcin Borkowski writes: >> 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 guess everything is somehow possible, but it either requires to store the data with full precision somewhere or re-calculate the table with full precision each time and only then apply the display rounding. I've had this idea for some time that tables should have a shadow that determines formatting and other behaviour, there should probably be a way to keep raw data in the shadow as well. Meanwhile you could experiment with putting the data in a table somewhere with full precision and use Babel to display that data somewhere else the way you want it. If you wanted to be able to edit some data in that second table it would be more bothersome. > I believe that internally, calculations are done in 12-decimal place > precision: the %.2f is for display only. Sure, but as far as org-table is concerned, the data that is displayed is the data that gets used: * Table precision | 1 | 0.00 | 0. | | 2 | 0.00 | 0. | | 3 | 0.00 | 0. | | 4 | 0.00 | 0. | | 5 | 0.01 | 10. | | 6 | 0.01 | 10. | | 7 | 0.01 | 10. | | 8 | 0.01 | 10. | | 9 | 0.01 | 10. | | 10 | 0.01 | 10. | | 11 | 0.01 | 10. | | 12 | 0.01 | 10. | | 13 | 0.01 | 10. | | 14 | 0.01 | 10. | | 15 | 0.01 | 10. | #+TBLFM: $2=$1/1000;%.2f::$3=1000*$2 When calculating the third column, the formula to calculate the second column doesn get re-evaluated to regain the precision lost while displaying it. Org also doesn't keep shadow data and computes the display on the fly like most other spreadsheets do. Regards, Achim. -- +<[Q+ Matrix-12 WAVE#46+305 Neuron microQkb Andromeda XTk Blofeld]>+ SD adaptations for Waldorf Q V3.00R3 and Q+ V3.54R2: http://Synth.Stromeko.net/Downloads.html#WaldorfSDada