From mboxrd@z Thu Jan  1 00:00:00 1970
From: Bernt Hansen <bernt@norang.ca>
Subject: Re: very long table calc expressions ?
Date: Thu, 21 Jun 2018 15:06:52 -0400
Message-ID: <87d0wknelv.fsf@norang.ca>
References: <87k1qu1yl5.fsf@mat.ucm.es>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:45997)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <bernt@norang.ca>) id 1fW4v7-0006DK-36
	for emacs-orgmode@gnu.org; Thu, 21 Jun 2018 15:07:03 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <bernt@norang.ca>) id 1fW4v3-0005HG-UR
	for emacs-orgmode@gnu.org; Thu, 21 Jun 2018 15:07:01 -0400
Received: from outbound1a.eu.mailhop.org ([52.58.109.202]:53171)
	by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32)
	(Exim 4.71) (envelope-from <bernt@norang.ca>) id 1fW4v3-0005Gq-Nk
	for emacs-orgmode@gnu.org; Thu, 21 Jun 2018 15:06:57 -0400
Received: from localhost.localdomain (gollum.intra.norang.ca [192.168.1.5])
	by mail.norang.ca (8.14.4/8.14.4/Debian-4) with ESMTP id w5LJ6qR1027468
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT)
	for <emacs-orgmode@gnu.org>; Thu, 21 Jun 2018 15:06:53 -0400
Received: from localhost.localdomain (gollum [127.0.0.1])
	by localhost.localdomain (8.14.3/8.14.3/Debian-9.4) with ESMTP id
	w5LJ6qvk025046
	for <emacs-orgmode@gnu.org>; Thu, 21 Jun 2018 15:06:52 -0400
In-Reply-To: <87k1qu1yl5.fsf@mat.ucm.es> (Uwe Brauer's message of "Tue, 19 Jun
	2018 19:21:42 +0200")
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"
	<emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
To: emacs-orgmode@gnu.org

Uwe Brauer <oub@mat.ucm.es> writes:

> #+TBLNAME: stat-final2
> |    | Frequency |
> |----+-----------|
> | SS |         1 |
> | AP |         5 |
> | NT |         3 |
> | SB |         1 |
> | MH |         2 |
> | NP |         3 |
> #+TBLFM: @>$2='(length (org-lookup-all "NP" '(remote(data,@2$2..@>I$2)) nil))::@>>$2='(length (org-lookup-all "MH" '(remote(data,@2$2..@>I$2)) nil))::@>>>$2='(length (org-lookup-all "SB" '(remote(data,@2$2..@>I$2)) nil))::@>>>>$2='(length (org-lookup-all "NT" '(remote(data,@2$2..@>I$2)) nil))::@>>>>>$2='(length (org-lookup-all "AP" '(remote(data,@2$2..@>I$2)) nil))::@>>>>>>$2='(length (org-lookup-all "SS" '(remote(data,@2$2..@>I$2)) nil))
>
>
> Are there any rules to break this very long expression?

Hi Uwe,

You can edit or view the table formulas with C-c ' in case that helps.
This splits the formulas one per line for editing.

Regards,
Bernt