emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: Carsten Dominik <carsten.dominik@gmail.com>
To: Michael Brand <michael.brand@alumni.ethz.ch>
Cc: emacs-orgmode@gnu.org
Subject: Re: Precision setting for spreadsheet calculation
Date: Fri, 26 Feb 2010 21:34:29 +0100	[thread overview]
Message-ID: <0AEABCAD-CA2E-4F84-99E1-B5670FEC1E8D@gmail.com> (raw)
In-Reply-To: <4B882C11.90406@alumni.ethz.ch>


On Feb 26, 2010, at 9:16 PM, Michael Brand wrote:

> Hi all,
>
>
> 1) I tried to set the precision for the spreadsheet calculation to  
> p20 like mentioned in the Org info manual "3.5.2 Formula syntax for  
> Calc":
> I got
>
> | 0.1666666700000000 |
> #+TBLFM: $1 = 1 / 2 * 3; %.16f p20
>
> but I expect
>
> | 0.1666666666666667 |
> #+TBLFM: $1 = 1 / 2 * 3; %.16f p20

You need p20f20

p20 is for internal computation, f20 for youput, and the table
gets the value through output.  Confusing, yes....


HTH

- Carsten

>
> What am I missing? org-version is the current 6.34c, GNU Emacs  
> version is 21.1.1
>
>
> Thanks,
> Michael
>
>
> _______________________________________________
> Emacs-orgmode mailing list
> Please use `Reply All' to send replies to the list.
> Emacs-orgmode@gnu.org
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode

- Carsten

  reply	other threads:[~2010-02-26 20:34 UTC|newest]

Thread overview: 15+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2010-02-26 20:16 Precision setting for spreadsheet calculation Michael Brand
2010-02-26 20:34 ` Carsten Dominik [this message]
2010-02-26 21:12   ` Michael Brand
2010-02-26 21:28     ` Carsten Dominik
2010-02-26 21:58       ` Michael Brand
2010-02-26 23:11         ` Carsten Dominik
2010-02-27  8:11           ` Michael Brand
2010-03-02 20:15             ` Michael Brand
2010-03-03 12:20               ` Carsten Dominik
2010-04-18 13:41               ` Michael Brand
2010-04-21 15:52                 ` Carsten Dominik
     [not found] <4B90C320.8060100@alumni.ethz.ch>
2010-03-11  6:28 ` Fwd: " Carsten Dominik
2010-03-11  9:29   ` Eric S Fraga
2010-03-11 11:35     ` Carsten Dominik
2010-03-11 12:18       ` Eric S Fraga
2010-03-11 19:17         ` Michael Brand
     [not found]           ` <22909.1268336968@gamaville.dokosmarshall.org>
2010-03-11 20:04             ` Eric S Fraga

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=0AEABCAD-CA2E-4F84-99E1-B5670FEC1E8D@gmail.com \
    --to=carsten.dominik@gmail.com \
    --cc=emacs-orgmode@gnu.org \
    --cc=michael.brand@alumni.ethz.ch \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).