[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: empty/nil in table cells

From: Mario Frasca
Subject: Re: empty/nil in table cells
Date: Fri, 10 Jul 2020 09:27:54 -0500
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.10.0

On 09/07/2020 16:59, Nicolas Goaziou wrote:
and it simplifies a lot writing functions. 
How so?

thank you Michael, for answering Nicolas' question, in a different and much structured way than I did in my original message.

the formula you provided —I reduced it slightly, hard coding a constant— looks like this:

(if (> @# 4) (format "%.2f" (/ (apply '+ (subseq '(@I$2..@II$2) (- @# 1 4) (- @# 1))) 4.0)) ""));N

my impression is this programs in the spreadsheet something that should be part of the org-table software.

if we let references leading outside the table return 'nil instead of raising an error, and represent 'nil by the empty string, then this is enough:

(when (> @# 4) (/ (+ @-3$2..$2) 4.0));L%0.2f

my suggestion is to associate 'nil with empty cells "both ways", in the sense that a formula returning 'nil causes an empty org-table cell (see above), and that the empty cell, through the L filter evaluates to nil and not to the empty string.  this for symmetry, and for uniformity with reference leading outside the table.



reply via email to

[Prev in Thread] Current Thread [Next in Thread]