Ask Your Question

Search highlighted section in calc? [closed]

asked 2017-09-17 05:00:10 +0200

appreciatethehelp gravatar image

updated 2020-08-02 12:03:15 +0200

Alex Kemp gravatar image

Hello. I would like to be able to search a specified section of a spreadsheet in calc, however when I highlight the section, enter the word/number I am searching for in the search bar, then hit enter, the search ignores the part I have selected and simply shows me the first instance of that word/number (from left to right/top to bottom, like reading a book).

How can I get around this? Thanks.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by appreciatethehelp
close date 2017-09-17 11:05:38.589119

1 Answer

Sort by » oldest newest most voted

answered 2017-09-17 05:56:19 +0200

librebel gravatar image

Hello @appreciatethehelp,

instead of selecting "Edit : Find..." ( CTRL+F ) and typing your search term into the Search Bar,

  1. select the menu "Edit : Find & Replace..." ( CTRL+H);
  2. in the dialog that pops up, enter your search term into the "Find" field;
  3. Click on the small arrow next to "Other Options";
  4. Check the checkbox "Current selection only";
  5. in the dropdown listbox called "Search in:", select the item "Values";
  6. Then click on the "Find All" button.
edit flag offensive delete link more


Thank you kindly!

appreciatethehelp gravatar imageappreciatethehelp ( 2017-09-17 11:05:19 +0200 )edit

Thanks! Very useful to search a value in a specific column only (by clicking on the column name), which is more performant than searching on all columns and prevents useless processing. However that's clearly not the best user experience on LibreOffice, having to use "Find & Replace" function if we just want to find and not replace... The feature should be added to the main find function too.

baptx gravatar imagebaptx ( 2019-10-15 10:36:49 +0200 )edit

TIP: I re-assigned Ctrl+F key to "Find & Replace".

pros: I get now a real dialog, comfortable, usable* , full blown dialog, with the "current selection" remembered. the bottom-bar is a mishap, invisible, can regain focus with Alt-Tab.

cons: dangerous. a user can accidentally replace the selection with <emtpy> string.

Berry gravatar imageBerry ( 2020-01-04 10:36:00 +0200 )edit

Question Tools



Asked: 2017-09-17 05:00:10 +0200

Seen: 3,003 times

Last updated: Sep 17 '17