Issue 51429 - Search and replace w/o color changes cell color
Summary: Search and replace w/o color changes cell color
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.0 Beta
Hardware: All All
: P3 Trivial with 6 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa, rfe_eval_ok, usability
: 59887 85004 108964 (view as issue list)
Depends on:
Reported: 2005-06-30 21:35 UTC by david
Modified: 2013-08-07 15:12 UTC (History)
2 users (show)

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

Spreadsheet for repro og color replace bug. (9.00 KB, application/vnd.sun.xml.calc)
2005-07-08 15:12 UTC, david
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description david 2005-06-30 21:35:21 UTC
Please fix Calc so that it retains the color of replaced text in a 'Find and 
Replace' operation - or maybe even enhance the replacer making it possible to 
set the text color/format for the Find and Replace source and destination fields 
like in Writer.

Excell has this same frustrating bug so you could get a real advantage here 
merely by fixing the bug.

When you 'Find and Replace' in the spreadsheet it's currently not possible to 
set the color so that it changes the color of a certain word throughout the 
spreadsheet (only solution is to copy paste inti MS Word !! :( - as Writer 
allows it color/format _only_ on its non-Calc-imported text and Calc itself 
can't do it).

So when you somehow finally DO have, say, a 10.000 words Calc-manuscript with 
the words "MAIN CARACTAR" in a certain color and you realize you misspelled it 
and have to change it into "MAIN CHARACTER" you make a 'Find and Replace' on the 
string "MAIN CARACTAR" and replace it with "MAIN CHARACTER" - and since you 
CANNOT set the color you of course assume that Calc leaves the color as it is! - 
 But NO. It changes every replacement on that string into the wrong color - even 
the whole cell color. I really hope you can fix this.

-- David
Comment 1 frank 2005-07-08 14:57:15 UTC

could not reproduce using your description and OOo1.9.113 .

Please provide a document and a step by step description based on this file on
how to reproduce your Issue.

Comment 2 david 2005-07-08 15:12:22 UTC
Created attachment 27791 [details]
Spreadsheet for repro og color replace bug.
Comment 3 david 2005-07-08 15:14:31 UTC
I've created an attach now. Just open it in Calc and replace "buck" with "bug" 
and watch as all the text coloring is destroyed even on OTHER words than "buck" 
whereas it should have left the coloring alone.

The best fix would be to allow styling in both the Find and Replace fields like 
in Writer.

-- David
Comment 4 frank 2005-07-08 15:50:06 UTC

my first tries involved a single word in a cell, making the attribute set on the
cell property. Your example is to use a so called Edit cell. Such cells have the
attributes set on the string itself. So search and replace for non Edit cells work. 

As your file contains Edit cells and this isn't a defect (the search and replace
facility is designed in this way and is in this way compatible to Excel) this
Issue is a new Feature request and will be handled by the requirements team.

Comment 5 david 2005-07-08 16:36:46 UTC
A new feature - ok. Well both me and my colleagues clearly thought of this as an 
error in the program. I mean it didn't do what we "told" it. That's of course a 
non-programmer's view of such problems (most program problems actually). Any 
regular user will consider it an error. Being sort of of in-between myself, I'd 
call it a design flaw (like most other problems I've encountered with OOffice - 
and of course MS office). I'm glad you acknowledge it as something missing at 
least :) - hope it'll be looked into soon.

Generally user interfaces should of course let the user know if it - even by 
design - doesn't do as she/he would expect. If not, I consider it a user-
interface bug. I hope in the future I can somehow figure out which problems are 
"by design" and categorize them correctly when I report them.

Thanks for your answer.

(I can recommend Jef Raskin's small interface book The Humane Interface - it's 
available here online: )
Comment 6 lohmaier 2005-07-08 17:37:06 UTC
setting keywords.
Comment 7 frank 2006-02-01 13:19:58 UTC
*** Issue 59887 has been marked as a duplicate of this issue. ***
Comment 8 absolution 2008-02-10 10:33:31 UTC
I think there is at least one quite serious bug in this "feature". The lost of 
formatting (not just colors but italics and bolds) can't be undone. Only the 
replace operation is undone, but formatting remains lost for good.

I think that any issue where user data are lost is quite serious and should be 
treated with appropriate priority.
Comment 9 david 2008-02-10 15:11:32 UTC
If undo doesn't work I'll take the liberty of calling it a defect.

I mean the formatting getting lost for good (replace not working as any user 
will expect is perhaps still a "feature" but I hope you can fix both as a bug 

- David
Comment 10 amy2008 2008-09-25 07:30:32 UTC
*** Issue 85004 has been marked as a duplicate of this issue. ***
Comment 11 meywer 2010-02-05 11:42:30 UTC
Please have a look on issue 103342 too.
Comment 12 milek_pl 2010-02-05 17:42:01 UTC
*** Issue 108964 has been marked as a duplicate of this issue. ***