Hi ayvango On Mon, Jan 16, 2012 at 22:00, ayvango <ayva...@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