OpenOffice 2.2.1 Calc SEARCH() function bug

Tags:
Calc SEARCH ()
OpenOffice
I believe I understand how OpenOffice Calc's SEARCH() function works, but, =SEARCH(";";M2) always results in #VALUE!, even if cell M2 contains the text "Some;Text". This would seem to be a bug in OpenOffice 2.2.1. Is it corrected in more recent releases of OOo?
ASKED: December 12, 2008  10:18 PM
UPDATED: February 25, 2011  9:54 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

No, this is not a bug in Open Office 2.2.1. Ur input method was wrong ! The search function syntax like that,
SEARCH(“FindText”; “Text”; Position), where FindText is the text to be searched for, Text is the text where the search will take place and Position is the position in the text where the search is to start (hopefully it is optional).
Ur search criteria is =SEARCH(“;”;M2), I did not understand what the use for two “;”;…. the actual syntax is above. Suppose, there is a value on M2 cell say (a or A) then actual syntax is: =SEARCH(“a”;M2), remember, it is not case sensitive. I have tested and works fine in the same version.
For more information, see the Error Codes in Open Office – Calc

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following