|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|
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
|[Prev in Thread]||Current Thread||[Next in Thread]|