OpenOffice 2.2.1 Calc SEARCH() function bug
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?
Software/Hardware used:
Software/Hardware used:
ASKED:
December 12, 2008 10:18 PM
UPDATED:
February 25, 2011 9:54 AM
Answer Wiki:
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
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
