The Solver Dialog allows entering a cell reference using the shrinked mode or
just by clicking on the spreadsheet in the background. This delivers very
strange entries like

   $A$1:A1

Although there is no bad impact on the Solver´s function so far, this is
confusing users very much.

Step by Step:

1) Open the Solver Dialog

2) Set the cursor into the "Target Cell" field

3) Click to the spreadsheet in the background, for example click cell A1. The
cell reference $A$1 will be shown in the "Target Cell" field.

4) Set the cursor into the "Value of" field

5) Click to the spreadsheet in the background, for example click cell A1. The
cell reference $A$1 will be shown in the "Value of" field.

Everything is fine so far.

6) Now, set the cursor into any other field, that is supposed to contain a cell
reference, e.g. the fields "By changing cells", "Cell reference" or "Value".

7) Click to the spreadsheet in the background, for example click cell A1. What
you get is: $A$1:A1 but you should get: $A$1

8) Drag a cell range in the spreadsheet in the background, for example drag from
cell A1 to cell B5. What you get is: $A$1:B5 but you should get: $A$1:$B$5

I will attach a screenshot.