Re: [O] very long table calc expressions ?

> On 22/06/2018 18:48, Nick Dokos wrote: > A utility lisp function can enhance readability: > #+begin_src elisp >   (defun test-to-interval (x) >     (let ((n (string-to-number x))) >   (cond >    ((equal x "")  "NP") >    ((and (<= 0 n) (<= n 4.9))

Re: [O] very long table calc expressions ?

On 22/06/2018 18:48, Nick Dokos wrote: > Uwe Brauer writes: > >> Hi Jonathan >> >>> Hi Uwe, >>> On Fri, Jun 22, 2018 at 10:16 AM, Uwe Brauer wrote: >> >>> (::) >>> not just a single. Brent's example has it with double while yours only >>> shows >>> it with a single one. >

Re: [O] very long table calc expressions ?

Uwe Brauer writes: > Hi Jonathan > >> Hi Uwe, >> On Fri, Jun 22, 2018 at 10:16 AM, Uwe Brauer wrote: > >> (::) >> not just a single. Brent's example has it with double while yours only >> shows >> it with a single one. > > Right, thanks for clarifying that. My original e

Re: [O] very long table calc expressions ?

Hi Jonathan > Hi Uwe, > On Fri, Jun 22, 2018 at 10:16 AM, Uwe Brauer wrote: > (::) > not just a single. Brent's example has it with double while yours only > shows > it with a single one. Right, thanks for clarifying that. My original example had various :: and indeed there B

Re: [O] very long table calc expressions ?

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 | >

Re: [O] very long table calc expressions ?

> 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

Re: [O] very long table calc expressions ?

Uwe Brauer writes: >> Uwe Brauer writes: > > Hello Bernt, >> 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. > > Thanks for pointing this out to me, but I seem unable to do it. > > When I u

Re: [O] very long table calc expressions ?

> Uwe Brauer writes: Hello Bernt, > 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. Thanks for pointing this out to me, but I seem unable to do it. When I use C-c ' I obtain that very long formu

Re: [O] very long table calc expressions ?

Uwe Brauer 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))::@

Re: [O] very long table calc expressions ?

> Le 20/06/2018 11:09, Uwe Brauer a écrit : > I included such an example (and added your name to the contributors list). Thanks! I don't feel that I am a contributor, but thanks very much. > Not easily. orgaggregate groups rows using equality, whereas you need to > group rows based

Re: [O] very long table calc expressions ?

Le 20/06/2018 11:09, Uwe Brauer a écrit : > Le 19/06/2018 19:21, Uwe Brauer a écrit : > You may want to take a look at the orgtbl-aggregate package available on > Melpa. Thanks very much. I have already installed that package but the example presented in the documentation were too

Re: [O] very long table calc expressions ?

> Le 19/06/2018 19:21, Uwe Brauer a écrit : > You may want to take a look at the orgtbl-aggregate package available on > Melpa. > #+BEGIN: aggregate :table "data" :cols "'Cual 1' count()" > | 'Cual 1' | count() | > |--+-| > | NT | 3 | > | MH

Re: [O] very long table calc expressions ?

Le 19/06/2018 19:21, Uwe Brauer a écrit : Hi Take the following example #+TBLNAME: data | Name | Cual 1 | |--+| | A| NT | | B| NT | | C| MH | | D| AP | | E| MH | | F| SS | | G| NP | | H| NP | | I

[O] very long table calc expressions ?

Hi Take the following example #+TBLNAME: data | Name | Cual 1 | |--+| | A| NT | | B| NT | | C| MH | | D| AP | | E| MH | | F| SS | | G| NP | | H| NP | | I| NP | | | NT | | | AP |