[Upstream] [hardy] IF function can't be done without Quotation marks

Bug #152087 reported by Najmudin on 2007-10-12
4
Affects Status Importance Assigned to Milestone
OpenOffice
Invalid
Undecided
Unassigned
libreoffice (Ubuntu)
Undecided
Unassigned
openoffice.org (Ubuntu)
Undecided
Unassigned

Bug Description

Binary package hint: openoffice.org-calc

actually this is not a bug , but an important enhancement as i think.
When i try to use the IF function with words for example :
Pass - Fail instead of numbers , you have to do that using the Quotation marks every time with each word it will be like that:
Then_value : "Pass"
Otherwise_value : "Fail"
if you did not put the Quotation marks you will get an error .
When you try to do the same operation in MS Excel there is no need to put the Quotation marks , just write any word you want
and it will give you the correct result.
I think its not good to make complicated like that it should be easier for the user especially those who left MS Office to Open Office.
the solution is to ( auto quot ) the value or word inside the text box instead of doing that manually by the user.
Thats all , and thanks for your efforts people .

Revision history for this message
Najmudin (hussain-hammady-gmail) wrote : Re: IF function can't be done without Quotation marks
description: updated
Chris Cheney (ccheney) on 2008-03-12
Changed in openoffice.org:
importance: Undecided → Low
status: New → Confirmed
Chris Cheney (ccheney) on 2008-03-17
Changed in openoffice:
importance: Undecided → Unknown
status: New → Unknown
Changed in openoffice:
status: Unknown → New
Chris Cheney (ccheney) on 2008-06-13
Changed in openoffice.org:
status: Confirmed → Triaged
Chris Cheney (ccheney) on 2010-05-13
tags: added: hardy
Revision history for this message
Christopher M. Peñalver (penalvch) wrote :

Najmudin, regarding the IF function, quotes are required in Excel for your example as per:
http://office.microsoft.com/en-us/excel-help/if-HP005209118.aspx

OOo and LO keep compatibility with Excel by also requiring this. Hence, this is not a bug. Thank you for reporting this and feel free to report any future bugs you may find.

Changed in openoffice.org (Ubuntu):
importance: Low → Undecided
status: Triaged → Invalid
Changed in libreoffice (Ubuntu):
status: New → Invalid
Changed in openoffice:
importance: Unknown → Undecided
status: New → Invalid
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.