Morten Welinder quickly and keenly noticed that my problematic zero data cell had a leading single quote.
That's important because it caused the if() function to mistakenly treat the zero as text. I think gnumeric automatically added it when I reformatted the data cell from text to number, which is what I told him. I'll trust Morten to decide what, if anything, should be done about silent quoting. It's OK with me to close this bug report. Thanks, Kingsley On 09/02/12 22:00, Debian Bug Tracking System wrote: > Thank you for filing a new Bug report with Debian. > > This is an automatically generated reply to let you know your message > has been received. > > Your message is being forwarded to the package maintainers and other > interested parties for their attention; they will reply in due course. > > Your message has been sent to the package maintainer(s): > J.H.M. Dassen (Ray) <jdas...@debian.org> > > If you wish to submit further information on this problem, please > send it to 686...@bugs.debian.org. > > Please do not send mail to ow...@bugs.debian.org unless you wish > to report a problem with the Bug-tracking system. > > -- > 686534: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=686534 > Debian Bug Tracking System > Contact ow...@bugs.debian.org with problems -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
