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

Wojtek Narczyński wojtek at power.com.pl
Sat Aug 16 19:53:58 UTC 2014


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.


More information about the Haskell-Cafe mailing list