Re: empty/nil in table cells

[Mario Frasca <mario@anche.no>]

[-- Attachment #1: Type: text/plain, Size: 1078 bytes --]

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


[-- Attachment #2: Type: text/html, Size: 1711 bytes --]