Apache OpenOffice (AOO) Bugzilla – Issue 95840
Backwards search
Last modified: 2013-12-29 15:22:58 UTC
Hello, Could you tell me why the "&" sign in regular expression is correctly identified in spreadsheet an word processor modules, except in the macro editor module, and up to the 2.4.x versions at least ? In fact, in the macro editor module, "&" doesn't replace the expression in searching zone, and is not translated . For example, if I enter "&def" in replacing zone and "abc" in searching zone, then "abc" text in macros will be replace by &def, while spreadsheet and word processor modules will replace correctly abc by abcdef. Moreover, I don't understand why results of "searching and replacing" dialog box using "replacing all" are very different sometimes, between clicking in options: - active selection only - "upwards" ("VERS LE HAUT" in french version options), - regular expressions and removing "upwards" click . I noticed this difference especially in the spreadsheet module . Thank you in advance . I am at your disposal for further information
In the spreadsheet module, if I want to research and replace the five first characters in the list below for example, using "^....." in searching zone, and "&@&" in replacing zone, will not produce the same results if I click "upwards" or not in options. Results are correct with "upwards" 10-24-2008 02:51:17 10-24-2008 02:53:17 10-24-2008 02:56:00 10-24-2008 02:57:07 10-24-2008 05:55:00 10-24-2008 05:55:29 10-24-2008 05:55:29 10-24-2008 05:55:30 10-24-2008 05:55:39 10-24-2008 05:56:08 10-24-2008 05:57:19
Confirmed with AOO410m1(Build:9750) - Rev. 1551264 2013-12-17_04:10:52 - Rev. 1551455 Debian
Created attachment 82186 [details] spreadsheet based on comment 1