Ask Your Question

find wildcards

asked 2018-07-10 03:10:16 +0200

jspreadsheet gravatar image

Find using wildcards reports "search not found" on two recent versions of Calc 6.X on my desktop.

Sent the exact same file via ftp to my laptop and the same search worked using Calc 5.X.

Double checked find options. Both systems use the Ubuntu 16.04 OS.

What am I missing here?

edit retag flag offensive close merge delete


It would help enormously to know what your search string was!

David gravatar imageDavid ( 2018-07-10 12:02:58 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2018-07-10 04:54:46 +0200

LibreOffice can use wildcards, or regular expressions, or none - depending on the settings in the Find & Replace dialog. These settings are hidden under the Other Options expanding group. So you need to make sure that you select the correct setting.

As you don't tell which search string are you using, and which text in a cell you are expecting to find, it's hard to tell if there is anything else to take into account. Note that for formulas, there's a setting under OptionsLibreOffice CalcCalculate, which tells if regular expressions or wildcards should be used in searches.

edit flag offensive delete link more

answered 2018-07-10 18:11:46 +0200

jspreadsheet gravatar image

The resolution was embarrassingly simple. I did not realize and overlooked that there was both a Wildcards box and a Regular Expressions box in later versions of Calc.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-07-10 03:10:16 +0200

Seen: 224 times

Last updated: Jul 10 '18