[Top][All Lists]
[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}
=============================================================================
- Re: [Orgmode] Precision setting for spreadsheet calculation,
Michael Brand <=