[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Allow Currency Symbols and Grouping Commas in Table Numbers
From: |
Ihor Radchenko |
Subject: |
Re: Allow Currency Symbols and Grouping Commas in Table Numbers |
Date: |
Fri, 27 May 2022 22:49:58 +0800 |
"Daniel E. Doherty" <ded@ddoherty.net> writes:
> | Description | Amount |
> |--------------+------------|
> | Mortage | 125,000.26 |
> | Credit Cards | 6,325.00 |
> | Auto Loan | 14,853.00 |
> |--------------+------------|
> | Total | 1323.26 |
> #+TBLFM: @5$2=vsum(@I..@II)
>
> Note that the total is wrong.
Well. This is also a caveat from calc, unfortunately.
7.7.2 Grouping Digits
Please note that grouped numbers will not generally be parsed
correctly if re-read in textual form, say by the use of ‘C-x * y’ and
‘C-x * g’. (*Note Kill and Yank::, for details on these commands.) One
exception is the ‘\,’ separator, which doesn’t interfere with parsing
because it is ignored by TeX language mode.
So, you can instead do
| Description | Amount |
|--------------+-------------|
| Mortage | 125\,000.26 |
| Credit Cards | 6\,325.00 |
| Auto Loan | 14\,853.00 |
|--------------+-------------|
| Total | 146178.26 |
#+TBLFM: @5$2=vsum(@I..@II)
Or with
#+begin_SRC emacs-lisp
(setq org-calc-default-modes
'( calc-internal-prec 12
calc-float-format (float 8)
calc-angle-mode deg
calc-prefer-frac nil
calc-symbolic-mode nil
calc-language latex ;; <--- this is new compared to default, enable
latex symbols
calc-group-digits t ;; <--- group digits in the results
calc-group-char "\\,"
calc-date-format (YYYY "-" MM "-" DD " " Www (" " hh ":" mm))
calc-display-working-message t))
#+end_SRC
| Description | Amount |
|--------------+-------------|
| Mortage | 125\,000.26 |
| Credit Cards | 6\,325.00 |
| Auto Loan | 14\,853.00 |
|--------------+-------------|
| Total | 146\,178.26 |
#+TBLFM: @5$2=vsum(@I..@II)
> | Description | Amount |
> |--------------+----------------------------|
> | Mortage | \dollar 125000.26 |
> | Credit Cards | 6325.00 |
> | Auto Loan | 14853.00 |
> |--------------+----------------------------|
> | Total | 125000.26 \dollar + 21178. |
> #+TBLFM: @5$2=vsum(@I..@II)
>
> Total is still wrong.
You need
| Description | Amount |
|--------------+----------------------------|
| Mortage | \dollar 125000.26 |
| Credit Cards | \dollar 6325.00 |
| Auto Loan | \dollar 14853.00 |
|--------------+----------------------------|
| Total | 146178.26 \dollar |
#+TBLFM: @5$2=vsum(@I..@II)
Best,
Ihor