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.
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.