From mboxrd@z Thu Jan 1 00:00:00 1970 From: suvayu ali Subject: Re: Re: org-table formulas with missing values Date: Sun, 6 Mar 2011 15:03:21 -0800 Message-ID: References: <86aahitzny.fsf@googlemail.com> <86ei6utkez.fsf@googlemail.com> <87ipw5prxc.fsf@altern.org> <86vczxbzuy.fsf@googlemail.com> <86sjuzdg2c.fsf@googlemail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Return-path: Received: from [140.186.70.92] (port=41724 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1PwMzH-0001lH-5M for emacs-orgmode@gnu.org; Sun, 06 Mar 2011 18:03:44 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1PwMzG-0002Im-9X for emacs-orgmode@gnu.org; Sun, 06 Mar 2011 18:03:43 -0500 Received: from mail-bw0-f41.google.com ([209.85.214.41]:41330) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1PwMzG-0002Id-3j for emacs-orgmode@gnu.org; Sun, 06 Mar 2011 18:03:42 -0500 Received: by bwz17 with SMTP id 17so3922238bwz.0 for ; Sun, 06 Mar 2011 15:03:41 -0800 (PST) In-Reply-To: <86sjuzdg2c.fsf@googlemail.com> List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Thorsten Cc: emacs-orgmode@gnu.org Hi Thorsten, Disclaimer: I haven't tried any of what I am proposing below. Its just a thought that came to me while reading your post. On Sun, Mar 6, 2011 at 2:44 PM, Thorsten wrote: > But even if nil would work, my basic question remains: if I have for > example a dynamic report were one code-block in the org file retrieves > new data frequently and stores them in a table, which has some formula > applied to it, and 0 values as well as missing values are possible, how > can I address the empty cells in the formula without confusion with > regards to the cells with 0 values? > Since recently calc code block support was added to babel, why not use that to process your table instead of table formulae? Wouldn't you expect it would be easier to deal with NaN and its likes directly with calc source compared to formulae? > Thorsten > -- Suvayu Open source is the future. It sets us free.