From mboxrd@z Thu Jan  1 00:00:00 1970
From: Michael Brand <michael.ch.brand@gmail.com>
Subject: Re: column view extension
Date: Tue, 17 Jan 2012 20:33:56 +0100
Message-ID: <CALn3zogZYpzb6xaRvgYJE+wCxHaWhnNebsr73zSpqotLVC8GNQ@mail.gmail.com>
References: <134e8528ba1.-5851758924314670245.5302843484598427533@zoho.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([140.186.70.92]:56009)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1RnEnA-0001ca-54
	for emacs-orgmode@gnu.org; Tue, 17 Jan 2012 14:34:01 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1RnEn8-0001MM-KS
	for emacs-orgmode@gnu.org; Tue, 17 Jan 2012 14:34:00 -0500
Received: from mail-we0-f169.google.com ([74.125.82.169]:35374)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1RnEn8-0001J7-Fx
	for emacs-orgmode@gnu.org; Tue, 17 Jan 2012 14:33:58 -0500
Received: by werl4 with SMTP id l4so2271204wer.0
	for <emacs-orgmode@gnu.org>; Tue, 17 Jan 2012 11:33:57 -0800 (PST)
In-Reply-To: <134e8528ba1.-5851758924314670245.5302843484598427533@zoho.com>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: ayvango <ayvango@zoho.com>
Cc: emacs-orgmode@gnu.org

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