I think the following is quite annoying:

Open a new sheet and create a column of numbers longer the the number of
rows visible. S
elect A1.
Open a dialog with an expresion entry widget, eg. cell-format/validation,
solver/constraints, descriptive stats tool, etc.
Do whatever necessary to make the entry widget in that dialog active.
Scroll to the bottm of the list of numbers on the sheet.
Select the last item.

Sheet autoscrolls to make the selected cell (A1) visible. This is
especially annoying if there are more expr entry widgets in the dialog eg.
solver/constraints since it is likely that the next cell/range to be
selected is in the vicinity of the last cell selected. Moreover there is no
reason why  the sheet should autoscroll to the selection!