Ask Your Question

How to see found hidden cells in calc [closed]

asked 2014-10-16 02:10:15 +0200

jeremygharrison gravatar image

updated 2016-03-05 09:30:00 +0200

Alex Kemp gravatar image

If in a calc spreadsheet I have some hidden rows (or columns), and I do Edit > Find (or Ctrl+F) to 'find' (or 'find all') something, which is in the hidden area, how can I see the cell I have found (in context)? (If I do 'find all' I get a 'Search Results' box showing the found cells (only - not what I want)

What I am wanting (if not expecting) is for the hidden row/column containing the found cells to be shown.

Is there a command or option to achieve this?

(I have a feeling that it used to do so - I am now on LO 4.2.6, so have i found a bug?)

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 2016-03-05 09:30:09.498179

2 Answers

Sort by » oldest newest most voted

answered 2014-10-17 09:41:23 +0200

ROSt52 gravatar image

Did you find a bug or is it an enhancement request depends on the specifications used to program the search function.

I made a test using LibO running on XP.

When a cell content is searched for and is in an hidden cell, there are 2 ways to see where the hidden cell(s) is: - when using FIND the cursor jumps to the line behind which are the hidden columns or rows located - when using FIND ALL a pop up windows shows the coordinates of all the hidden cells

If you have a request beyond this functionality, please feel free to place an enhancement request here:

edit flag offensive delete link more

answered 2014-10-18 16:37:38 +0200

jeremygharrison gravatar image

Thanks. Yes, that is the behaviour as I see it (but not as I want it)

I have raised Bug 85175 as advised

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-10-16 02:10:15 +0200

Seen: 432 times

Last updated: Oct 18 '14