To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=98798 Issue #|98798 Summary|Replace added ")" Component|Spreadsheet Version|1.0.0 Platform|Unknown URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|tesaje
------- Additional comments from [email protected] Tue Feb 3 15:46:41 +0000 2009 ------- Version 3.01 (not in the selection box) I performed a find and replace command but Calc repeatedly added a ) (close parenthesis)to the string that was in the replace box: Ctrl-F to get find/replace box Find: trw Replace: "trw" Press replace button Result: "trw") Since I was fixing an incorrectly imported formula from an Excel spreadsheet, this made a mess of the formulae: =countif(range,trw) was turned into =countif(range,"trw")) which of course is an invalid formula. Replace should only replace what is in the replace box and not arbitrarily add characters. --------------------------------------------------------------------- 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]
