For some reason I am having trouble searching in calc. I will search for a particular keyword and it will pick cells that don’t seem to have anything to do with said keyword (and may or may not eventually find the correct cell). I tried updating Libreoffice (turns out I was a few versions behind) and even saving the spreadsheet in another format (xlsx and even csv, which removed my plots), but the results are still the same. It’s using some kind of logic–it matches the same cells every time to the keyword–but I can’t for the life of me figure out why it picks the cells it does or why it often ignores the correct answer entirely.
The spreadsheet has grown over time. I’m not sure when exactly the problem started. Perhaps it is because I upgraded to windows 10?
I appreciate your help!
Update with more details:
I’m using version 18.104.22.168.
I’m using the find tool bar that shows up at the bottom when you type Ctrl+f.
For example, if I search the word: help
It will find several correct cells with the word help such as a cell containing: The Help
But it also says picks some other cells, like the ones following:
Half of a Yellow Sun
Another example, if I search: queen
I get the correct result:
Elizabeth the Queen