Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I can't find any strings in the open office calc(version 3.2.1 in windows) document (*.xls) by doing a search(Ctrl+F).I tried with all options and then also i didn't get any positive result.

All suggestions are welcome!

share|improve this question
2  
please don't sign off each and every past with your (nick)name. Also, what're you searching for ? Examples ? Screenshots ? –  Sathya Jan 20 '11 at 13:25
    
Ok.thanks. In my xls, when i do a search for word "code" , it will not hit..even when the document contains 1000 times the word "code" –  Renjith G Jan 20 '11 at 13:32
    
Do you have formulas in your spreadsheet ? Have you checked the option to see if search is checking formulas too ? –  Sathya Jan 20 '11 at 15:32
    
yes. i have selected the "formulas" for search –  Renjith G Jan 21 '11 at 4:02

1 Answer 1

I had this problem in Open Office Calc(*.ods)(version 4.0.1). The result when searching for a string I could clearly see was always "Search key not found". Solved when I realised I had ticked "entire cells"in "Find & Replace" for a particular purpose, and then forgotten to untick it.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.