emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
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)


  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:

  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 \


* 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


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).