[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-bugs-dist
Subject:    Bug#42465: =if using a reference bugs
From:       zander () kde ! org
Date:       2002-05-11 8:23:48
[Download RAW message or body]

Package: kspread
Version: 1.2 Beta1 (using KDE 3.0.1 (CVS >= 20020327))
Severity: normal
Installed from:    compiled sources
Compiler:          gcc version 2.95.4 20011002 (Debian prerelease)
OS:                Linux (i686) release 2.4.17
OS/Compiler notes: 

If I put in b3 the query:
     =if(a3==3;3;5)
I ask if the contents of a3 equals '3'.

If the cell is empty (no text) I get an error; I would expect the else clause to be \
used as the rest of my sheet also goes into 'error' since they depend on this \
value...

If I insert a space (in a3) the above outputs 5.

(Submitted via bugs.kde.org)
(Called from KBugReport dialog)


[prev in list] [next in list] [prev in thread] [next in thread]