Ask Your Question

calc find returns incorrect results

asked 2017-12-19 09:13:05 +0200

TheCapnVideo gravatar image

I have a list of email addresses which I keep up to date. There are thousands, sorted alphabetically and by number. Since the list is proprietary I really cannot post a screen shot.

Very recently when I hit (CTRL+F) the find box opens and I insert a string to search in the list and the program returns incorrect data. For instance I search the word light and the program selects the following as matches; s_ght, dwight, wright, sleight, and bright.

Now obviously it is returning the ight but not the L. If I search just ight it returns iqht, a few addresses which do not resemble ight in any fashion,, mauri@yahoo.

I opened a different spreadsheet and the search seemed to work correctly but then I noticed the results were incorrect there also. I searched 'national' and it came up as a word but not in a web address; for instance www.firstnational,com was not found even though it was on the screen.

Also all fields are now blue and though they are not hyperlinks I am told to ctrl+click to follow the link. None of them should be clickable, underlined or blue.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-12-19 09:18:35 +0200

librebel gravatar image

updated 2017-12-19 09:19:34 +0200

Hello @TheCapnVideo,

Please try in the Find/Replace dialog (CTRL+H), click "Other Options", then uncheck "Similarity search". HTH, lib

edit flag offensive delete link more

answered 2017-12-21 01:12:34 +0200

TheCapnVideo gravatar image

Ok. When how why is it magically checked?

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-12-19 09:13:05 +0200

Seen: 39 times

Last updated: Dec 21 '17