Re: [O] Distinguish between blank and zero in org-mode spreadsheet

[Thorsten Jolitz]

Bob Newell <address@hidden> writes:

> The problem obviously revolves around a blank cell being interpreted
> as zero. That's all well and good, and quite correct, but makes
> distinguishing blank and explicit zero more difficult.

I don't think thats "well and good, and quite correct", otherwise all
the statistics packages wouldn't have the notion of 'Na' (not available)
or 'NaN' (Not a Number). I was bothered by the same problem like you,
and its makes life quite complicated when trying to write formulas. 

AFAIL calc actually has the notion of NaN, but it doesn't work in Org
tables, at least when I tried (quite some time ago). 
This would be a great improvement, if table formulas actually could
reference 'empty cells'. 

-- 
cheers,
Thorsten