From: Ihor Radchenko <yantar92@gmail.com>
To: "Daniel E. Doherty" <ded@ddoherty.net>
Cc: emacs-orgmode@gnu.org
Subject: Re: Allow Currency Symbols and Grouping Commas in Table Numbers
Date: Fri, 27 May 2022 16:22:54 +0800 [thread overview]
Message-ID: <87a6b3gza9.fsf@localhost> (raw)
In-Reply-To: <87pmk0qdfb.fsf@ddoherty.net>
"Daniel E. Doherty" <ded@ddoherty.net> writes:
> I often use org table to perform calculations and export those tables
> to LaTeX documents.
>
> One thing I always wished I could do with org tables is get it to
> allow numbers to be decorated with currency symbols, the dollar, euro,
> yen, etc., as well as grouping commas so that the tables are more
> suitable for presentation.
You can, for example, do
| 1 USD | 2 USD | 4 USD | 7 USD |
#+tblfm: $4=vsum($1..$3)
Emacs calc is able to work with arbitrary ascii symbols or even units.
However, calc does not appear work with unicode. If Emacs calc were to
support unicode, it would automatically work in Org.
Also, you can
enable latex in calc via
(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
calc-date-format (YYYY "-" MM "-" DD " " Www (" " hh ":" mm))
calc-display-working-message t))
Then, the following will work
| \dollar1 | \dollar2 | \dollar3 | 6 \dollar |
#+tblfm: $4=vsum($1..$3)
Best,
Ihor
next prev parent reply other threads:[~2022-05-27 8:23 UTC|newest]
Thread overview: 10+ messages / expand[flat|nested] mbox.gz Atom feed top
2022-05-26 19:40 Allow Currency Symbols and Grouping Commas in Table Numbers Daniel E. Doherty
2022-05-27 8:22 ` Ihor Radchenko [this message]
2022-05-27 11:00 ` Eric S Fraga
2022-05-27 11:17 ` Ihor Radchenko
2022-05-27 12:02 ` Eric S Fraga
2022-05-27 13:49 ` Daniel E. Doherty
2022-05-27 14:49 ` Ihor Radchenko
2022-05-31 14:19 ` Daniel E. Doherty
2022-06-02 4:57 ` Ihor Radchenko
2022-06-03 20:37 ` Daniel E. Doherty
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=87a6b3gza9.fsf@localhost \
--to=yantar92@gmail.com \
--cc=ded@ddoherty.net \
--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).