Bug 216031 – openoffice calc 2.4.0 Err:529 (not number cell not assumed ZERO)

• Product: Gentoo Linux
• Status: RESOLVED INVALID

[Description Horacio Hiroiti Sawame 2008-04-03 12:30:27 UTC]

I compiled openoffice-2.4.0 and noticed an strange error 529 (is not listed in "Error Codes in OpenOffice.org Calc").

Ex.:
A1="1"
A2="2"
A3=A1+A2="3"

The result is ok if A1 and A2 cells contain numbers but if a not number is placed I got "Err:529" .
A1="*"
A2="2"
A3=A1+A2="Err:529"

If I use A4=SUM(A1;A2) the correct (zero should be assumed for not number cells) is got.
This not happens with openoffice-2.3.1-r1 and before.

Reproducible: Always

Steps to Reproduce:
1.open oocalc;
2.put a number in a cell (A2=2), a not number in another (A1=g), and define a arithmetic operation with both (A3=A1+A2);
3.

Actual Results:  
A3=Err:529

Expected Results:  
A3=2

emerge -pv openoffice
[ebuild   R   ] app-office/openoffice-2.4.0  USE="binfilter cups dbus firefox gnome gstreamer gtk java kde ldap pam seamonkey -debug -eds -mono -odk -webdav -xulrunner" LINGUAS="en_US pt_BR -af -ar -as_IN -be_BY -bg -bn -br -bs -ca -cs -cy -da -de -dz -el -en -en_GB -en_ZA -eo -es -et -fa -fi -fr -ga -gl -gu_IN -he -hi_IN -hr -hu -it -ja -km -ko -ku -lt -lv -mk -ml_IN -mr_IN -nb -ne -nl -nn -nr -ns -or_IN -pa_IN -pl -pt -ru -rw -sh -sk -sl -sr -ss -st -sv -sw_TZ -ta_IN -te_IN -tg -th -ti_ER -tn -tr -ts -uk -ur_IN -ve -vi -xh -zh_CN -zh_TW -zu"

emerge --info
Portage 2.1.4.4 (default-linux/amd64/2007.0/desktop, gcc-4.1.2, glibc-2.6.1-r0, 2.6.24-gentoo-r4 x86_64)
=================================================================
System uname: 2.6.24-gentoo-r4 x86_64 AMD Athlon(tm) 64 Processor 3800+
Timestamp of tree: Thu, 03 Apr 2008 08:01:01 +0000
ccache version 2.4 [enabled]
app-shells/bash:     3.2_p17-r1
dev-java/java-config: 1.3.7, 2.1.4
dev-lang/python:     2.4.4-r9
dev-python/pycrypto: 2.0.1-r6
dev-util/ccache:     2.4-r7
sys-apps/baselayout: 1.12.11.1
sys-apps/sandbox:    1.2.18.1-r2
sys-devel/autoconf:  2.13, 2.61-r1
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2, 1.10
sys-devel/binutils:  2.18-r1
sys-devel/gcc-config: 1.4.0-r4
sys-devel/libtool:   1.5.26
virtual/os-headers:  2.6.23-r3
ACCEPT_KEYWORDS="amd64"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-mtune=athlon64 -O2 -pipe"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/kde/3.5/env /usr/kde/3.5/share/config /usr/kde/3.5/shutdown /usr/share/config /var/lib/hsqldb"
CONFIG_PROTECT_MASK="/etc/env.d /etc/env.d/java/ /etc/fonts/fonts.conf /etc/gconf /etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/ /etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/terminfo /etc/texmf/web2c /etc/udev/rules.d"
CXXFLAGS="-mtune=athlon64 -O2 -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="ccache distlocks metadata-transfer sandbox sfperms strict unmerge-orphans userfetch"
GENTOO_MIRRORS="http://gentoo.osuosl.org/ http://distro.ibiblio.org/pub/linux/distributions/gentoo/ http://www.las.ic.unicamp.br/pub/gentoo/ http://public.planetmirror.com/pub/gentoo/"
LANG="pt_BR.utf8"
LC_ALL="pt_BR.utf8"
LINGUAS="pt_BR en_US"
MAKEOPTS="-j2"
PKGDIR="/usr/portage/packages"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="3dnow 3dnowext 64bit 7zip X a52 aac aalib acpi alsa amd64 amr anthy apm arts asf audacious bash-completion binfilter bitmap-fonts blender-game bluetooth bzip2 cairo ccache cdda cddb cdparanoia cdr cdrom chardet chroot cjk cli cracklib crypt css cups cxx dbase dbus dga dia directfb divx djvu doc dri dts dv dvb dvd dvdnav dvdr dvdread dvi enca encode enscript examples exif fat fbcon fbdev ffmpeg file-icons firefox flac foomaticdb fortran fuse gcj gcrypt gdbm gif gimp gimpprint glade glitz gnome gnustep gnutls gphoto2 gpm gstreamer gtk2 gucharmap h323 hal hfs httpd iconv id3tag idea idn ieee1394 immqt-bc ipv6 jack java java5 javascript joystick jpeg jpeg2k kde kdeenablefinal kqemu lcms ldap libcaca live livebuffer logrotate lzo lzw mad menu-plugin midi mjpeg mmx mmxext mng motif mp2 mp3 mp4 mp4live mpeg mpeg2 nas ncurses net network nls nptl nptlonly nsplugin ntfs nvidia objc offensive ogg openal opengl pam parport pcap pcre pda pdf pdflib perl png postgres postscript ppds python qt3support qt4 quotas rar rdesktop readline reiserfs rtc ruby samba scanner sdl seamonkey serial server session slang slp smi sndfile sockets socks5 sound sox speex spell spl sqlite sqlite3 sse sse2 ssl svg svgz symlink sysfs syslog szip t1lib taglib tcl tcpd tetex tga theora threads tiff timidity tivo tk truetype truetype-fonts type1 type1-fonts udev uim unicode usb userlocales utils v4l v4l2 vcd vim vim-syntax vim-with-x vnc vorbis wifi wma wmf wmp x264 xanim xcb xforms xine xinerama xml xml2 xorg xscreensaver xv xvid xvmc yv12 zip zlib" ALSA_CARDS="hda-intel" ALSA_PCM_PLUGINS="adpcm alaw copy dshare dsnoop extplug file hooks ladspa lfloat linear meter mulaw multi null rate route share shm" APACHE2_MODULES="actions alias auth_basic authn_alias authn_anon authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache dav dav_fs dav_lock deflate dir disk_cache env expires ext_filter file_cache filter headers include info log_config logio mem_cache mime mime_magic negotiation rewrite setenvif speling status unique_id userdir usertrack vhost_alias" ELIBC="glibc" INPUT_DEVICES="joystick keyboard mouse" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LINGUAS="pt_BR en_US" USERLAND="GNU" VIDEO_CARDS="ati fglrx nv nvidia vesa fbdev"
Unset:  CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LDFLAGS, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS, PORTDIR_OVERLAY

[Comment 1 Andreas Proschofsky (RETIRED) 2008-04-15 11:11:50 UTC]

I quote the go-oo-mailing list:

"As we discussed in person at GoOOCon, this is an intended behavior in
line with what Excel does.  I had discussion with Eike about this, and
it's likely that the upstream will adopt this behavior for better
interoperability with Excel."

See this thread for more information:

http://lists.go-oo.org/pipermail/dev-go-oo.org/2008-April/000416.html

Closing in line with upstream policy