From mboxrd@z Thu Jan  1 00:00:00 1970
From: The Dude <rafal.kowalski@mac.com>
Subject: Re: date calculation in org table
Date: Thu, 23 May 2013 16:47:47 +0200
Message-ID: <m2a9nllpm4.fsf@mac.com>
References: <m2sj1ekxh9.fsf@mac.com>
	<CALn3zog1UVRks+EhnM5i86JxQHxx3nVoN+_6bxjO4hz6pbMFOg@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([208.118.235.92]:33928)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1UfWoM-0004wD-4V
	for emacs-orgmode@gnu.org; Thu, 23 May 2013 10:48:17 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1UfWoE-0003pZ-7r
	for emacs-orgmode@gnu.org; Thu, 23 May 2013 10:48:10 -0400
Received: from plane.gmane.org ([80.91.229.3]:60068)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1UfWoE-0003ni-1D
	for emacs-orgmode@gnu.org; Thu, 23 May 2013 10:48:02 -0400
Received: from list by plane.gmane.org with local (Exim 4.69)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1UfWoB-0006Rc-Ds
	for emacs-orgmode@gnu.org; Thu, 23 May 2013 16:47:59 +0200
Received: from 107-230.3-85.cust.bluewin.ch ([85.3.230.107])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Thu, 23 May 2013 16:47:59 +0200
Received: from rafal.kowalski by 107-230.3-85.cust.bluewin.ch with local
	(Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Thu, 23 May 2013 16:47:59 +0200
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=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: emacs-orgmode@gnu.org

-> Michael Brand writes:

[...]

> Let me suggest one more variant. No row numbers, uses the fact that
> the formula for $3 is not evaluated in the header and it circumvents
> the bug:

> |   | WP | Days | Arrival Date     |
> |   |    |      | <2013-06-05 Wed> |
> |---+----+------+------------------|
> |   |  1 |    4 | <2013-06-09 Sun> |
> |   |  - |    2 | <2013-06-11 Tue> |
> |   |  2 |    4 | <2013-06-15 Sat> |
> |   |  - |    2 | <2013-06-17 Mon> |
> |   |  3 |    1 | <2013-06-18 Tue> |
> |   |  4 |    2 | <2013-06-20 Thu> |
> |   |  5 |    1 | <2013-06-21 Fri> |
> |   |  - |    2 | <2013-06-23 Sun> |
> |   |  6 |    1 | <2013-06-24 Mon> |
> |   |  7 |    2 | <2013-06-26 Wed> |
> |   |  - |    1 | <2013-06-27 Thu> |
> |   |  8 |    1 | <2013-06-28 Fri> |
> |   |  9 |    1 | <2013-06-29 Sat> |
> |   |  - |    3 | <2013-07-02 Tue> |
> |   | 10 |    3 | <2013-07-05 Fri> |
> |   |  - |    1 | <2013-07-06 Sat> |
> |   | 11 |    2 | <2013-07-08 Mon> |
> |---+----+------+------------------|
> |   |    |   33 | <2013-07-08 Mon> |
> #+TBLFM: $4 = @-1 + $3 :: @>$3 = vsum(@I..@II) :: @>$4 = @-1

That's a very nice variant and works well.  Thanks.  

BTW, what is the difference between `C-u C-c C-c' and `C-u C-*'?  I
thought they're doing the same thing.

> Michael

cheers
-- 
-dude

Too brief? Here's why! http://emailcharter.org