Hi Nick On Thu, Jun 4, 2015 at 5:22 PM, Nick Dokos <ndo...@gmail.com> wrote: > Also, if one uses a format on an undefined function (e.g. using > vmode(@I..@II); %.2f), I get 0.0 as a result and the error is hidden - > if the format is omitted, the literal vmode([...]) appears in the table, > so in that case at least one gets a hint that something is wrong. That > probably qualifies as a bug, but I don't know how easy it would be to fix.
Yes. Anyway, Calc has its own formatter which can be a solution: | Date | Sys | Dia | Pul | Sugar | |------------------+------------------+----------------+----------------+----------------| | [2014-04-27 Sun] | 125 | 88 | 78 | 92 | | [2014-04-28 Mon] | 102 | 88 | 86 | 92 | |------------------+------------------+----------------+----------------+----------------| | vmean | 113.50 | 88.00 | 82.00 | 92.00 | | vcount | 2.00 | 2.00 | 2.00 | 2.00 | | vmax | 125.00 | 88.00 | 86.00 | 92.00 | | vmedian | 113.50 | 88.00 | 82.00 | 92.00 | | vmin | 102.00 | 88.00 | 78.00 | 92.00 | | vstdev | vstdev(125, 102) | vstdev(88, 88) | vstdev(78, 86) | vstdev(92, 92) | | vsum | 227.00 | 176.00 | 164.00 | 184.00 | |------------------+------------------+----------------+----------------+----------------| #+TBLFM: @>>>>>>>$2..@>$> = apply($1, @I..@II) +.0; f-2 See also the Worg FAQ http://orgmode.org/worg/org-faq.html#table-float-fraction Michael
