Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .