Re: column view extension

[Michael Brand <michael.ch.brand@gmail.com>]

Hi ayvango

On Mon, Jan 16, 2012 at 22:00, ayvango <ayvango@zoho.com> wrote:
> I hope someone become interested in creating spreadtree application
> based on existing properties code.

This would be very useful for me too. There are several resources that
go towards this direction:

*formulas in colum spec #+COLUMNS*

First of course average/sum/min/max/... in the manual and talks, see
the links in
http://thread.gmane.org/gmane.emacs.orgmode/42071/focus=42088
but then there is also this very interesting whole thread about
org-columns-compute and org-columns-compile-map
http://thread.gmane.org/gmane.emacs.orgmode/12067

*org-collector*

See e. g.
http://thread.gmane.org/gmane.emacs.orgmode/42071/focus=42091

*dynamic block columnview with #+TBLFM:*

For an example see indent2_tbl4.org.txt attached here
http://lists.gnu.org/archive/html/emacs-orgmode/2011-11/msg00072.html
and for some issues see the whole thread here
http://thread.gmane.org/gmane.emacs.orgmode/48764

*remote() in #+TBLFM:*

A simple example that might be interesting for some special cases but
commonly quite inconvenient to change:
#+BEGIN_SRC org
  , #+STARTUP: odd
  , - hours are edited, the rest is calculated with
  ,   M-x org-table-iterate-buffer-tables
  , * parent
  ,   #+TBLNAME: parent
  ,   | days |
  ,   |    3 |
  ,   #+TBLFM: @>$1 = remote(child1, @>$1) + remote(child2, @>$1)
  , *** child1
  ,     #+TBLNAME: child1
  ,     | days | hours |   relative |
  ,     |    1 |     8 | 0.33333333 |
  ,     #+TBLFM: @>$1 = $2 / 8 :: @>$3 = $1 / remote(parent, @>$1)
  , *** child2
  ,     #+TBLNAME: child2
  ,     | days | hours |   relative |
  ,     |    2 |    16 | 0.66666667 |
  ,     #+TBLFM: @>$1 = $2 / 8 :: @>$3 = $1 / remote(parent, @>$1)
#+END_SRC

Michael