Calc 4.1.5 - Find and Reolace Not Working

[bsfinkel]

I recently upgraded to OO 4.1.5 on my Windows 7 Professional 32-bit system. In Calc, the cntl-F "Find & Replace" is not working. It does not find the string in the spreadsheet. Placing a search string in the "Find" box also does not work. I normally use cntl-F instead of the "Find" box; I have no idea what the difference is. But neither works in Calc 4.1.5. Thanks.

--Barry Finkel

[acknak]

Seems to work fine here.

It might help if you can tell us what text is entered in the "Search for" box.

Unless you need to search for patterns (a wildcard like *, for example), you probably want to make sure Edit > Find & Replace > More Options > Regular expressions is OFF. In fact, I would start out by making sure ALL the options there are OFF.

[bsfinkel]

I am not using wildcard characters. I search for

member

and nothing is found. The spreadsheet has LOTS of occurrences of that word. I do not know if there are any options that control "Find and replace", so I do not know if the upgrade from 4.1.4 to 4.1.5 changed any of the settings I had (either by default or by my manual change). The "Match case" is unchecked,and "Entire cells" is checked, I just unchecked "Entire cell", and the search worked.

[RoryOF]

Searching for "member" with Entire cell unchecked will find any sell which contains "member" in any form (e.g, "member", "members, "member of"). With Entire cell checked "member" must be the only content of the cell.

[Alex1]

If "member" is the result of a formula, you should search in values instead of formulas under More Options.