GNOME Bugzilla – Bug 442941
Formula guru should auto-quote arguments that fail to parse
Last modified: 2009-12-29 07:23:13 UTC
When i try to work with the (IF) function in gnumeric , i cant change the ( true,false) in the Formula guru to other words as i like for example: (pass,fail,high,low,good,bad .....etc ). In Microsoft Excel you can put any word you want instead of true,false and it will exept it , but here you can't do that , if you write another word it will give you this result ( #NAME? ). Im not shure if that is a bug or just i dont know how to use it or i should use another function for that. I hope some one can help with that.
Can you give use a sample file with that usage ? or a detailed example of what to enter.
Created attachment 89191 [details] A sample of the problem can be downloaded from this link: http://www.mediafire.com/?cm2qbzbvt6v I attached a file containing the problem , i hope it will be clear for you.
I'm sorry here is the link to download the file : http://www.mediafire.com/?cm2qbzbvt6v
You probably want to enter "pass" with the quotation marks rather than just pass without quotation marks. Excel assumes that if a name is undefined you may mean the literal string.
(In reply to comment #4) > You probably want to enter "pass" with the quotation marks rather than just > pass without quotation marks. Excel assumes that if a name is undefined you may > mean the literal string. > No sir , i want to enter 'pass' without the quotation marks, i did not understand exactly what you mean (not so good in English) but what i just want to do is to change the word 'True' to be 'pass' , thats all what i want to do not more. I'll be thankful if you can give me a simple way on how to do that or send me the solution on the same file attached to this report so i can learn from.
Entering this on the command line in XL it generates '#NAME?' Entering it in the function dialog adds the necessary quotes.
Its ok now this report should be closed.
This seems like a reasonable enhancement, we'll leave it open.
Jody: there are some problems with that enhancement. Suppose I use the formula guru to enter =sum(current, previous) and see that I get value, I may remember that I haven't defined the "previous" cell yet. So I go to define names, perform that definition and the entered formula is correct. If the enhancement is implemented, then first of all I do not get any error indication, so my sum will miss the previous amount. Moreover, if I define the previous cell (perhaps I noticed that the calculation was wrong) my formula still remains incorrect. Under these circumstances I do not see any benefit of the formula guru adding quotation marks.
This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report.