[Upstream] [hardy] IF function can't be done without Quotation marks
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenOffice |
Invalid
|
Undecided
|
Unassigned | ||
libreoffice (Ubuntu) |
Invalid
|
Undecided
|
Unassigned | ||
openoffice.org (Ubuntu) |
Invalid
|
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 .
description: | updated |
Changed in openoffice.org: | |
importance: | Undecided → Low |
status: | New → Confirmed |
Changed in openoffice: | |
importance: | Undecided → Unknown |
status: | New → Unknown |
Changed in openoffice: | |
status: | Unknown → New |
Changed in openoffice.org: | |
status: | Confirmed → Triaged |
tags: | added: hardy |
Najmudin, regarding the IF function, quotes are required in Excel for your example as per: office. microsoft. com/en- us/excel- help/if- HP005209118. aspx
http://
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.