To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=51429 Issue #:|51429 Summary:|Search and replace w/o color changes cell color Component:|Spreadsheet Version:|OOo 2.0 Beta Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P4 Subcomponent:|formatting Assigned to:|spreadsheet Reported by:|filkin
------- Additional comments from [EMAIL PROTECTED] Thu Jun 30 13:35:21 -0700 2005 ------- 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. Cheers -- David --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
