emacs-orgmode
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [O] Format a whole column using ";%.2f" in orgtbl?


From: Michael Brand
Subject: Re: [O] Format a whole column using ";%.2f" in orgtbl?
Date: Fri, 15 Jun 2012 19:01:35 +0200

Hi Alexander

On Fri, Jun 15, 2012 at 4:34 PM, AW <address@hidden> wrote:
> [...]
>
> Desired outoput:
>
> | 100.00 | Value |
> | 150.00 | Value |
> #+TBLFM: $1=%s;%.2f
>
> [...]

What you tried would be

| 100.00 | Value |
| 150.00 | Value |
#+TBLFM: $1=$0;%.2f

$0 is the current table field. What I recommend is

| 100.00 | Value |
| 150.00 | Value |
#+TBLFM: $1 = $0 +.0; f-2

because of the behavior I explained in the tables shown here:
http://orgmode.org/worg/org-faq.html#table-float-fraction

Michael



reply via email to

[Prev in Thread] Current Thread [Next in Thread]