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 09:51:40 +0200
Message-ID: <m2k3mqkub7.fsf@mac.com>
References: <m2sj1ekxh9.fsf@mac.com> <m2d2sitb23.fsf@vpn-client437.uio.no>
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]:53489)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1UfQJc-0001Mv-8x
	for emacs-orgmode@gnu.org; Thu, 23 May 2013 03:52:05 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1UfQJX-0007GY-An
	for emacs-orgmode@gnu.org; Thu, 23 May 2013 03:52:00 -0400
Received: from plane.gmane.org ([80.91.229.3]:46338)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1UfQJX-0007GO-3u
	for emacs-orgmode@gnu.org; Thu, 23 May 2013 03:51:55 -0400
Received: from list by plane.gmane.org with local (Exim 4.69)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1UfQJU-0002zf-Fc
	for emacs-orgmode@gnu.org; Thu, 23 May 2013 09:51:52 +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 09:51:52 +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 09:51:52 +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

-> Christian Moe writes:

> Hi, Dude,

> Not quite sure why that doesn't work (nor gives an error message about
> trying to set the same cell). However, it will work if you specify the
> cell range:

>> @4$4=$sdate + $3::$4=@-1$4+$3
>                     ^^   
>   @4$4=$sdate + $3::@5$4..@20$4=@-1$4+$3
>                     ^^^^^^^^^^^

Yep, that works perfectly.  The only drawback is when I have to add a
new row etc. but I can live with that.  Thanks!

> BTW, it's OK to omit the reference to the same column, so you can save
> two characters:

>   @4$4=$sdate + $3::@5$4..@20$4=@-1$4+$3
>                                    ^^
>   @4$4=$sdate + $3::@5$4..@20$4=@-1+$3 

Got it.

> Yours,
> Christian

cheers
-- 
-dude

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