Re: Precision setting for spreadsheet calculation

[Carsten Dominik <carsten.dominik@gmail.com>]

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
> +@code{printf} format specifier to reformat the Calc result after it  
> has been
> +passed back to Org instead of letting Calc already do the
> +formatting@footnote{The @code{printf} reformatting is limited in  
> precision
> +because the value passed to it is converted into an @code{integer} or
> +@code{double}.  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