From mboxrd@z Thu Jan 1 00:00:00 1970 From: Neil Jerram Subject: Re: Tables: Exclude headings in Row Number? Date: Thu, 19 Sep 2019 15:13:01 +0100 Message-ID: References: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="000000000000cc14b80592e88d92" Return-path: Received: from eggs.gnu.org ([2001:470:142:3::10]:54250) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1iAxBL-0000Rr-2Z for emacs-orgmode@gnu.org; Thu, 19 Sep 2019 10:13:16 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1iAxBJ-0006BL-HT for emacs-orgmode@gnu.org; Thu, 19 Sep 2019 10:13:14 -0400 Received: from mail-qt1-x82f.google.com ([2607:f8b0:4864:20::82f]:36679) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1iAxBJ-0006AI-D1 for emacs-orgmode@gnu.org; Thu, 19 Sep 2019 10:13:13 -0400 Received: by mail-qt1-x82f.google.com with SMTP id o12so4416653qtf.3 for ; Thu, 19 Sep 2019 07:13:13 -0700 (PDT) In-Reply-To: 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: Nathan Neff Cc: emacs-orgmode --000000000000cc14b80592e88d92 Content-Type: text/plain; charset="UTF-8" Does this answer your question? #+NAME: tt | num | ID | |-----+----| | 1 | A | | 2 | B | | 3 | C | | 4 | | | 5 | E | #+BEGIN_SRC emacs-lisp :var tt=tt (length tt) #+END_SRC #+RESULTS: : 5 Best wishes, Neil On Wed, 18 Sep 2019 at 18:39, Nathan Neff wrote: > Hello all, > > I have a table like this: > > > | ID | > |----| > | 2 | > | 3 | > > and I want to know how many rows there are w/o the ID heading > and w/o the horizontal separator. I found the > org-table-toggle-coordinate-overlays > which displays an overlay showing the row number: > > https://www.evernote.com/l/AOJvD5ty6RRIBYAcSWV-047CKCHT5NIAhl8 > > However, the heading is included in the row number (which makes sense). > > Is there a way to ignore lines above a heading (or mark a heading in some > way? > > I found a way to add a seq. number by using Calc [1] but I was wondering if > there's a way to tell the org-table-toggle-coordinate-overlays not to > count the > heading. > > Thanks, > --Nate > > [1] > > > | num | ID | > |-----+----| > | 1 | A | > | 2 | B | > | 3 | C | > | 4 | | > | 5 | E | > #+TBLFM: $1=vlen(@I..0) > > > https://stackoverflow.com/questions/9267050/how-to-achieve-a-row-index-column-in-emacs-org-mode-using-a-calc-column-rule > > > --000000000000cc14b80592e88d92 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Does this answer your question?

#+NAME:= tt
| num | ID |
|-----+----|
| =C2=A0 1 | A =C2=A0|
| =C2=A0 2= | B =C2=A0|
| =C2=A0 3 | C =C2=A0|
| =C2=A0 4 | =C2=A0 =C2=A0|
| = =C2=A0 5 | E =C2=A0|

#+BEGIN_SRC emacs-lisp :var tt=3Dtt
(length = tt)
#+END_SRC

#+RESULTS:
: 5

Best= wishes,
=C2=A0 =C2=A0 Neil


On Wed, 18 Sep 20= 19 at 18:39, Nathan Neff <natha= n.neff@gmail.com> wrote:
Hello all,

I have a table = like this:


| ID |
|-= ---|
| =C2=A02 |
| =C2=A03 |

=
and I want to know how many rows there are w/o the ID heading
and w/o the horizontal separator.=C2=A0 I found the org-table-toggle-coor= dinate-overlays
which displays an overlay showing the row number:=


However, t= he heading is included in the row number (which makes sense).
Is there a way to ignore lines above a heading (or mark a headi= ng in some way?

I found a way to add a seq. number= by using Calc [1] but I was wondering if
there's a way to te= ll the org-table-toggle-coordinate-overlays not to count the
head= ing.

Thanks,
--Nate

=
[1]


| num | ID |
|-----+----|
| =C2=A0 1 | A =C2=A0|
| =C2=A0 2 | B = =C2=A0|
| =C2=A0 3 | C =C2=A0|
| =C2=A0 4 | =C2=A0 =C2= =A0|
| =C2=A0 5 | E =C2=A0|
#+TBLFM: $1=3Dvlen(@I..0)



--000000000000cc14b80592e88d92--