Issue 68545 - Find/replace by default within formula
Summary: Find/replace by default within formula
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.0.3
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-08-11 15:41 UTC by allart
Modified: 2013-08-07 15:12 UTC (History)
2 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description allart 2006-08-11 15:41:10 UTC 
If you want to find and replace all in a spreadsheet, the changes will be done
within the data and within the formula.

Try to replace all "A" by "". You will can see that, for example, "=A2" is
replaced by "=2".

Expanding additionnal options in the "search and replace" dialog will show that
the default is set to "Formula".

I'm not sure that changing cell ids within formula is the more frequent or the
more intuitive option for an end user.

And anyway, changes should be done only within formula, if this option is set.

Best regards,

Ph.

--
Comment 1 kpalagin 2006-09-14 07:36:21 UTC 
allart,
I am changing your issue to "ENHANCEMENT".
Comment 2 allart 2006-09-14 10:28:07 UTC 
OK,

I could see that Excel has the same behavior, except that the GUI doesn't seem
to allow to deactivate it.
Perhaps, it's a feature... :-)

Ph.

--
Comment 3 frank 2006-09-19 14:06:44 UTC 
one for requirements