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?)