Find & Find/Replace functions

SveinD · Newbie Joined: 28 May 2012 Posts: 4

For a long time now I have had the problem that the "Find" function will not work correctly. This problem is both in Text Doc and Spreadsheet. In Text it mostly returns nonsensical strings while in the spreadsheet it does not find the target.

I'm using Open Office 3.3.0 and Window 7 Home Premium w/Service pack 1.

Copying the spreadsheet to my MS Office free starter version the Find function works fine so I presume the cells are correctly configured.

Any suggestions would be welcome.

keme · Posted: Thu May 31, 2012 5:11 am Post subject:

Many issues related to find and replace are caused by enabling regular expressions without being aware of it. Click More options in the Find/replace dialog to expand the options, and see if Regular expressions is ticked. Untick and see if that helps.

Failing that, you have to tell us the specifics of "will not work correctly".
IOW, how does it work?
What did you search for, and what did you get?

SveinD · Newbie Joined: 28 May 2012 Posts: 4

Thanks Keme,

Ticking Regular expression actually solved my problem!!

Tusen takk.

MVH,

Svein[/quote]

rmkelly · Newbie Joined: 15 May 2012 Posts: 4 Location: USA

thank you for info about the "more options" dialogue.
my "find and replace" had inexplicably been searching backwards.
I went to the "more options" only to find that, sure enough, the box for "backwards" was checked!
holy cow, no wonder!
thanks for putting me back on a forward path!
_________________
"making the world safe for wallpaper"
a proud member of the Wallpaper History Group on LinkedIn