[O] date calculation in org table

2013-05-23 Thread The Dude
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

Re: [O] date calculation in org table

2013-05-23 Thread Christian Moe
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 ^^^

Re: [O] date calculation in org table

2013-05-23 Thread The Dude
- 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

Re: [O] date calculation in org table

2013-05-23 Thread Michael Brand
Hi Rafal On Thu, May 23, 2013 at 8:43 AM, The Dude rafal.kowal...@mac.com wrote: 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. This I

Re: [O] date calculation in org table

2013-05-23 Thread The Dude
- 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 | |---++--+--| |

Re: [O] date calculation in org table

2013-05-23 Thread Michael Brand
Hi Rafal On Thu, May 23, 2013 at 4:47 PM, The Dude rafal.kowal...@mac.com wrote: BTW, what is the difference between `C-u C-c C-c' and `C-u C-*'? I thought they're doing the same thing. - `C-u C-c *' or `C-u C-c C-c': recalculate once - `C-u C-u C-c *' or `C-u C-u C-c C-c'