From: "Rainer Thiel" <r.thiel@uni-jena.de>
To: Carsten Dominik <dominik@uva.nl>, emacs-orgmode <emacs-orgmode@gnu.org>
Subject: Re: adding up decimal fractions in the spreadsheet
Date: Sat, 27 Sep 2008 16:20:05 +0200 [thread overview]
Message-ID: <d6b6c7740809270720j3b44fd38q6171252e9ba86a7f@mail.gmail.com> (raw)
In-Reply-To: <B1260157-B3E5-4704-8739-F4718BDFCAEC@uva.nl>
Hi Carsten,
2008/9/27 Carsten Dominik <dominik@uva.nl>:
> The other thing you can do is to use your own format to convert the number.
> Maybe something like "%.2f" will work for you? Hard to make this correct
> for the general case though.
Yes, this is not a way to go, as far as I can see, for exactly that reason.
Interestingly,
| 12130.68 |
| -1444.19 |
| -12744.90 |
| -186.00 |
| 7000.00 |
| -7056.00 |
| -335.58 |
| -277.00 |
| -2912.99 |
#+TBLFM: @9$1=@1$1+@2$1+@3$1+@4$1+@5$1+@6$1+@7$1+@8$1
gives the correct value, there's no need to add `;f2' at the end of
the last line. This in itself is a way to go, of course, but would be
more comfortable to have a way to sum up all rows but the last one
(without having to keep track of the number of rows) or at least to
work with ranges, which as far as I have seen so far seems not to be
possible in this case.
These are minutiae, of course. org-mode is already excellent, and
since I discovered it a few weeks ago, I've been making use of it at
all times.
Many thanks again,
Rainer
--
Prof. Dr. Rainer Thiel
Institut für Altertumswissenschaften
07737 Jena, Germany (EU)
r.thiel@uni-jena.de
next prev parent reply other threads:[~2008-09-27 14:20 UTC|newest]
Thread overview: 7+ messages / expand[flat|nested] mbox.gz Atom feed top
2008-09-27 7:19 adding up decimal fractions in the spreadsheet Rainer Thiel
2008-09-27 12:19 ` Carsten Dominik
[not found] ` <d6b6c7740809270606p679feb82n6fbe5f4d582ebcfa@mail.gmail.com>
[not found] ` <B1260157-B3E5-4704-8739-F4718BDFCAEC@uva.nl>
2008-09-27 14:20 ` Rainer Thiel [this message]
2008-09-27 17:59 ` Carsten Dominik
2008-09-27 13:21 ` Manish
2008-09-27 13:29 ` Rainer Thiel
2008-09-29 2:46 ` Manish
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=d6b6c7740809270720j3b44fd38q6171252e9ba86a7f@mail.gmail.com \
--to=r.thiel@uni-jena.de \
--cc=dominik@uva.nl \
--cc=emacs-orgmode@gnu.org \
/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).