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: Carsten Dominik
Subject: Re: [Orgmode] Precision setting for spreadsheet calculation
Date: Wed, 3 Mar 2010 13:20:09 +0100

Hi Michael,

very nice, thanks, I have applied the patch.

- Carsten

On Mar 2, 2010, at 9:15 PM, Michael Brand wrote:

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}
= = = = = = = ======================================================================


- Carsten







reply via email to

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