Issue 95840 - Backwards search
Summary: Backwards search
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 1.0.0
Hardware: PC All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2008-11-04 17:04 UTC by dirty_harry
Modified: 2013-12-29 15:22 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

spreadsheet based on comment 1 (10.61 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-12-29 15:22 UTC, Edwin Sharp
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description dirty_harry 2008-11-04 17:04:20 UTC

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
Comment 1 dirty_harry 2008-11-04 17:25:29 UTC
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
Comment 2 Edwin Sharp 2013-12-29 15:22:06 UTC
Confirmed with 
AOO410m1(Build:9750)  -  Rev. 1551264
2013-12-17_04:10:52 - Rev. 1551455
Comment 3 Edwin Sharp 2013-12-29 15:22:47 UTC
Created attachment 82186 [details]
spreadsheet based on comment 1