Re: [Haskell-cafe] The Good, the Bad and the GUI

On 15.08.2014 16:17, Tom Nielsen wrote:

...

There is no excuse for a spreadsheet quietly taking a never-assigned cell as zero, but indeed it does.

May I contribute to this interesting discussion the observation:

1 <BLANK> 3 =PRODUCT(A1:A3)

gives 3 (in Gnumeric).

So for the PRODUCT function, blanks are treated as 1.

At the same time = A1 * A2 * A3 gives 0 (in OpenOffice). This is a bit too much, even for me.