Your message dated Tue, 4 Jun 2013 00:01:05 +1000
with message-id <[email protected]>
and subject line Done: gnumeric: Some functions not working anymore
has caused the Debian Bug report #516645,
regarding gnumeric: Some functions not working anymore
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 this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
516645: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=516645
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: gnumeric
Version: 1.8.3-5+lenny1
Severity: normal
The following formula used to calculate a more or less arbitrary number which
gave me a
hint which students of mine I had neglected (i.e. not graded) for a while. I
enter my
grades in columns for every student (= row) with the latest being on the left
(i.e. I
create a new column so that the older ones move to the right).
=if(Total!$A12="","",round((15.5-D12)*(match(FALSE,if(G12:DP12=""),0)-0.5)))
At the heart of the formula is MATCH, which I need to find out how many columns
are blank
in a given row before the last grade can be found, i.e. for how many lessons I
have failed
to grade this student.
Note that the formula depends on IF returning a range if used on a range. The
resulting
range of FALSE and TRUE is then searched using MATCH. A simpler way would be
this similar
formula:
=match(FALSE,isblank(H14:R14),0)
Now, with the upgrade from Debian Etch to Lenny, both of these formulae only
return #N/A.
-- System Information:
Debian Release: 5.0
APT prefers stable
APT policy: (500, 'stable')
Architecture: i386 (i686)
Kernel: Linux 2.6.24.4 (SMP w/1 CPU core; PREEMPT)
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Shell: /bin/sh linked to /bin/bash
Versions of packages gnumeric depends on:
ii debconf [debc 1.5.24 Debian configuration management sy
ii gconf2 2.22.0-1 GNOME configuration database syste
ii gnumeric-comm 1.8.3-5+lenny1 spreadsheet application for GNOME
ii gsfonts 1:8.11+urwcyr1.0.7~pre44-3 Fonts for the Ghostscript interpre
ii libatk1.0-0 1.22.0-1 The ATK accessibility toolkit
ii libbonobo2-0 2.22.0-1 Bonobo CORBA interfaces library
ii libbonoboui2- 2.22.0-1 The Bonobo UI library
ii libc6 2.7-18 GNU C Library: Shared libraries
ii libcairo2 1.6.4-7 The Cairo 2D vector graphics libra
ii libgconf2-4 2.22.0-1 GNOME configuration database syste
ii libglade2-0 1:2.6.2-1 library to load .glade files at ru
ii libglib2.0-0 2.16.6-1 The GLib library of C routines
ii libgnome2-0 2.20.1.1-1 The GNOME 2 library - runtime file
ii libgnomeui-0 2.20.1.1-2 The GNOME 2 libraries (User Interf
ii libgnomevfs2- 1:2.22.0-5 GNOME Virtual File System (runtime
ii libgoffice-0- 0.6.3-1 Document centric objects library -
ii libgsf-1-114 1.14.8-1lenny2 Structured File Library - runtime
ii libgtk2.0-0 2.12.11-4 The GTK+ graphical user interface
ii libpango1.0-0 1.20.5-3 Layout and rendering of internatio
ii libxml2 2.6.32.dfsg-5 GNOME XML library
ii procps 1:3.2.7-11 /proc file system utilities
ii zlib1g 1:1.2.3.3.dfsg-12 compression library - runtime
Versions of packages gnumeric recommends:
ii evince 2.22.2-4~lenny1 Document (postscript, pdf) viewer
Versions of packages gnumeric suggests:
pn epiphany-browser <none> (no description available)
ii gnumeric-doc 1.8.3-5+lenny1 spreadsheet application for GNOME
ii gnumeric-plugins-extra 1.8.3-5+lenny1 spreadsheet application for GNOME
ii ttf-liberation 1.04.93-1 Free fonts with the same metrics a
-- debconf-show failed
--- End Message ---
--- Begin Message ---
Upstream developer commented: "To make your formulas work you just
have to enter them as array functions. (ctrl-shift-enter)".
For maintainer there is nothing left to do so I'm closing this bug
that was reported against pre-oldstable version of gnumeric.
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.
--- End Message ---
