Search and Replace in Calc – LibreOffice 5.2
This page is in Work !
- 1 Foreword
- 2 Link to the Video
- 3 Search options
- 4 "Search" toolbar
- 5 Find a term
- 6 "Search and replace" dialog box
- 7 Search and replace
- 8 "Search and Replace" formulas
- 9 "Search and Replace" values
- 10 Comments "search and replace"
- 11 Find and Replace Cell Templates
- 12 "Search and Replace" with wildcard -regular expressions-
- 13 Further Informations
This page belongs to the video "Search and Replace in Calc" and shows how to search for text, formulas and formats in Calc.
This description refers to the version LibreOffice 5.2.
Link to the Video
Link to the Video (in German [DE]): Suchen und Ersetzen in Calc – LibreOffice 5.2
There are several ways to find specific information within a Calc Document, such as "Text", "Formulas" or "Formats".
Open Calc and use the "Search" Toolbar.
Or choose Edit from the menu, the Search and Replace dialog box will open.
By default, the Find toolbar is located at the bottom of the status bar.
You can hide or show the Find toolbar using▸ ▸ .
Find a term
In the Table search for a term.
Write a term you are looking for in the search field and then click on one of the symbols "Search next" -arrow down- or "Search previous" -arrow up-.
"Search and replace" dialog box
Alternatively, select the key combination Ctrl+Alt+F.
You can now navigate from one location to the next.
Or you can search with.
The locations where the search is conducted will be marked.
Search and replace
At the same time you have the possibility to replace found contents.
For "Search:" enter "Ost" and for "Replace:" enter "West".
You should only useif you are sure.
So the word "Kost" has also been changed to "Kwest".
"Search and Replace" formulas
With the dialog "Search and Replace" you can also search in formulas.
Click on "More options..." to expand the dialog.
Select "Formulas" from the drop-down list under "Search in:".
"Formulas" finds parts of the formulas -string or text.
In the Find: field, type Sum text.
"Sum" will be found in both the formulas and the caption.
"Search and Replace" values
With the "Find and Replace" dialog you can also search in cells with calculated values.
Select "Search in:" from the drop-down list, "Values" off.
"Values" finds values or text.
You type the value "3" in the "Search:" field.
A "3" is found in both the values and the caption.
Comments "search and replace"
Select "Comments" from the drop-down list under "Search in:".
Type "Plan" in the "Search:" field.
The "Plan Values" comment will be found.
Find and Replace Cell Templates
To replace one template with another, proceed as follows:
In the advanced "Find and Replace" dialog, place a check mark next to "Cell Templates".
The "Find:" and "Replace:" fields now each contain a drop-down list of templates.
Select the "Header Values" template for "Find:".
And for "Replace:" select "Heading2".
This changes the cells of the "Value Headings".
"Search and Replace" with wildcard -regular expressions-
Wildcards, also known as regular expressions, are combinations of characters.
Examples of wildcards are:
- period (.)
- question mark ('?)
- asterisk (*).
You can tell LibreOffice to search with them.
In the offline help for "List of regular expressions'" search, displays the list of all regular expressions.
Documentation / Manuals
For questions on this topic go to Ask.LibreOffice