Re: searching for csv utilities

[Michael Brand <michael.ch.brand@gmail.com>]

Hi Nick

On Thu, Jun 4, 2015 at 5:22 PM, Nick Dokos <ndokos@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