Re: [O] Bug in structmode++?
- Igor Sosa Mayor writes: Am Sun, May 12, 2013 at 03:59:00PM +0100, Christopher Schmidt wrote: Please give the current master a try. After the commit 0ea11e26e46f2f562c1997cf1645dd744d5f6f2f you did, it seems to work again. Yes, I confirm, it works for me too. Thanks man! thanks a lot. -- :: Igor Sosa Mayor :: joseleopoldo1...@gmail.com :: :: GnuPG: 0x1C1E2890 :: http://www.gnupg.org/ :: :: jabberid: rogorido :::: -- -dude Too brief? Here's why! http://emailcharter.org
[O] date calculation in org table
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
Re: [O] date calculation in org table
- 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
Re: [O] date calculation in org table
- 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
Re: [O] Bug in structmode++?
- Igor Sosa Mayor writes: I don't want to be annoying... but am I really alone with this problem? Am Wed, May 01, 2013 at 05:03:51PM +0200, Igor Sosa Mayor wrote: No, you're not alone. I'm experiencing the same behavior and I'm running the exact same versions. It's really annoying. org-version: 8.0.2; emacs-version: 24.3.1 Hi, Orgstruct minor mode is working with the mail-mode a little strange. If I write a simple list where every item is smaller than a line, I can use M-RET and a new item is inserted as expected. But if the item goes over one line, the second line is not indented and moreover M-RET does not work anymore. org-version: 8.0.2; emacs: 24.3.1 thanks in advance -- :: Igor Sosa Mayor :: joseleopoldo1...@gmail.com :: :: GnuPG: 0x1C1E2890 :: http://www.gnupg.org/ :: :: jabberid: rogorido :::: cheers -- -dude Too brief? Here's why! http://emailcharter.org
