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 -- To UNSUBSCRIBE, email to [email protected] with a subject of "unsubscribe". Trouble? Contact [email protected]
