Your message dated Tue, 14 Jun 2005 17:17:38 -0400
with message-id <[EMAIL PROTECTED]>
and subject line Bug#308346: fixed in gnumeric 1.5.2-1
has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--------------------------------------
Received: (at submit) by bugs.debian.org; 9 May 2005 16:37:31 +0000
>From [EMAIL PROTECTED] Mon May 09 09:37:31 2005
Return-path: <[EMAIL PROTECTED]>
Received: from master.debian.org [146.82.138.7]
by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1DVBG6-0000NV-00; Mon, 09 May 2005 09:37:31 -0700
Received: from 218.53.87.61.ap.seikyou.ne.jp ([127.0.0.1]) [61.87.53.218]
by master.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1DVBG4-0006nX-00; Mon, 09 May 2005 11:37:29 -0500
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: [EMAIL PROTECTED]
To: Debian Bug Tracking System <[EMAIL PROTECTED]>
Subject: gnumeric: sumif doesn't work correctly
X-Mailer: reportbug 3.8
Date: Tue, 10 May 2005 01:37:22 +0900
X-Debbugs-Cc: [EMAIL PROTECTED]
Message-Id: <[EMAIL PROTECTED]>
Delivered-To: [EMAIL PROTECTED]
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-7.4 required=4.0 tests=BAYES_00,HAS_PACKAGE,
NO_REAL_NAME,OUR_MTA_MSGID,X_DEBBUGS_CC autolearn=no
version=2.60-bugs.debian.org_2005_01_02
X-Spam-Level:
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
---------------------------------------
Received: (at 308346-close) by bugs.debian.org; 14 Jun 2005 21:22:38 +0000
>From [EMAIL PROTECTED] Tue Jun 14 14:22:38 2005
Return-path: <[EMAIL PROTECTED]>
Received: from newraff.debian.org [208.185.25.31] (mail)
by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1DiIrm-0002rh-00; Tue, 14 Jun 2005 14:22:38 -0700
Received: from katie by newraff.debian.org with local (Exim 3.35 1 (Debian))
id 1DiImw-0007Ij-00; Tue, 14 Jun 2005 17:17:38 -0400
From: [EMAIL PROTECTED] (J.H.M. Dassen (Ray))
To: [EMAIL PROTECTED]
X-Katie: $Revision: 1.56 $
Subject: Bug#308346: fixed in gnumeric 1.5.2-1
Message-Id: <[EMAIL PROTECTED]>
Sender: Archive Administrator <[EMAIL PROTECTED]>
Date: Tue, 14 Jun 2005 17:17:38 -0400
Delivered-To: [EMAIL PROTECTED]
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-6.0 required=4.0 tests=BAYES_00,HAS_BUG_NUMBER
autolearn=no version=2.60-bugs.debian.org_2005_01_02
X-Spam-Level:
Source: gnumeric
Source-Version: 1.5.2-1
We believe that the bug you reported is fixed in the latest version of
gnumeric, which is due to be installed in the Debian FTP archive:
gnumeric-common_1.5.2-1_all.deb
to pool/main/g/gnumeric/gnumeric-common_1.5.2-1_all.deb
gnumeric-doc_1.5.2-1_all.deb
to pool/main/g/gnumeric/gnumeric-doc_1.5.2-1_all.deb
gnumeric-plugins-extra_1.5.2-1_i386.deb
to pool/main/g/gnumeric/gnumeric-plugins-extra_1.5.2-1_i386.deb
gnumeric_1.5.2-1.diff.gz
to pool/main/g/gnumeric/gnumeric_1.5.2-1.diff.gz
gnumeric_1.5.2-1.dsc
to pool/main/g/gnumeric/gnumeric_1.5.2-1.dsc
gnumeric_1.5.2-1_i386.deb
to pool/main/g/gnumeric/gnumeric_1.5.2-1_i386.deb
gnumeric_1.5.2.orig.tar.gz
to pool/main/g/gnumeric/gnumeric_1.5.2.orig.tar.gz
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to [EMAIL PROTECTED],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
J.H.M. Dassen (Ray) <[EMAIL PROTECTED]> (supplier of updated gnumeric package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing [EMAIL PROTECTED])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Format: 1.7
Date: Tue, 14 Jun 2005 22:38:59 +0200
Source: gnumeric
Binary: gnumeric-doc gnumeric-common gnumeric gnumeric-plugins-extra
Architecture: source i386 all
Version: 1.5.2-1
Distribution: unstable
Urgency: low
Maintainer: J.H.M. Dassen (Ray) <[EMAIL PROTECTED]>
Changed-By: J.H.M. Dassen (Ray) <[EMAIL PROTECTED]>
Description:
gnumeric - GNOME spreadsheet application
gnumeric-common - common files for Gnumeric, the GNOME spreadsheet application
gnumeric-doc - documentation for Gnumeric, the GNOME spreadsheet application
gnumeric-plugins-extra - additional plugins for the GNOME spreadsheet
Closes: 308346 310832 311534
Changes:
gnumeric (1.5.2-1) unstable; urgency=low
.
* New upstream release.
* Fixed upstream:
* sumif behaviour with intersheet references. (Closes: #308346)
* Brown bag text import problem. (Closes: #310832)
* [debian/control] Bumped goffice and libgsf build dependencies
per configure.in.
* [debian/rules, debian/gnumeric.install] Install libspreadsheet runtime
files. Libspreadsheet is not a fully rounded separate library at this
point and the gnumeric binary package contains the only binaries
currently using it, so there is no need yet for it to be in a separate
package. This may well change in the future.
* [debian/rules, debian/gnumeric.install] Build and include ssindex.
(Closes: #311534)
Files:
a6128825ffc20491a85d47859667aad6 1320 math optional gnumeric_1.5.2-1.dsc
9ae59b08f96e7c57772ee1fd5dd4954f 15888575 math optional
gnumeric_1.5.2.orig.tar.gz
bfd023226ce372ce6dd38e501a952e14 31529 math optional gnumeric_1.5.2-1.diff.gz
14d60cdac8b336fe0d805667b80206cd 2888996 math optional
gnumeric-common_1.5.2-1_all.deb
8280d9c76c90b1459b32c4d805e7a19f 4172056 doc optional
gnumeric-doc_1.5.2-1_all.deb
e0fbb6f509171c8b5167601416a705e9 2149178 math optional
gnumeric_1.5.2-1_i386.deb
6f978040bbe4b5819765a78acf5cc47a 147484 math optional
gnumeric-plugins-extra_1.5.2-1_i386.deb
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
iD8DBQFCr0SrA+HB2Re6Rc4RAuA1AJ99pUypB9uNTzcbpRx1VGHs8vnz1QCghjhy
MP5AjPdEeVODfLJGxWGPd9w=
=pT1c
-----END PGP SIGNATURE-----
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
