emacs-orgmode
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Orgmode] Precision setting for spreadsheet calculation


From: Michael Brand
Subject: Re: [Orgmode] Precision setting for spreadsheet calculation
Date: Tue, 02 Mar 2010 21:15:58 +0100
User-agent: Thunderbird 2.0.0.23 (Windows/20090812)

Hi Carsten

Michael Brand wrote:
Yes, within a few days I will come back with this and/or a texinfo patch for the Org info manual, at least chapter "3.5.2 Formula syntax for Calc".

The patch below is my proposal for the manual. Please feel free to improve it.

I also played around quite a bit with the precision settings and will put the resulting examples into the Worg FAQ. But I would like to postpone my Worg FAQ update because its link to the manual would be confusing before the manual update itself will have been made.

Is there a small issue with the behavior of the section link
http://orgmode.org/manual/index.html#Top ?
With Firefox 3.0.5 it sometimes jumps to where the html source fragment
<a name="Top"></a>
lies like expected but sometimes it jumps to where the html source fragment
<link title="Top" rel="start" href="#Top">
lies which could be annoying.

Michael


patch for org.texi, `---' file was taken from org-version 6.34c:
=============================================================================
--- a/doc/org.texi      2010-01-18 00:10:46.000000000 +0100
+++ b/doc/org.texi      2010-03-02 20:00:00.000000000 +0100
@@ -2128,8 +2128,11 @@
 @code{org-calc-default-modes}.

 @example
-p20           @r{switch the internal precision to 20 digits}
-n3 s3 e2 f4   @r{normal, scientific, engineering, or fixed display format}
+p20           @r{set the internal Calc calculation precision to 20 digits}
+n3 s3 e2 f4   @r{Normal, scientific, engineering, or fixed}
+              @r{format of the result of Calc passed back to Org.}
+              @r{Calc formatting is unlimited in precision as}
+              @r{long as the Calc calculation precision is greater.}
 D R           @r{angle modes: degrees, radians}
 F S           @r{fraction and symbolic modes}
 N             @r{interpret all fields as numbers, use 0 for non-numbers}
@@ -2139,8 +2142,16 @@
 @end example

 @noindent
-In addition, you may provide a @code{printf} format specifier to
-reformat the final result.  A few examples:
+Unless you use large integer numbers or high-precision-calculation
+and -display for floating point numbers you may alternatively provide a
address@hidden format specifier to reformat the Calc result after it has been
+passed back to Org instead of letting Calc already do the
address@hidden @code{printf} reformatting is limited in precision
+because the value passed to it is converted into an @code{integer} or
address@hidden  The @code{integer} is limited in size by truncating the
+signed value to 32 bits.  The @code{double} is limited in precision to 64
+bits overall which leaves approximately 16 significant decimal digits.}.
+A few examples:

 @example
 $1+$2                @r{Sum of first and second field}
=============================================================================





reply via email to

[Prev in Thread] Current Thread [Next in Thread]