[sc-issues] [Issue 98798] Replace added ")"
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=98798 --- Additional comments from j...@openoffice.org Sat Jun 13 22:11:42 + 2009 --- *** Issue 98799 has been marked as a duplicate of this issue. *** - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 98798] Replace added ")"
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=98798 User ja changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from j...@openoffice.org Sat Jun 13 22:09:18 + 2009 --- . - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 98798] Replace added ")"
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=98798 User ja changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |WORKSFORME --- Additional comments from j...@openoffice.org Sat Jun 13 22:08:53 + 2009 --- =countif(range,trw) cannot work. =countif(a1:a10;"trw") the string "trw" is used as search string for the range a1:a10 =countif(a1:a10;b1) the cell b1 contains the search string for the range a1:a10 if b1 contains trw then the formula gives 1 - 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 98798] Replace added ")"
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 tes...@openoffice.org Tue Feb 3 15:46:41 + 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org