Ask Your Question

find wildcards [closed]

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

jspreadsheet gravatar image

updated 2020-07-23 20:31:53 +0200

Alex Kemp 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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-07-23 20:31:59.184504


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

Question Tools

1 follower


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

Seen: 789 times

Last updated: Jul 10 '18