I a using OOo files with the BDNB funtion for some years now. Actually, I need them once a year. Last year, the files gave "normal" results, but this year, the same exact files give wrong result. The same files on another computer (Running 32 bit testing Debian) does show normal results ! Reproducible: Always Steps to Reproduce: 1.Open a file using BDNB funtion on my computer 2. 3. Actual Results: The data count is wrong Expected Results: The data count to be right, just as on any other computer A B C D 1 question1 question2 question3 2 answer1 oui 3 answer2 oui un 4 answer3 non deux 5 answer4 trois 6 answer5 un bleu 7 answer6 deux blanc 8 answer7 un rouge 9 answer8 bleu 10 answer9 blanc 11 answer10 bleu 12 13 14 question1 15 oui 16 BDNB result 5 Function is : BDNB(A1:D11;0;B14:B15) 17 Expected result : 2 If needed I can try to post the file somewhere. Here is some info on my system emerge --info Portage 2.1.8.3 (default/linux/amd64/10.0/desktop/gnome, gcc-4.4.3, glibc-2.11.2-r0, 2.6.33-gentoo-r2 x86_64) ================================================================= System uname: Linux-2.6.33-gentoo-r2-x86_64-Intel-R-_Core-TM-2_CPU_6300_@_1.86GHz-with-gentoo-1.12.13 Timestamp of tree: Tue, 31 Aug 2010 19:45:02 +0000 app-shells/bash: 4.0_p37 dev-java/java-config: 2.1.11 dev-lang/python: 2.6.5-r3, 3.1.2-r4 dev-util/cmake: 2.8.1-r2 sys-apps/baselayout: 1.12.13 sys-apps/sandbox: 1.6-r2 sys-devel/autoconf: 2.13, 2.65 sys-devel/automake: 1.7.9-r2, 1.9.6-r3, 1.10.3, 1.11.1 sys-devel/binutils: 2.20.1-r1 sys-devel/gcc: 4.3.4, 4.4.3-r2 sys-devel/gcc-config: 1.4.1 sys-devel/libtool: 2.2.6b sys-devel/make: 3.81-r2 virtual/os-headers: 2.6.30-r1 ACCEPT_KEYWORDS="amd64" ACCEPT_LICENSE="* -@EULA dlj-1.1" CBUILD="x86_64-pc-linux-gnu" CFLAGS="-march=native -O2 -pipe" CHOST="x86_64-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/share/X11/xkb /usr/share/config /var/lib/hsqldb" CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/env.d/java/ /etc/fonts/fonts.conf /etc/gconf /etc/revdep-rebuild /etc/sandbox.d /etc/splash /etc/terminfo" CXXFLAGS="-march=native -O2 -pipe" DISTDIR="/usr/portage/distfiles" FEATURES="assume-digests distlocks fixpackages news parallel-fetch protect-owned sandbox sfperms strict unmerge-logs unmerge-orphans userfetch" GENTOO_MIRRORS="http://ftp.heanet.ie/pub/gentoo/ http://ftp.uni-erlangen.de/pub/mirrors/gentoo http://gentoo.ynet.sk/pub" LANG="fr_FR.UTF-8" LDFLAGS="-Wl,-O1 -Wl,--as-needed" LINGUAS="fr" MAKEOPTS="-j3" PKGDIR="/usr/portage/packages" PORTAGE_CONFIGROOT="/" 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" PORTDIR_OVERLAY="/var/lib/layman/lordvan" SYNC="rsync://rsync.europe.gentoo.org/gentoo-portage" USE="X a52 aac acl acpi alsa amd64 avahi avi berkdb bluetooth branding bzip2 cairo cdr cli consolekit cracklib crypt cups cxx dbus device-mapper divx divx4linux dri dts dvb dvd dvdr eds emboss encode evo exif extras fam ffmpeg ffmpeg-mt firefox flac foomaticdb fortran gdbm gdu gif gimpprint glitz gmedia gnome gnome-keyring gpm gstreamer gtk gtk2 hal iconv imagemagick imlib ipv6 java jbig jpeg jpeg2k lcms ldap libnotify mad matroska mikmod mmx mmxext mng modules mp3 mp4 mpeg mudflap multilib nautilus ncurses new-login nls nowin nptl nptlonly nsplugin nvidia ogg opengl openmp pam pango pcre pdf pdflib perl pic png policykit ppds pppd pps print python qt3support quicktime readline realmedia reflection scanner sdl session smp spell spl sse sse2 ssl ssse3 startup-notification svg sysfs tcl tcpd theora threads tiff tk truetype trutype unicode usb v4l v4l2 vorbis wmf wmp x264 xcb xinerama xml xmms xorg xpm xulrunner xv xvid xvmc zlib" ALSA_CARDS="ali5451 als4000 atiixp atiixp-modem bt87x ca0106 cmipci emu10k1x ens1370 ens1371 es1938 es1968 fm801 hda-intel intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem ymfpci" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mmap_emul mulaw multi null plug rate route share shm softvol" 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 cgi cgid 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="evdev" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LINGUAS="fr" RUBY_TARGETS="ruby18" USERLAND="GNU" VIDEO_CARDS="nvidia" XTABLES_ADDONS="quota2 psd pknock lscan length2 ipv4options ipset ipp2p iface geoip fuzzy condition tee tarpit sysrq steal rawnat logmark ipmark dhcpmac delude chaos account" Unset: CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, FFLAGS, INSTALL_MASK, LC_ALL, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS
Created attachment 245879 [details] sample file that show the bug
Could you paste the result of 'emerge -pv app-office/openoffice' or 'emerge -pv app-office/openoffice-bin' whichever you're using?
# emerge -pv app-office/openoffice These are the packages that would be merged, in order: Calculating dependencies... done! [ebuild R ] app-office/openoffice-3.2.0 USE="cups dbus eds gnome gstreamer gtk java ldap nsplugin opengl pam (-aqua) -bash-completion -binfilter -debug -kde (-kdeenablefinal) -mono -odk -templates" LINGUAS="fr -af -ar -as_IN -be_BY -bg -bn -br -brx -bs -ca -cs -cy -da -de -dgo -dz -el -en -en_GB -en_US -en_ZA -eo -es -et -eu -fa -fi -ga -gl -gu -he -hi_IN -hr -hu -id -it -ja -ka -kk -km -kn_IN -ko -kok -ks -ku -lt -mai -mk -ml_IN -mn -mni -mr_IN -nb -ne -nl -nn -nr -ns -oc -or_IN -pa_IN -pl -pt -pt_BR -ru -rw -sa_IN -sat -sd -sh -sk -sl -sr -ss -st -sv -sw_TZ -ta -ta_IN -te_IN -tg -th -ti_ER -tn -tr -ts -uk -ur_IN -uz -ve -vi -xh -zh_CN -zh_TW -zu" 0 kB Total: 1 package (1 reinstall), Size of downloads: 0 kB
Could you please try out openoffice-3.2.1 (or openoffice-bin) and see if that changes anything?
openoffice-3.2.1 seems to solve the problem. Thank you for the suggestion. I hope It is not too instable to work with everyday.
(In reply to comment #5) > openoffice-3.2.1 seems to solve the problem. > > Thank you for the suggestion. > I hope It is not too instable to work with everyday. > No, OOo 3.2.1 should be at least as stable as 3.2.0 ;-) Closing, 3.2.0 will be removed from the tree soon anyway...