To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107619
------- Additional comments from [email protected] Tue May 4 01:07:42 +0000 2010 ------- I can confirm both bugs on OOO320m12. I try to replace all the occurences of apostrophed numbers (formatted like, say, "'123,456") to the number itself (to include it into the calculation). By the way, it would be nice to be able to do it directly. But however, I found that it's impossible to search for the apostrophe (the search doesn't find anything). But if I search for the text without the apostrophe and replace it with the same text the apostrophe disappears - so that's what I need. I use the regex: ^([:digit:]*)(,?)([:digit:]*)$ . If I replace it with $1$2$3, than if the number consist of odd number of digits without decimal comma, it's replaced with itself triple times repeated (so '123 becomes 123123123). If the number contains the decimal comma, or if it has even number of digits, everything is ok. Seems like if the found text consists of odd number of characters, and some references are empty, they contain the last non-empty reference. I disagree that the first reported case is not a bug. The replacement should be done letter-by-letter here. So the program must find the character "9" and replace _it_ with the found text (here it's "9"), then it must find "8" and replace it with the found text (that is by now must have updated to "8"), and so on. The behaviour of the "Replace" and "Replace All" buttons must differ only in the range of cells they operate on, and must be identical if there's only one cell with matching text and it's selected. --------------------------------------------------------------------- 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]
