Re: empty/nil in table cells

[Mario Frasca]

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.

regards,

MF