From mboxrd@z Thu Jan 1 00:00:00 1970 From: Jonathan Leech-Pepin Subject: Re: very long table calc expressions ? Date: Fri, 22 Jun 2018 11:03:19 -0400 Message-ID: References: <87k1qu1yl5.fsf@mat.ucm.es> <87d0wknelv.fsf@norang.ca> <87a7rnglnq.fsf@mat.ucm.es> <874lhvnepj.fsf@norang.ca> <877emqgb4g.fsf@mat.ucm.es> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="0000000000004eaa1d056f3c566e" Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:50662) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1fWNbC-0004qQ-SD for emacs-orgmode@gnu.org; Fri, 22 Jun 2018 11:03:43 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1fWNbB-0004fA-VL for emacs-orgmode@gnu.org; Fri, 22 Jun 2018 11:03:42 -0400 Received: from mail-oi0-x22b.google.com ([2607:f8b0:4003:c06::22b]:44287) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1fWNbB-0004eM-Ou for emacs-orgmode@gnu.org; Fri, 22 Jun 2018 11:03:41 -0400 Received: by mail-oi0-x22b.google.com with SMTP id c128-v6so6370440oig.11 for ; Fri, 22 Jun 2018 08:03:41 -0700 (PDT) In-Reply-To: <877emqgb4g.fsf@mat.ucm.es> List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: "Emacs-orgmode" To: Org Mode Mailing List --0000000000004eaa1d056f3c566e Content-Type: text/plain; charset="UTF-8" Hi Uwe, On Fri, Jun 22, 2018 at 10:16 AM, Uwe Brauer wrote: > > > Uwe Brauer writes: > > > When I hit C-c ' in this table > > > #+TBLNAME: stat-final2 > > | | Frequency | > > > |----+-----------| > > | SS | | > > | AP | 5 | > > | NT | 3 | > > | SB | #ERROR | > > | MH | 2 | > > | NP | 3 | > > > > I get a new window with this in it: > > > # Field and Range Formulas > > @>$2 = '(length (org-lookup-all "NP" '(remote(data,@2$2..@>I$2)) > nil)) > > nil)) > > nil)) > > nil)) > > > and I can edit individual lines and then C-c C-c or C-c ' again to > exit > > and rebuild the formula line on the table. > > > Not for me, that is strange. Here is the screenshot I obtain (running > git master emacs from May and org git master form last July, so maybe > this feature is missing?) > > Pretty sure the spacer between formulas is supposed to be a double colon (::) not just a single. Brent's example has it with double while yours only shows it with a single one. Regards, Jon --0000000000004eaa1d056f3c566e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Uwe,

On Fri, Jun 22, 2018 at 10:16 AM, Uwe Brauer &= lt;oub@mat.ucm.es&g= t; wrote:

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

=C2=A0 =C2=A0> When I hit C-c ' in this table

=C2=A0 =C2=A0> #+TBLNAME: stat-final2
=C2=A0 =C2=A0> |=C2=A0 =C2=A0 | Frequency |

=C2=A0 =C2=A0> |----+-----------|
=C2=A0 =C2=A0> | SS |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0|
=C2=A0 =C2=A0> | AP |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A05 |
=C2=A0 =C2=A0> | NT |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A03 |
=C2=A0 =C2=A0> | SB |=C2=A0 =C2=A0 #ERROR |
=C2=A0 =C2=A0> | MH |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A02 |
=C2=A0 =C2=A0> | NP |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A03 |


=C2=A0 =C2=A0> I get a new window with this in i= t:

=C2=A0 =C2=A0> # Field and Range Formulas
=C2=A0 =C2=A0> @>$2 =3D '(length (org-lookup-all "NP" &= #39;(remote(data,@2$2..@>I$2)) nil))
=C2=A0 =C2=A0> nil))
=C2=A0 =C2=A0> nil))
=C2=A0 =C2=A0> nil))

=C2=A0 =C2=A0> and I can edit individual lines and then C-c C-c or C-c &= #39; again to exit
=C2=A0 =C2=A0> and rebuild the formula line on the table.


Not for me, that is strange. Here is the screenshot I obtain (runnin= g
git master emacs from May and org git master form last July, so maybe
this feature is missing?)

Pretty sure the spacer between formulas is supposed t= o be a double colon (::)
not just a single.=C2=A0 Brent's exa= mple has it with double while yours only shows
it with a single o= ne.

Regards,
Jon
=C2=A0
<= /div>
--0000000000004eaa1d056f3c566e--