Issue 114841

I believe this is covered by Issue 35093

"Find & replace" if we made a selection, displayed in gray checked the 
box "Current selection only", and look to the side of the box "Match case" 
(very important and urgent change to be made, in the Spreadsheet, Calc)

When you make a selection and then click "Find and Replace" must always be 
changed only in the selection.

For this reason, the user has made the selection.

Always has been. Since the mid 80's, spreadsheets, Multiplan, Lotus
123, Excel.

Changes to be made, in summary:
Change 1) If a selection is made. automatically activate "Current selection 
only", and this box is in gray.

Change 2) If you first click on "Find and Replace" and then make a selection
also, same thing.

Change 3) (very important) Boxes "Current selecction only" and "Regular 
Expression" must be to the right of "Match case" and "Entire Cells", without 
having to press "Fewer Options."

To modify database from CSV spreadsheet
"Find & replace" is used a lot,
and if you make a selection,
bound only to be replaced in the selection,
why such selection is made.
(AND IDEALLY, THAT IS, WHAT YOU NEED TO CHANGE IS:)
to see, instantly, to open "Find & repolace" the box "Current seleectio only" 
is selected and gray, by default, when making a selection,
without pressing "option Fewer",

And so it saves many clicks, and get the job done in a third of the time.
Thing, that makes perfectly Excel, Lotus 123, Multiplan, etc

For databases with CSV files, often used to modify spreadsheet because the 
spreadsheet can be modified by selected columns, like a field.
Therefore, "Find & Replace" is used many, many times.

And make this change, save many clicks, because in this way, do not check 
constament, if activated or not, the box, "Current selection only".

Because we have to view it, at first sight. that is, right away, open the "Find 
& replace".

----------------------------------------
Not having to constantly check,
if this box checked for "Current selection only"
This saves you many clicks and time.
----------------------------------------

This change has to be done, because as it stands now, it takes three times as 
long, and if you make this change, it would take one third of time

As you do it correctly Excel, Lotus 123, Multiplan, etc.

It is something standard, that goes without saying, and is international. There 
are bound to do.

not a P1

Please, you can put part of the code here, to get started on the subject.
(Is that for a change, something completely different, we were 2 years, which 
was that if you put the sign - or + at the beginning of an addition or 
subtraction of cells was not necessary to put an equal sign at the beginning, 
and I would like this one change was faster is better).

Proposal to change even better:

Change 1) "Current selection only" with box,
must be transformed,
in only one phrase without box.

That what is a simple warning that "Find & replace"
will act only on the selection.
That is, a phrase. Without box.

Or whatever. If a selection is made, displays a phrase that says "Current 
selection only".

Change 2) If you first click on "Find & replace" and then makes a selection,
also, same thing.

Change 3) (very important)
* The phrase "Current selection only"
* And the box "Regular Expression"
must be to the right of "Match case" and "Entire Cells", without 
having to press "Fewer Options."

Change 4) If no selection, do not display the phrase, "Current selection only."

The change is best to do it this way:

Step 1) Change of position:
* The phrase "Current selection only"
* And the box "Regular Expression"
must be to the right of "Match case" and "Entire Cells", without 
having to press "Fewer Options."

 (The change of position, is the most important step of all steps to do.
Well, now, the program aims to save the box, but often the wrong stores.
Then you're forced to always check to see whether or not activated, and 
therefore, press "Fewer option" to view it.
And therefore, to always having to check, are double or triple clicks, and 
therefore double or triple time.

And is that, once that is not activated properly, and do not do well, and to 
corrupt the entire worksheet.

This box "Current selection only" and "Regular Expressions", it is very 
important that they are to the right of "Match case" and "Entire Cells", 
WITHOUT HAVING TO PRESS "Fewer Options").

* Step 2) If selection:

If selected area
ALWAYS enabled by default,
box "Current selection only".


* Step 3) If no selection:

If no selected area
be disabled, and gray.

* Step 4) Things to remove:

NEVER memorize selection of the box.
Whether a selection is made before or after opening the window "Find & Replace."

(Also, is it wrong now, because if after opening the window "Find & replace, to 
make a new one, with the window open, do not memorize the activation of the box 
properly. Well this is a bug has, but how you have to remove the memorization, 
so ... That's it. Never store the selection of this box)

* Step 5) Verification of the source code and verification program:

Check that work properly,
whether the selection is made
before or after
to open the "Find & replace".

Good suggestions present in bug 112334.

*** This issue has been marked as a duplicate of issue 112334 ***

*** This issue has been marked as a duplicate of issue 35093 ***