From: Uwe Brauer <oub@mat.ucm.es>
To: emacs-orgmode@gnu.org
Subject: Re: problem with empty column
Date: Sat, 06 Jan 2018 09:37:04 +0100 [thread overview]
Message-ID: <87shbjv0wf.fsf@mat.ucm.es> (raw)
In-Reply-To: 87y3lcgy71.fsf@gmail.com
>>> "Eric" == Eric S Fraga <esflists@gmail.com> writes:
> On Friday, 5 Jan 2018 at 13:44, Uwe Brauer wrote:
>> What I meant is this.
> I understood what you meant and your code is working properly. You
> are checking the second column which is the column labelled E1, not
> the one labelled E2 which is actually the third column... change your
> if statement to check $3, not $2.
Maybe the format of the table was distorted.
| Name | E1 | E2 | E3 | E4 | Res |
|--------+----+----+----+----+-----|
| Entry1 | | | | | NP |
| Entry2 | 10 | 20 | 30 | 40 | 10 |
| Entry3 | 10 | | 20 | 30 | nan |
#+TBLFM: $6=if("$2" == "nan" , string("NP"),($2+$3+$4+$5)/10);E
The column of reference is E1 per default, which is the second one. The
row labeled Entry1 gives the expected result, NP, since its E1 entry is
empty but in the row labeled Entry3 E1 is not empty, so the second part
of the statement should be applied resulting in 6, but it does not it
results in nan, which I don't understand. The fact that E2 ($3) is empty
should be irrelevant here, but it is not.
On the other hand
| Name | E1 | E2 | E3 | E4 | Res |
|--------+----+----+----+----+-----|
| Entry1 | | | | | NP |
| Entry2 | 10 | 20 | 30 | 40 | 10 |
| Entry3 | 10 | 0 | 20 | 30 | 6 |
#+TBLFM: $6=if("$2" == "nan" , string("NP"),($2+$3+$4+$5)/10);E
Gives the expected result, that is adding 0 to E2 in row Entry3.
I am puzzled
Uwe
next prev parent reply other threads:[~2018-01-06 8:37 UTC|newest]
Thread overview: 9+ messages / expand[flat|nested] mbox.gz Atom feed top
2018-01-05 8:28 problem with empty column Uwe Brauer
2018-01-05 9:25 ` Loris Bennett
2018-01-05 9:35 ` Eric S Fraga
2018-01-05 12:44 ` Uwe Brauer
2018-01-05 13:55 ` Michael Brand
2018-01-06 8:43 ` Uwe Brauer
2018-01-05 14:46 ` Eric S Fraga
2018-01-06 8:37 ` Uwe Brauer [this message]
2018-01-06 11:23 ` Eric S Fraga
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
List information: https://www.orgmode.org/
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=87shbjv0wf.fsf@mat.ucm.es \
--to=oub@mat.ucm.es \
--cc=emacs-orgmode@gnu.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).