Comment 16 for bug 210153

Revision history for this message
Arrigo Marchiori (ardovm) wrote : Re: [Upstream] [hardy] calc: sum show err:529

Hello,

I am digging up this bug, please let me know if it's better to open a new one.

In reply to Chris Cheney, 2008-04-12: it seems to me that current versions of OpenOffice do _not_ show error 529 (or "#VALUE") but treat strings as zeroes instead.

In particular:
 - OpenOffice 3.0.1 for Windows, downloaded in binary form from openoffice.org web site;
 - OpenOffice 3.0.1 compiled from FreeBSD ports collection;
 - the version that Nicole (2008-09-28) said to have downloaded
all show the "old" behavior.

Since OO 3.0.1 is the latest version, I think that this contradicts what Chris was told at GoOOCon: official versions of OpenOffice still do treat strings as zeroes.

It seems to me that only the Ubuntu builds show an explicit error in this case. I've checked:
 - OpenOffice 2.4.1 included in Hardy;
 - latest version of OpenOffice for Hardy downloaded from ppa.launchpad.net (openoffice-pkgs).

I therefore suggest to let the Ubuntu build behave the same as the official one. I think that not doing so would break, for some users, one of the best features of OpenOffice: being a platform-invariant program.