From mboxrd@z Thu Jan 1 00:00:00 1970 From: The Dude Subject: date calculation in org table Date: Thu, 23 May 2013 08:43:14 +0200 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Return-path: Received: from eggs.gnu.org ([208.118.235.92]:36510) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1UfPGX-000264-Lu for emacs-orgmode@gnu.org; Thu, 23 May 2013 02:44:46 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1UfPGU-0001bp-AO for emacs-orgmode@gnu.org; Thu, 23 May 2013 02:44:45 -0400 Received: from plane.gmane.org ([80.91.229.3]:53370) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1UfPGU-0001bT-4F for emacs-orgmode@gnu.org; Thu, 23 May 2013 02:44:42 -0400 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1UfPFF-0006Wl-Hz for emacs-orgmode@gnu.org; Thu, 23 May 2013 08:43:25 +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 ; Thu, 23 May 2013 08:43:25 +0200 Received: from rafal.kowalski by 107-230.3-85.cust.bluewin.ch with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 23 May 2013 08:43:25 +0200 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: emacs-orgmode@gnu.org Hi all, I'm having hard time to find a solution to my problem. I've got a simple table with a dates column where I set an $sdate variable in the first row. What I want to achieve is that the dates in the column 4 are the sum of the date from the row above plus the number of days in column 3 in the same row apart from the field @4$4 which uses the $sdate variable; thus my naïve column and field formulae: @4$4=$sdate + $3::$4=@-1$4+$3 --8<---------------cut here---------------start------------->8--- * Test date table | | WP | Days | Arrival Date | |---+----+------+------------------| | # | | | <2013-06-05 Wed> | | ^ | | | sdate | |---+----+------+------------------| | | 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$4=$sdate + $3::$4=@-1$4+$3::@21$3=vsum(@II..@III)::@21$4=@III-1::$sdate=<2013-06-05 Wed> --8<---------------cut here---------------end--------------->8--- The problem is that when I change the $sdate and recalculate the whole table with `C-u C-u C-c C-c' only the element @4$4 is set. It seems like the column formula doesn't apply to the other fields. So the question is what am I doing wrongly? Didn't I get how the column formula works or is it a problem with the date calculation? Any help would be very much appreciated, cheers -- -dude Too brief? Here's why! http://emailcharter.org