Package: gnumeric Version: 1.4.3-5 Severity: normal sumif doesn't work correcly when it refers the cell which is in other sheet.
For example, there are 2 sheets "sheet1" and "sheet2": | A B ---------------- 1 | book 3000 2 | food 1000 3 | misc 2000 [sheet1] | A ---------------- 1 | =sumif(sheet1!A1:A3, "book", sheet1!B1:B3) [sheet2] I think A1 on "sheet2" should be "3000", but sumif returns "#VALUE!". Thanks. -- System Information: Debian Release: 3.1 APT prefers testing APT policy: (500, 'testing'), (90, 'unstable') Architecture: i386 (i686) Kernel: Linux 2.6.10 Locale: LANG=ja_JP.eucJP, LC_CTYPE=ja_JP.eucJP (charmap=EUC-JP) Versions of packages gnumeric depends on: ii gconf2 2.8.1-5 GNOME configuration database syste ii gnumeric-common 1.4.3-5 common files for Gnumeric, the GNO ii gsfonts 8.14+v8.11+urw-0.2 Fonts for the Ghostscript interpre ii libart-2.0-2 2.3.17-1 Library of functions for 2D graphi ii libatk1.0-0 1.8.0-4 The ATK accessibility toolkit ii libbonobo2-0 2.8.1-2 Bonobo CORBA interfaces library ii libbonoboui2-0 2.8.1-2 The Bonobo UI library ii libc6 2.3.2.ds1-21 GNU C Library: Shared libraries an ii libgconf2-4 2.8.1-5 GNOME configuration database syste ii libglade2-0 1:2.4.2-2 library to load .glade files at ru ii libglib2.0-0 2.6.4-1 The GLib library of C routines ii libgnome2-0 2.8.1-2 The GNOME 2 library - runtime file ii libgnomecanvas2-0 2.8.0-1 A powerful object-oriented display ii libgnomeprint2.2-0 2.8.2-1 The GNOME 2.2 print architecture - ii libgnomeprintui2.2-0 2.8.2-2 GNOME 2.2 print architecture User ii libgnomeui-0 2.8.1-3 The GNOME 2 libraries (User Interf ii libgnomevfs2-0 2.8.4-2 The GNOME virtual file-system libr ii libgsf-1 1.11.1-1 Structured File Library - runtime ii libgsf-gnome-1 1.11.1-1 Structured File Library - runtime ii libgtk2.0-0 2.6.4-1 The GTK+ graphical user interface ii libice6 4.3.0.dfsg.1-12.0.1 Inter-Client Exchange library ii liborbit2 1:2.12.2-1 libraries for ORBit2 - a CORBA ORB ii libpango1.0-0 1.8.1-1 Layout and rendering of internatio ii libpopt0 1.7-5 lib for parsing cmdline parameters ii libsm6 4.3.0.dfsg.1-12.0.1 X Window System Session Management ii libxml2 2.6.16-7 GNOME XML library ii xlibs 4.3.0.dfsg.1-12 X Keyboard Extension (XKB) configu ii zlib1g 1:1.2.2-4 compression library - runtime -- no debconf information -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
