Issue 108642 - Cell selection/highlighting broken after Search/Replace on multiple sheets
Summary: Cell selection/highlighting broken after Search/Replace on multiple sheets
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOO320m10
Hardware: Unknown All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2010-01-25 10:30 UTC by Andrea Pescetti
Modified: 2014-08-06 14:36 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.1.0
Developer Difficulty: ---

Sample document (7.79 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-01-25 10:51 UTC, Andrea Pescetti
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Andrea Pescetti 2010-01-25 10:30:17 UTC
1. Create a new Calc Document, with two sheets named "1" and "2". In sheet 1,
write "test1" in A1 and "test2" in A2. In sheet 2, write "test1" in B2. I'll
attach a sample document shortly.
2. Go to sheet 1.
3. Edit - Find and Replace - Search for "test1" replace with "replaced", check
"Search in all sheets" in the Extra Options.

Expected: the replaced cells are selected/highlighted after replacements.

Actual: the highlighting is shown on sheet 1 but with the references from sheet
2: i.e., in sheet 1 the (empty) cell B2 is highlighted, but B2 was replaced in

This can lead to confusion when operating on multiple sheets.

[Found during Italian QA tests]
Comment 1 Andrea Pescetti 2010-01-25 10:51:59 UTC
Created attachment 67394 [details]
Sample document
Comment 2 Joe Smith 2014-08-06 13:43:38 UTC
Seems this issue can be closed: current versions do not highlight anything when "Search on all sheets" is active.

I wouldn't say the problem is fixed, just avoided. The current behavior is inconsistent: the matches are usually highlighted and the user may expect that behavior; seeing no highlights may be confusing.
Comment 3 mroe 2014-08-06 14:08:03 UTC
The problem exists always in AOO 4.1.1 RC1, Linux64 as described in the sample document.
Comment 4 Joe Smith 2014-08-06 14:36:50 UTC
Hmm, ok. I don't see it following the steps with my document but I do still see it I use the test document attached here.

So there is still some problem; I don't know why it should work differently for mine.