Re: [O] Sub-totals

2014-02-19 Thread Michael Brand
Hi Cecil On Sun, Feb 16, 2014 at 10:06 AM, Michael Brand wrote: > #+TBLFM: @>$2 = vsum(@II..@>>) :: $3 = if(vlen(@-I$2..@0$2) == > vlen(@-I$2..@+I$2), vsum(@-I$2..@+I$2) +.0, string("")); EN f-1 :: @>$3 = > string("") I should have simplified the condition in "if" to #+TBLFM: @>$2 = vsum(@II

Re: [O] Sub-totals

2014-02-19 Thread Michael Brand
On Wed, Feb 19, 2014 at 1:54 PM, Nick Dokos wrote: > Nice! Worth a mention in the org-hacks section on Worg I think. Maybe. Instead I would like to favor to look at the page with the Worg tutorials and in the spreadsheet section to follow the link to the "Emacs Regression Test (ERT) for Org table

Re: [O] Sub-totals

2014-02-19 Thread Nick Dokos
Cecil Westerhof writes: > 2014-02-16 10:06 GMT+01:00 Michael Brand : > > > - I would like to have only the last element of the range filled. > > I always thought that this would not be possible with reasonable > effort. Your question made me think again and it is possible, now I >

Re: [O] Sub-totals

2014-02-18 Thread Cecil Westerhof
2014-02-16 10:06 GMT+01:00 Michael Brand : > > - I would like to have only the last element of the range filled. > > I always thought that this would not be possible with reasonable > effort. Your question made me think again and it is possible, now I > can change my own use cases with sub-total :

Re: [O] Sub-totals

2014-02-16 Thread Michael Brand
Hi Cecil On Sat, Feb 15, 2014 at 6:14 PM, Cecil Westerhof wrote: > - I would like to have only the last element of the range filled. I always thought that this would not be possible with reasonable effort. Your question made me think again and it is possible, now I can change my own use cases wi

Re: [O] Sub-totals

2014-02-15 Thread Cecil Westerhof
2014-02-15 18:14 GMT+01:00 Cecil Westerhof : > 2014-02-15 16:19 GMT+01:00 Michael Brand : > > What about this?: >> >> |--+--+-| >> | activity | Time | sub | >> |--+--+-| >> | Activity A |3 | | >> |--+--+-| >> | Activity B

Re: [O] Sub-totals

2014-02-15 Thread Cecil Westerhof
2014-02-15 16:19 GMT+01:00 Michael Brand : > What about this?: > > |--+--+-| > | activity | Time | sub | > |--+--+-| > | Activity A |3 | | > |--+--+-| > | Activity B |5 | 34 | > | Activity C |2 | 34 | > | Activ

Re: [O] Sub-totals

2014-02-15 Thread Michael Brand
Hi Cecil What about this?: |--+--+-| | activity | Time | sub | |--+--+-| | Activity A |3 | | |--+--+-| | Activity B |5 | 34 | | Activity C |2 | 34 | | Activity D |7 | 34 | | Activity E |8 | 34 |

[O] Sub-totals

2014-02-15 Thread Cecil Westerhof
At the moment I have the folowing: |--+--+-| | activity | Time | sub | |--+--+-| | Activity A |3 | | | Activity B |5 | | | Activity C |2 | | | Activity D |7 | | | Activity E |8 | | | Activity F | 12 |