From mboxrd@z Thu Jan 1 00:00:00 1970 From: Michael Brand Subject: Re: searching for csv utilities Date: Thu, 4 Jun 2015 17:45:04 +0200 Message-ID: References: <87d21ciu82.fsf@alphaville.usersys.redhat.com> <87zj4gos5w.fsf@ucl.ac.uk> <877frjh51g.fsf@alphaville.usersys.redhat.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:45063) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Z0XKN-0000ow-GQ for emacs-orgmode@gnu.org; Thu, 04 Jun 2015 11:45:08 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1Z0XKL-0006YL-AH for emacs-orgmode@gnu.org; Thu, 04 Jun 2015 11:45:07 -0400 Received: from mail-yh0-x233.google.com ([2607:f8b0:4002:c01::233]:36033) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Z0XKL-0006XM-53 for emacs-orgmode@gnu.org; Thu, 04 Jun 2015 11:45:05 -0400 Received: by yhan67 with SMTP id n67so10992402yha.3 for ; Thu, 04 Jun 2015 08:45:04 -0700 (PDT) In-Reply-To: <877frjh51g.fsf@alphaville.usersys.redhat.com> List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Nick Dokos Cc: Org Mode Hi Nick On Thu, Jun 4, 2015 at 5:22 PM, Nick Dokos 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